This discussion is archived
7 Replies Latest reply: Aug 21, 2013 11:34 PM by Pradeepcmst RSS

ORACLE_UNQNAME meaning?

MR.L Newbie
Currently Being Moderated

ORACLE_UNQNAME What does this mean?

ORACLE_UNQNAME 是功能是什么?

  • 1. Re: ORACLE_UNQNAME meaning?
    Pradeepcmst Journeyer
    Currently Being Moderated

    The ORACLE_UNQNAME is an operating system environment variable that holds the database’s unique name value. You can find it with the following query as the SYSTEM user (through SQL*Plus):

    SELECT name, db_unique_name FROM v$database;

    The following link will give more detail.

    How to configure and run Oracle 11gR2 DB Console (OEM) | MacLochlainns Weblog


  • 2. Re: ORACLE_UNQNAME meaning?
    MR.L Newbie
    Currently Being Moderated

    Thank you for your answer!

     

    What is the difference with ORACLE_SID ?

  • 3. Re: ORACLE_UNQNAME meaning?
    Pradeepcmst Journeyer
    Currently Being Moderated

    New in 11.2 is the environment variable ORACLE_UNQNAME and it is used with the OEM dbcoconsole. The value for db_unique_name database parameter is the value for  ORACLE_UNQNAME...

     

    For a Standalone server, most probably the ORACLE_UNQNAME and ORACLE_SID would be same. So when u run or check the status of dbconsole, it may ask you to set "Environment variable ORACLE_UNQNAME not defined. Please set ORACLE_UNQNAME to database unique name". You can set and proceed.

     

    For RAC, the dbconsole service runs as a single service. Assume you have 3 node RAC with ORCL database running on all 3. And obviously orcl1, orcl2 and orcl3 are the 3 instances. Assume the dbconsole service is running on node 2, then you need to set ORACLE_UNQNAME=orcl (i.e. db_unique_name) in that node 2(since the service is running in that machine.

     

    For Dataguard, You would've created a separate db_unique_name for primary and standby databases(recommended), eventhough the database name(db_name) is same for both primary and standby. So in that case, you can use db_unique_name from where the dbconsole service is running to set the ORACLE_UNQNAME

  • 4. Re: ORACLE_UNQNAME meaning?
    MR.L Newbie
    Currently Being Moderated

    thanks!

    In rac environment

      Two nodes "ORACLE_UNQNAME" needs to be set to the same value.

    For example: node1 ORACLE_UNQNAME = racdb

             node2 ORACLE_UNQNAME = racdb

    Right?

  • 5. Re: ORACLE_UNQNAME meaning?
    Pradeepcmst Journeyer
    Currently Being Moderated

    Yes , You are conceptually right.  But again you need to see where the dbconsole service is running. If its running in node1, set OS environment variable  ORACLE_UNQNAME = racdb in node 1 to run the dbconsole. If the dbconsole service is running in node2, set ORACLE_UNQNAME = racdb in node 2...  Hope this would've cleared .. :-)

  • 6. Re: ORACLE_UNQNAME meaning?
    MR.L Newbie
    Currently Being Moderated

    Pradeepcmst

    Thanks again

  • 7. Re: ORACLE_UNQNAME meaning?
    Pradeepcmst Journeyer
    Currently Being Moderated

    Welcome MR. L. Please mark this thread as answered, so that others find it useful... 

     

    Cheers,

    Pradeep. V

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points