Environment variable ORACLE_UNQNAME not defined. Please set ORACLE_UNQNAME to da tabase unique name

emctl status dbconsole command gives error “Environment variable ORACLE_UNQNAME not defined. Please set ORACLE_UNQNAME to database unique name”. How to fix this error? Add environment variable.

Go to Start > Control Panel > System

image

On the left press Advanced System Options

image

Go to Environment Variables…

image

Pres New…

image

Enter Variable name “ORACLE_UNQNAME” and Variable value “orcl”. Variable value you can find in Control Panel > Services list. Find service OracleServiceXXX, where suffix XXX is your Oracle service name. This suffix goes as environment variable value.

image 

In New System Variable dialog box press OK. In Environment variables window press OK. In System Properties window press OK. Close System window in Control Panel.

Start command window again and enter command

echo %ORACLE_UNQNAME%

Output line should show

ORCL

About these ads

About karalius

C# developer, IIS master
This entry was posted in Uncategorized. Bookmark the permalink.

3 Responses to Environment variable ORACLE_UNQNAME not defined. Please set ORACLE_UNQNAME to da tabase unique name

  1. rubbal bhusri says:

    I did exactly what u suggested here, and it worked fine in setting ORACLE_UNQNAME to “orcl”,
    but when I ran command C:\oracle_base\product\11.2.0\dbhome_1\BIN>emctl status dbconsole.
    It showed the “OC4J configuration issue” warning saying it did not find OC4J_DBconsole_rubbalbhusri-PC_orcl, in directory : C:\oracle_base\product\11.2.0\dbhome_1\oc4j/j2ee.

    rubbalbhusri-PC is my system name.

  2. Mohammed says:

    add ORACLE_HOSTNAME=localhost

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 )

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s