Wednesday, December 7, 2011

Environment variable ORACLE_UNQNAME not defined

After successful installation of 11g release 2 grid infrastructure, when tries to start enterprise manager control, it raised error mentioned below:
                 Environment variable ORACLE_UNQNAME not defined, pleased set ORACLE_UNQNAME to database unique name.

        I simply executed following line at my linux command line with grid ouwner user i.e. oracle:

             export ORACLE_UNQNAM={DATABASE NAME}

        where DATABASE_NAME can be found via following command.

           select name from v$database;

       It simply solved my problem, and hope will help you as well.

Farrukh Salman.

4 comments:

  1. when I executed the ./emctl start dbconsole script it still says Environment variable ORACLE_UNQNAME not defined. Please set ORACLE_UNQNAME to database unique name.

    ReplyDelete
  2. Hi Alexander,
    Are you setting ORACLE_UNQNAM as oracle or grid infrastructure owner and it should have database name not the instance name.

    Regards.

    ReplyDelete
  3. It says ORACLE_UNQNAM, but must to say ORACLE_UNQNAME the letter E is the problem

    ReplyDelete