The service name is invalid When starting the Database Control
692313Sep 26 2009 — edited Oct 15 2012Dear Oracle Expert,
I have installed Oracle database 11g on Windows Professional x64 Edition Version 2003 Service Pack 2..
When I try to start the Database control after renaming the IP_address to the local machine name which is robert. It prompts back with an error.
C:\>emctl status dbconsole
Environment variable ORACLE_SID not defined. Please define it.
C:\>set ORACLE_SID=ocp11g
C:\>emctl status dbconsole
Oracle Enterprise Manager 11g Database Control Release 11.1.0.6.0
Copyright (c) 1996, 2007 Oracle Corporation. All rights reserved.
https://192.168.1.67:1158/em/console/aboutApplication
Oracle Enterprise Manager 11g is not running.
C:\>emctl start dbconsole
Oracle Enterprise Manager 11g Database Control Release 11.1.0.6.0
Copyright (c) 1996, 2007 Oracle Corporation. All rights reserved.
https://192.168.1.67:1158/em/console/aboutApplication
Starting Oracle Enterprise Manager 11g Database Control ...The service name is i
nvalid.
More help is available by typing NET HELPMSG 2185.
C:\>hostname
robert
C:\>emctl status dbconsole
OC4J Configuration issue. C:\app\Administrator\product\11.1.0\db_1/oc4j/j2ee/OC4
J_DBConsole_192.168.1.67_ocp11g not found.
C:\>set ORACLE_SID=ocp11g
C:\>emctl status dbconsole
OC4J Configuration issue. C:\app\Administrator\product\11.1.0\db_1/oc4j/j2ee/OC4
J_DBConsole_192.168.1.67_ocp11g not found.
C:\>emctl start dbconsole
OC4J Configuration issue. C:\app\Administrator\product\11.1.0\db_1/oc4j/j2ee/OC4
J_DBConsole_192.168.1.67_ocp11g not found.
C:\>SET ORACLE_HOME= C:\app\Administrator\product\11.1.0\db_1\oc4j\j2ee\OC4J_DBC
onsole_robert_ocp11g
C:\>set ORACLE_SID=ocp11g
C:\>emctl status dbconsole
OC4J Configuration issue. C:\app\Administrator\product\11.1.0\db_1/oc4j/j2ee/OC4
J_DBConsole_192.168.1.67_ocp11g not found.
C:\>emctl start dbconsole
OC4J Configuration issue. C:\app\Administrator\product\11.1.0\db_1/oc4j/j2ee/OC4
J_DBConsole_192.168.1.67_ocp11g not found.
C:\>
Thanks in advance.
Rlee