About the ORACLE11GORACLEDBCONSOLEORCL service failed to start the problem

ORACLEDBCONSOLE[SID] Service Introduction.

The ORACLEDBCONSOLE[SID] service is responsible for launching Oracle Enterprise Manager under the Windows platform, introducing this service from Oracle 10g, and starting with Oracle 10g, Oracle's Enterprise Manager changed from client to browser operation mode, The [SID] here is the Oracle SID, and if the default installation is ORCL, the service may be ORACLEDBCONSOLEORCL on your machine, and it's actually on my machine.

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

Fault description

After a normal use of Enterprise Manager, restart your computer, and start the ORACLEDBCONSOLEORCL service again, report:

Windows cannot start ORACLEDBCONSOLEORCL on the local computer. For more information, check the system event log. If this is a non-Microsoft service, contact your service manufacturer and refer to the specific service error code 1.

The following error message is logged in the Application event log:

Process exited abnormally during initialization.

Resolution process

Trying to start the service from the command line is also a failure, wondering whether to remove the database and reinstall it, and suddenly think of Oracle Enterprise Manager is a separate component, you can delete it individually, and then reinstall, in fact, this is not the removal of Oracle Enterprise Manager, Instead of the Oracle Database console data archive, deleting the ORACLEDBCONSOLEORCL service and deleting the user Sysman and their objects, recreating the data archive will add the ORACLEDBCONSOLEORCL service again. and create Sysman users and the objects they belong to. After figuring out this relationship, begin to implement the fix.

First delete the data archive, and note that Oracle's Listener service and database service must be started at this point because the Delete command connects to the database to delete Sysman users and their objects:

C:>emca-repos Drop

EMCA started in 2009-1-31 9:13:24

EM Configuration Assistant, 11.1.0.5.0 official edition

Copyright (c) 2003,%, Oracle. All rights reserved.

Enter the following information:

Database SID:ORCL

Listener Port number: 1521

SYS user's password: "Enter the password for the SYS user and the screen will not be returned when the password is entered"

Sysman Password for User: "Enter password for Sysman user"

Sysman User's password:

Do you want to continue? [Is (y)/No (N)]: Y

2009-1-31 9:15:04 Oracle.sysman.emcp.EMConfig Perform

Info: Logging This action to c:\app\Administrator\cfgtoollogs\emca\orcl\emca_2009_01

_31_09_13_24.log.

2009-1-31 9:15:05 Oracle.sysman.emcp.EMReposConfig Invoke

Info: Removing the EM data archive (this operation may take some time) ...

Start waiting for deletion, the process may be longer, a cup of coffee, rest.

After the deletion, people often think of using the command to recreate the data archive, but after I tried many times, using this method to create a good data archive, the ORACLEDBCONSOLEORCL service still can not start, Enterprise Manager is still unable to use, so think of using DBCA to create, Then in the Run window input: DBCA, start the database configuration Assistant, in the first step, select "Metabase Options", the following operation only need to continue to click the next step on it, note that in choosing whether to use the EM data archive, be sure to select, the default is not selected, DBCA checked to the system there is no EM data archive, so it will be recreated, the ORACLEDBCONSOLEORCL service will also be added, which will also take a while, if DBCA reconfiguration process does not occur, after the configuration is over, The ORACLEDBCONSOLEORCL service is able to boot normally, and Oracle Enterprise Manager can be used properly. If you delete the EM data archive is not thorough, run DBCA period may be an error, generally sysman users and their objects are not deleted clean, encounter this problem, only need to run once emca–repos drop can.

If the Sysman user and his or her object are deleted when the EM data archive is deleted, but the Oracledbconsole[sid service is not deleted, if the service can be started and can be entered through the browser, then you can use the Emca–repos Create recreate the EM data archive.

Summarize

After this adventure, always feel that Oracle's ORACLEDBCONSOLE[SID] service is very fragile, in the absence of any misoperation, restart the computer, it may not start, but at this time, we must keep calm, think more, there are always ways, not to the last resort, Do not reinstall, we recommend that you manually stop the ORACLEDBCONSOLE[SID] service, the listener service, and the database service before restarting the system.
This article is reproduced to https://www.2cto.com/database/201703/606402.html