How to Start Database Control (dbconsole) , Enterprise Manager do not Start

During the installation of the Database Control (Enterprise Manager) the following files are created:

1. Repository Files

2. Configuration Files

These files contains the  information about the database, the listener and the hostname in which it is installed. Any changes in these three files after the database installation.If any problem arise then the solution is to re-configure these files which we will discuss below.

First lets discuss on which files and directories are created during the installation of database Control.

Database Control Configuration files

The configuration file are located in the following locations.

1
2
ORACLE_HOME/<hostname_sid>
ORACLE_HOME/oc4j/j2ee/OC4J_DBConsole_<hostname>_<sid>

 

Now , if these files are missing or your database console is not working first make sure these configuration file exists. If not exists then recreate these files which we will discuss very soon . First let me explain ho to remove the database console files.

You can either manually delete the above directories or you can emca. If you are using emca the command to delete the configuration files is:

1
2
ORACLE_HOME/bin/emca – deconfig dbcontrol db (10gR2 and higher)
ORACLE_HOME/bin/emca –x <sid> (10gR1)

When using emca it is possible that the changes that caused the problem with Database Control starting also prevent emca from deleting the configuration files. Under this situation you can manually delete these file as:

[oracle@localhost~]$ cd $ORACLE_HOME
[oracle@localhost db_1]$ rm -R localhost_orcl/
[oracle@localhostdb_1]$ cd oc4j/j2ee
[oracle@localhostj 2ee]$ rm -R OC4J_DBConsole_localhost_orcl/
[oracle@localhost j2ee]$
Deleting the Database Control Repository
[oracle@localhost~]$ emca -deconfig dbcontrol db -repos drop
STARTED EMCA at Apr 8, 2010 9:49:59 AM
EM Configuration Assistant, Version 11.2.0.0.2 Production
Copyright (c) 2003, 2005, Oracle.  All rights reserved.
Enter the following information:
Database SID: orcl
Listener port number: 1521
Password for SYS user: 
Password for SYSMAN user: 
Do you wish to continue? [yes(Y)/no(N)]: Y
Apr 8, 2010 9:50:17 AM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at /u01/app/oracle/cfgtoollogs/emca/orcl/emca_2010_04_08_09_49_59.log.
Apr 8, 2010 9:50:17 AM oracle.sysman.emcp.EMDBPreConfig performDeconfiguration
WARNING: EM is not configured for this database. No EM-specific actions can be performed.
Apr 8, 2010 9:50:17 AM oracle.sysman.emcp.EMReposConfig invoke
INFO: Dropping the EM repository (this may take a while) ...
Apr 8, 2010 9:53:04 AM oracle.sysman.emcp.EMReposConfig invoke
INFO: Repository successfully dropped
Enterprise Manager configuration completed successfully
FINISHED EMCA at Apr 8, 2010 9:53:05 AM
[oracle@orcl~]$

We have Successfully Removed the control and repository Files. Now the next step is to Recreate those files again.

Syntax:

[oracle@localhost~]$ emca -config dbcontrol db -repos create
STARTED EMCA at Apr 8, 2010 10:47:08 AM
EM Configuration Assistant, Version 11.2.0.0.2 Production
Copyright (c) 2003, 2005, Oracle.  All rights reserved.
Enter the following information:
Database SID: orcl
Listener port number: 1521
Listener ORACLE_HOME [ /u01/app/oracle/product/10.2.0/db_1 ]:
Password for SYS user: 
Password for DBSNMP user: 
Password for SYSMAN user: 
Email address for notifications (optional):
Outgoing Mail (SMTP) server for notifications (optional):
-----------------------------------------------------------------
You have specified the following settings
Database ORACLE_HOME ................ /u01/app/oracle/product/10.2.0/db_1
Local hostname ................ ora1.localdomain
Listener ORACLE_HOME ................ /u01/app/oracle/product/10.2.0/db_1
Listener port number ................ 1521
Database SID ................ orcl
Email address for notifications ...............
Outgoing Mail (SMTP) server for notifications ...............
-----------------------------------------------------------------
Do you wish to continue? [yes(Y)/no(N)]: Y
Apr 8, 2010 10:47:56 AM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at /u01/app/oracle/cfgtoollogs/emca/orcl/emca_2010_04_08_10_47_08.log.
Apr 8, 2010 10:47:57 AM oracle.sysman.emcp.EMReposConfig createRepository
INFO: Creating the EM repository (this may take a while) ...
Apr 8, 2010 10:53:09 AM oracle.sysman.emcp.EMReposConfig invoke
INFO: Repository successfully created
Apr 8, 2010 10:53:13 AM oracle.sysman.emcp.EMReposConfig uploadConfigDataToRepository
INFO: Uploading configuration data to EM repository (this may take a while) ...
Apr 8, 2010 10:54:25 AM oracle.sysman.emcp.EMReposConfig invoke
INFO: Uploaded configuration data successfully
Apr 8, 2010 10:54:28 AM oracle.sysman.emcp.util.DBControlUtil configureSoftwareLib
INFO: Software library configured successfully.
Apr 8, 2010 10:54:28 AM oracle.sysman.emcp.EMDBPostConfig configureSoftwareLibrary
INFO: Deploying Provisioning archives ...
Apr 8, 2010 10:54:48 AM oracle.sysman.emcp.EMDBPostConfig configureSoftwareLibrary
INFO: Provisioning archives deployed successfully.
Apr 8, 2010 10:54:48 AM oracle.sysman.emcp.util.DBControlUtil secureDBConsole
INFO: Securing Database Control (this may take a while) ...
Apr 8, 2010 10:55:28 AM oracle.sysman.emcp.util.DBControlUtil secureDBConsole
INFO: Database Control secured successfully.
Apr 8, 2010 10:55:28 AM oracle.sysman.emcp.util.DBControlUtil startOMS
INFO: Starting Database Control (this may take a while) ...
Apr 8, 2010 10:56:24 AM oracle.sysman.emcp.EMDBPostConfig performConfiguration
INFO: Database Control started successfully
Apr 8, 2010 10:56:25 AM oracle.sysman.emcp.EMDBPostConfig performConfiguration
INFO: >>>>>>>>>>> The Database Control URL is https://orcl.localdomain:1158/em <<<<<<<<<<<
Apr 8, 2010 10:56:42 AM oracle.sysman.emcp.EMDBPostConfig invoke
WARNING:
************************  WARNING  ************************
Management Repository has been placed in secure mode wherein Enterprise Manager data will be encrypted.  The encryption key has been placed in the file: /u01/app/oracle/product/10.2.0/db_1/localhost.localdomain_orcl/sysman/config/emkey.ora.   Please ensure this file is backed up as the encrypted data will become unusable if this file is lost.
***********************************************************
Enterprise Manager configuration completed successfully
FINISHED EMCA at Apr 8, 2010 10:56:42 AM
[oracle@localhost~]$

After the command completes successfully the Database Console will be running.

[oracle@localhost~]$ emctl status dbconsole
Oracle Enterprise Manager 11g Database Control Release 10.2.0.1.0
Copyright (c) 1996, 2009 Oracle Corporation.  All rights reserved.
Oracle Enterprise Manager 10g is running.
------------------------------------------------------------------
Logs are generated in directory /u01/app/oracle/product/10.2.0/db_1/localhost.localdomain_orcl/sysman/log
[oracle@localhost~]$

Hope You Enjoyed , If you have any problem do send the comments.

Visit Us On FacebookVisit Us On Google PlusVisit Us On Youtube