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 

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.