Please see my other blog for Oracle EBusiness Suite Posts - EBMentors

Search This Blog

Note: All the posts are based on practical approach avoiding lengthy theory. All have been tested on some development servers. Please don’t test any post on production servers until you are sure.

Wednesday, March 14, 2012

Oracle DBConsole service failed to start on Windows

If you have a database control of any database version on WINDOWS Operating System, some times OracleDBConsole Service failed to start with the following error, cause is not determined .


C:\>net start OracleDBConsole
The OracleDBConsolet service is starting..
The OracleDBConsole service could not be started.

If you check the status by using emctl  you can get the output below which is wrong.

D:\app\Inam\product\11.2.0.3\dbhome_1\BIN>set ORACLE_UNQNAME=HOMERAC

D:\app\Inam\product\11.2.0.3\dbhome_1\BIN>emctl status dbconsole
Oracle Enterprise Manager 11g Database Control Release 11.2.0.3.0
Copyright (c) 1996, 2011 Oracle Corporation.  All rights reserved.
https://OR-11:1158/em/console/aboutApplication
Oracle Enterprise Manager 11g is running.
------------------------------------------------------------------
Logs are generated in directory D:\app\Inam\product\11.2.0.3\dbhome_1/or1_HOMERAC/sysman/log

D:\app\Inam\product\11.2.0.3\dbhome_1\BIN>

To resolve the issue you can check the event viewer either of the below steps:
a) Start--> Run--> enter eventvwr
or
b) Start-> COntrol panel-->AdministrativeTools-->Event Viewer

  1. Stop the database control
  2. Please check if there is any process running with emagent, if so, kill/end the process.
  3. Delete the following files
    /hostname_SID/emctl.pid
    /hostname_SID/emctl.pid_agent
  4. Now start the DBConsole from the services panel or by using the command "net start OracleDBConsole" or from control panel

This will start the service without any issues.


Some times agent is running and due to this reason the dbconsole service is not get started , you should check its status also and stop.
D:\app\Inam\product\11.2.0.3\dbhome_1\BIN>emctl status agent
Oracle Enterprise Manager 11g Database Control Release 11.2.0.3.0
Copyright (c) 1996, 2011 Oracle Corporation.  All rights reserved.
---------------------------------------------------------------
Agent Version     : 10.2.0.4.4
OMS Version       : 10.2.0.4.4
Protocol Version  : 10.2.0.4.4
Agent Home        : D:\app\Inam\product\11.2.0.3\dbhome_1\or1_homerac
Agent binaries    : D:\app\Inam\product\11.2.0.3\dbhome_1
Agent Process ID  : 644
Agent URL         : https://OR-11:3938/emd/main
Repository URL    : https:/OR-11:1158/em/upload/
Started at        : 2012-03-13 15:04:46
Started by user   : SYSTEM
Last Reload       : 2012-03-13 15:04:46
Last successful upload                       : 2012-03-13 15:07:39
Total Megabytes of XML files uploaded so far :    12.29
Number of XML files pending upload           :        3
Size of XML files pending upload(MB)         :     0.19
Available disk space on upload filesystem    :    27.27%
Data channel upload directory                : D:/app/Inam/product/11.2.0.3/dbhome_1/or1_homerac/sysman/recv
Last successful heartbeat to OMS             : 2012-03-13 15:07:27
---------------------------------------------------------------
Agent is Running and Ready


No comments: