Today I run into problem running Oracle Database Control Service on Windows 2003 Server. When I was trying to run it using Administrative Tools->Services I got an error:
“Windows could not start the OracleDBConsoleWIND on Local Computer. For more information, review the System Event Log. If this is a non-Microsoft service, contact the service vendor, and refer to service-specific error code 2”.
Quick look in the Event Viewer proved it usless:
The OracleDBConsoleWIND service terminated with service-specific error 2 (0x2).
The solution came when I tried to run the service using console:set ORACLE_SID=wind
C:\ptc\PDMLink>emctl start dbconsole
OC4J Configuration issue. C:\oracle\ora102/oc4j/j2ee/OC4J_DBConsole_winddev1_wind not found.
Gotcha!
In C:\oracle\ora102/oc4j/j2ee/ directory I had only:OC4J_DBConsole_winddev1.devintl.com_wind
After some network reconfiguration the host started to appear using only host name, not fully qualified host name. Fair enough, I had just copied the folder to match current host name and the console is working again:
C:\ptc\PDMLink>emctl start dbconsole
Oracle Enterprise Manager 10g Database Control Release 10.2.0.1.0
Copyright (c) 1996, 2005 Oracle Corporation. All rights reserved.
http://winddev1.devintl.com:1158/em/console/aboutApplication
Starting Oracle Enterprise Manager 10g Database Control ...The OracleDBConsoleWI
ND service is starting...............
The OracleDBConsoleWIND service was started successfully.