After installing the database can be started, restart the computer, the manual start will be error.
Phenomenon:
Windows cannot start ORACLEDBCONSOLEORCL on the local computer. For more information, consult the system event log. If this is a non-Microsoft service, contact your service vendor and refer to the specific service error code 2.
System Event Log report Error "Agent process exited abnormally during initialization."
Situation: Normal, the computer name changes or the IP address has changed, can not be started,
Workaround one: The steps to resolve are as follows:
1. Start-"Run cmd"
2. Execute Emctl start Dbconsole
C:\Documents and Settings\xcl>emctl start Dbconsole
environment variable ORACLE_SID not defined. Please define it.
Hint: The environment variable oracle_sid is undefined, please define it.
3, set Oracle_sid =ORCL (ORCL is my instance name, is also the service name)
C:\Documents and Settings\xcl>set ORACLE_SID=ORCL
4, re-execute emctl start dbconsole
C:\Documents and Settings\xcl>emctl start Dbconsole
Oc4j Configuration issue. E:\ORACLE\PRODUCT\10.2.0\DB_1/OC4J/J2EE/OC4J_DBCONSOLE_CHINA-D9E3F7D07_ORCL not found.
Tip: Unable to find "E:\ORACLE\PRODUCT\10.2.0\DB_1/OC4J/J2EE/OC4J_DBCONSOLE_CHINA-D9E3F7D07_ORCL"
Note: China-d9e3f7d07 is the name of my Computer
Copy the "OC4J_DBCONSOLE_LOCALHOST_ORCL" folder under the directory in the same directory and change the name to "OC4J_DBCONSOLE_CHINA-D9E3F7D07_ORCL".
5, re-execute emctl start dbconsole
C:\Documents and Settings\xcl>emctl start Dbconsole
EM Configuration issue. E:\ORACLE\PRODUCT\10.2.0\DB_1/CHINA-D9E3F7D07_ORCL not found.
Tip: Unable to find "E:\ORACLE\PRODUCT\10.2.0\DB_1/CHINA-D9E3F7D07_ORCL"
Copy the "LOCALHOST_ORCL" folder under the directory in the same directory and change the name to "CHINA-D9E3F7D07_ORCL".
6, re-execute emctl start dbconsole
C:\Documents and Settings\xcl>emctl start Dbconsole
Oracle Enterprise Manager 10g Database Control Release 10.2.0.1.0
Copyright (c) 1996, 2006 Oracle Corporation. All rights reserved.
http://localhost:1158/em/
Starting Oracle Enterprise Manager 10g Database Control ... Oracledbconsoleorcl
Service is starting
..............................
ORACLEDBCONSOLEORCL Service has started successfully
This method can be successful.
Solution Two first disable the network card, start the Dbconsole service, and then enter the Http://localhost:1158/em, if you want to surf the internet, and then start the network card, ok!
Disadvantage: Every time you have to disable the network card can start, trouble!
Solution three set pensive NIC, in Control Panel, click Add Hardware Select Microsoft Lookback adapter, go to Network Places, Internet connection, set any IP, start, Oracle, Configuration and porting tools, netconfiguration Assistant Add the IP of the pensive network card to save.
Copyright NOTICE: This article for Bo Master original article, without Bo Master permission not reproduced.
Oracle--windows cannot start ORACLEDBCONSOLEORCL on the local computer. Error code 1