Wednesday, June 29, 2011

Environment variable ORACLE_UNQNAME not defined.

I have a new install of 11.2.0.2 and upgraded the 10.2.0.4 database to 11.2.0.2.

As I said in my last post that the EM configuration failed during the upgrade of database by using dbua.
I was looking to workaround that problem by running emca, before that I wanted to see what it would show for status of dbconsole.

$ emctl status dbconsole
Environment variable ORACLE_UNQNAME not defined. Please set ORACLE_UNQNAME to database unique name.

I went and looked in the documentation here:
http://download.oracle.com/docs/cd/E11882_01/server.112/e10897/em_manage.htm#ADMQS032

Note:
If you are prompted to set the ORACLE_UNQNAME environment variable, then set this variable and run the emctl command again. Set the variable to the database unique name (the value of the DB_UNIQUE_NAME database parameter). A typical value for DB_UNIQUE_NAME is orcl.

For RAC:
=======
In case of RAC the dbconsole service runs from a single host.
Let's say you have three node RAC cluster with ORCL database running on all 3 of them. orcl1, orcl2, and orcl3 are the instance names.

Assume that dbconsole is running from node1, in that case if you would have to set, below parameter before running emctl commands :


ORACLE_UNQNAME=orcl (i.e. db_unique_name) 

HTH. 

1 comment:

  1. One qq. How is the ORACLE_UNQNAME should be defined in a single host server having two separate instances & databases need to be created ?

    ReplyDelete