Solve the problem that OracleDBConsoleorcl cannot be started and an error code is returned

Source: Internet
Author: User

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.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.