Environment variable ORACLE_UNQNAME not defined in EM status.

Environment variable ORACLE_UNQNAME not defined in EM status.

When you execute the following command to check the status of dbconsole service it will give you the below error.

C:\> emctl status dbconsole

Environment variable ORACLE_UNQNAME not defined.

Please set ORACLE_UNQNAME to database unique name.

Solution

1. Need to set the following two parameters

Oracle_hostname
Oracle_unqname

2. Go to the following directory in oracle home:

%ORACLE_HOME%\oc4j\j2ee\

3 Check the following file: It will give you the exact value which set during installation:

OC4J_DBConsole_localhost_orcl

4.  You need to set the name as localhost and unqname as orcl which you find as name in above file

set oracle_hostname=localhost
set oracle_unqname=orcl

5. Again check the status of emctl dbconsole service

emctl status dbconsole

Hopefully solution will work and your problem is resolved.

For Start the enterprise manager
emctl start dbconsole
For Stop the enterprise manger 
emctl stop dbconsole
check the following URL:  https://localhost:1158/em 

Leave a Reply