I came to the company to start my computer today. On the login page, my computer reported that a service failed to start. My computer had no new software installed and there was no problem on Saturday. Why did I suddenly report this error? So I went to the Event Viewer to see what the problem was. It showed that OracleDBConsoleorcl failed to start. I checked that it was not started in the service. Start it manually. Error Code 2 is returned.
I installed 10 Gb, so I went to the ORACLEproduct10.2.0db _ 1test_orclsysmanlog directory to check what was written in the log and opened OracleDBConsoleorclsrvc. log.
The log records the following:
----- [OracleDBConsoleorcl] ----
EMDROOT = c: oracleproduct10.2.0db _ 1
ORACLE_HOME = c: oracleproduct10.2.0db _ 1
EMDSTATE = c: oracleproduct10.2.0db _ 1wangzh_orcl
Lele_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_orclsysmanlogemdblele.nohup for details
The log shows the emdbconsole. nohup file. This file is not found in the directory.
Run emctl manually. bat, so start the console and execute emctl. bat istart dbconsole, error reported. ORACLE_SID is not defined. Enable emctl. bat, here is the place where the environment variables are defined, and these have been set:
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)
......
There is another setting:
If not defined DBCONSOLE_SERVICE_NAME (set DBCONSOLE_SERVICE_NAME = OracleDBConsole % ORACLE_SID %),
ORACLE_SID, but the preceding settings are not displayed. You can only set ORACLE_SID manually. Therefore, a setting is added:
If defined REMOTE_EMDROOT (set ORACLE_SID = orcl) orcl is the name of my database instance
Start OracleDBConsoleorcl in the service, OK, no error is reported;
No error is reported when the computer is restarted. The OracleDBConsoleorcl service is also started.