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
