OracleDBConsoleorcl cannot be started.

Services, services, and TMD are disgusting. In the past, SYBASE was launched because the service could not be started for a whole period of time. Now oracle is the case and finally found a solution, as shown below:

Windows cannot start OracleDBConsoleorcl on a local computer. For more information, see System Event Logs. If this is a non-Microsoft Service, contact the service provider and refer to service error code 2.

Find the HOST file in the c: \ windows \ system32 \ drivers \ etc folder and add
192.168 .?.? (Your current IP address) localhost

 

If not, try the following:

 

　　OracleDBConsole [SID] Service Introduction

The OracleDBConsole [SID] Service is responsible for starting Oracle Enterprise Manager on the Windows platform and introducing this service from Oracle 10 Gb. It also starts from Oracle 10 Gb, and Oracle Enterprise Manager changes from client to browser operation mode, the [SID] Here is the Oracle SID. If it is installed by default, it is orcl, so this service may be OracleDBConsoleORCL on your machine. In fact, it is also on my machine.

This article is based on Oracle 11g and the operating system is Windows xp. Therefore, the solution described in this article is for reference only.

　　Fault description

After a normal use of the Enterprise Manager, restart the computer and restart the OracleDBConsoleORCL service again, the following message is reported:

Windows cannot start OracleDBConsoleORCL on a local computer. For more information, see System Event Logs. If this is a non-Microsoft Service, contact the service provider and refer to service error code 1.

The following error message is recorded in the Application Event Log:

Process exited abnormally during initialization.

 

Method 1:

Enter
Emctl start dbconsole
Error reported. ORACLE_SID is not defined
Input
Set ORACLE_SID = ORCL (ORCL is my Instance name and service name)
No problem. Enter
Emctl start dbconsole
Prompt
.
Copy the OC4J_DBConsole_HOSTNAME_orcl folder under j2ee, rename it to OC4J_DBConsole_192.168.1.103_orcl, copy the HOSTNAME_orcl folder under db_1, and rename it 192.168.1.103 _ orcl.
Restart dbconsole. The service is successfully started.

 

Method 2:

The attempt to start the service from the command line also ended in failure. I was wondering whether to delete the database and re-install it. I suddenly remembered that Oracle Enterprise Manager is actually a separate component, you can delete it separately and reinstall it. In fact, it is not to delete the Oracle Enterprise Manager, but the Oracle Database Console archive. Deleting the archive will also delete the OracleDBConsoleORCL service, delete the user SYSMAN and its objects, re-create the archive, and add the OracleDBConsoleORCL service again, and create the SYSMAN user and its objects. After figuring out the relationship, start to implement repair.

First, delete the archive. Note that the Oracle listener service and Database Service must be in the starting state, because the DELETE command will connect to the database to delete sysman users and their objects:

C: \> emca-repos drop

Emca started at 9:13:24

Em configuration assistant, 11.1.0.5.0 official version

Copyright (c) 2003,200 5, Oracle. All rights reserved.

Enter the following information:

Database Sid: orcl

Listener port: 1521

Sys User Password: [enter the Sys user password. The screen will not display the password when you enter the password]

Password of the sysman User: [enter the password of the sysman user]

Password of the sysman User:

Continue? [Yes (y)/NO (n)]: Y

9:15:04 oracle. sysman. emcp. emconfig perform

Information: The operation is being recorded in c: \ app \ Administrator \ export toollogs \ emca \ orcl \ emca_2009_01

_ 31_09_13_24.log.

9:15:05 oracle. sysman. emcp. emreposconfig invoke

Information: deleting the EM archives. This operation may take some time )...

Start waiting for deletion. This process may take a long time. Come and have a rest.

After deletion, some people often think of using commands to re-create the archive. However, after many attempts, the oracledbconsoleorcl service cannot be started after the archive is created, the Enterprise Manager still cannot be used. Therefore, dbca is used to create a database. In the running window, enter dbca to start the Database Configuration assistant. In the first step, select "Configure Database options ", you only need to click Next for subsequent operations. Note that you must select the EM data file library when selecting whether to use the EM data file library. It is not selected by default, dbca checks that the system does not have the EM data archival library, so it will re-create it, And the oracledbconsoleorcl service will be re-added, which will take some time, if no error occurs during the dbca reconfiguration, The oracledbconsoleorcl service can be started properly after the configuration is complete and the Oracle Enterprise Manager can be used normally. If the EM data archival library is not completely deleted, an error may be reported during dbca operation. Generally, sysman users and their objects are not deleted. In this case, you only need to run emca once again.
-Repos drop.

If you delete the sysman user and its objects When deleting the EM archives, but the oracledbconsole [Sid] service is not deleted, if the service can be started and can be accessed through a browser, then you can use emca-repos create to re-create the EM data archival library.

　　Summary

After this adventure, I always think that Oracle's oracledbconsole [Sid] service is very fragile. After restarting the computer without any misoperation, it may not be able to start, but at this time, everyone must stay calm, think more, and there are always ways to do it. We recommend that you do not reinstall the system before restarting the system, stop the oracledbconsole [Sid] service, listener service, and database service manually.

 

After online query, we know that the network port is already used. Use the following method to solve the problem:

Emca-config dbcontrol DB-dbcontrol_http_port 5508-agent_port 3940-rmi_port 5524-jms_port 5545

Stop EM again and start EM again.

Emctl stop dbconsole

Emctl start dbconsole

However, please note that if your computer's IP address is not fixed, the network will be disconnected when Oracle is installed (disabling and network disconnection are two different concepts), so there will be no problems with the installation, in addition, when starting the service and listening service, there cannot be a network, because if there is a network, oracle will be automatically configured, so the above problems will occur, it is best to set the two services as manual.

That is, in what IP environment is the database installed, the service can be started in this case

If the odtwithodac11000021 tool is installed, the following error occurs during PL/SQL connection.

Pl/SQL ora-12154

My approach is to modify the PATH variable.

 

Before modification, enter: D: \ Oracle11 \ product \ 11.1.0 \ client_1; D: \ Oracle11 \ product \ 11.1.0 \ client_1 \ bin; D: \ Oracle11 \ product \ 11.1.0 \ db_1 \ bin; % SystemRoot % \ system32; % SystemRoot % \ System32 \ Wbem; C: \ Program Files \ Common Files \ Thunder Network \ KanKan \ Codecs; C: \ Program
Files \ Microsoft SQL Server \ 90 \ Tools \ binn \; D: \ Program Files \ CodeSmith \ v5.0 \

Changed to: D: \ Oracle11 \ product \ 11.1.0 \ client_1; D: \ Oracle11 \ product \ 11.1.0 \ client_1 \ bin; D: \ Oracle11 \ product \ 11.1.0 \ db_1; d: \ Oracle11 \ product \ 11.1.0 \ db_1 \ bin; % SystemRoot % \ system32; % SystemRoot % \ System32 \ Wbem; C: \ Program
Files \ Common Files \ Thunder Network \ KanKan \ Codecs; C: \ Program Files \ Microsoft SQL Server \ 90 \ Tools \ binn \; D: \ Program Files \ CodeSmith \ v5.0 \

 

I am using a flash connection to connect to the network .. After the ip address under the file is changed, it is okay to disconnect the network and start it.

 

Method 3:

Start the computer today, go to the login interface, the computer reported a Service Startup failure, the computer does not have new software installed, there is no problem on Saturday, how to 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 is used, 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 you restart the computer. The OracleDBConsoleorcl service is also started.