Solve OracleDBConsoleorcl not start, Baocuo error
Posted on | January 14, 2010 | No Comments
Today you start your computer, to the login interface, the computer reported that a service failed to start, computer does not have newly installed software, Saturday not have a problem, how suddenly reported this error? Took the case to the Event Viewer to see what the issue showed that OracleDBConsoleorcl startup failure, to the service where a look, really does not start.Manually start clicking, Baocuo Error 2
I installed the 10g, then to the ORACLEproduct10.2.0db_1test_orclsysmanlog directory inside look at the log what is written on, open OracleDBConsoleorclsrvc.log.
the last log record is:
—– [OracleDBConsoleorcl] —-
EMDROOT = c: oracleproduct10.2.0db_1
ORACLE_HOME = c: oracleproduct10.2.0db_1
EMDSTATE = c: oracleproduct10.2.0db_1wangzh_orcl
CONSOLE_CFG = dbconsole
TRACE_LEVEL = 16
TIMEOUT = 15
12/10/07 10:56:03 Start pending …
12/10/07 10:56:03 Verifying dbconsole is not started already. Command line “c: oracleproduct10.2.0db_1binemctl.bat” istatus dbconsole
12/10/07 10:56:04 dbconsole launch commandline is “c: oracleproduct10.2.0db_1binemctl.bat” istart dbconsole
12/10/07 10:56:04 Tracking process launch …
12/10/07 10:56:34 dbconsole exited with retCode 2.
12/10/07 10:56:34 Check c: oracleproduct10.2.0db_1test_orclsysmanlogemdbconsole.nohup for details
Let look at emdbconsole.nohup log files, directories, where there is no such file 呀.
Manually look emctl.bat, then start the console, the Executive emctl.bat istart dbconsole, Baocuo, ORACLE_SID is not defined, open emctl.bat look, here is where the definition of environment variables, which has been set up these:
if not defined REMOTE_EMDROOT (set ORACLE_HOME = Ec: oracleproduct10.2.0db_1)
if not defined REMOTE_EMDROOT (set EMDROOT =% ORACLE_HOME%)
if defined REMOTE_EMDROOT (set ORACLE_HOME =% REMOTE_EMDROOT%)
if defined REMOTE_EMDROOT (set EMDROOT =% ORACLE_HOME%)
if defined REMOTE_EMDROOT (set LOCAL_EMDROOT = c: oracleproduct10.2.0db_1)
… …
Behind there is a setting:
if not defined DBCONSOLE_SERVICE_NAME (set DBCONSOLE_SERVICE_NAME = OracleDBConsole% ORACLE_SID%), use the ORACLE_SID, but did not see the previous settings, can only be manually set ORACLE_SID try, then added a setting:
if defined REMOTE_EMDROOT (set ORACLE_SID = orcl) orcl is my database instance name
To the service to start OracleDBConsoleorcl, ok, there is no Baocuo;
Restart the computer, and no Baocuo, OracleDBConsoleorcl services are started.
Oracle Certification include exams: 1z0-042 1z0-043 1z0-047
