emctl for database control
I keep getting this error when trying to run emctl command to start, stop or check status of Database Control.
"Environment variable ORACLE_UNQNAME not defined. Please set ORACLE_UNQNAME to database unique name."
Using from command prompt (C:), I have set the following:
set ORACLE_SID = orcl
set ORACLE_HOME = C:\app\myusername\ product\11.2.0\dbhome_3
I also set ORACLE_UNQNAME = ORCL as per error description
dbhome_3 is the latest home folder that got installed on my machine. The older ones are dbhome_1 and dbhome_2 which I think are old homes..
I have researched extensively on oracle threads but still unable to find a solution
0