Steps to configure Oracle 11g OEM DBConsole manually for database
In case your database is cloned from other database where you have grid already installed and configured. After the cloning, in the target database the same set of configuration will not work. You have to reconfigure the same. For that we have to drop the existing configuration first. If it is a new database you can directly configure using emca.
1. Drop dbcontrol configuration
2. Create the OEM repository
3. Configure EM db control
4. Verify the configuration
5. How to check status of EM database control
6. How to stop EM database control
7. How to start EM database control
Step 1. Drop the existing configuration if it is having sysman user already present.
SQL> Select username from dba_users where username='SYSMAN'; USERNAME ------------------------------ SYSMAN The below command to drop the existing configuration [oracle@rac2 ~]$ emca -deconfig dbcontrol db -repos drop STARTED EMCA at Jul 21, 2016 2:06:14 PM EM Configuration Assistant, Version 11.2.0.3.0 Production Copyright (c) 2003, 2011, Oracle. All rights reserved. Enter the following information: Database SID: cat Listener port number: 1521 Password for SYS user: Password for SYSMAN user: ---------------------------------------------------------------------- WARNING : While repository is dropped the database will be put in quiesce mode. ---------------------------------------------------------------------- Do you wish to continue? [yes(Y)/no(N)]: yes Jul 21, 2016 2:06:56 PM oracle.sysman.emcp.EMConfig perform INFO: This operation is being logged at /u01/app/oracle/cfgtoollogs/emca/cat/emca_2016_07_21_14_06_14.log. Jul 21, 2016 2:06:56 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngineLoacly WARNING: ORA-28000: the account is locked Jul 21, 2016 2:06:56 PM oracle.sysman.emcp.ParamsManager checkListenerStatusForDBControl WARNING: Error initializing SQL connection. SQL operations cannot be performed Jul 21, 2016 2:06:56 PM oracle.sysman.emcp.EMDBPreConfig performDeconfiguration WARNING: EM is not configured for this database. No EM-specific actions can be performed. Some of the possible reasons may be: 1) EM is configured with different hostname then physical host. Set environment variable ORACLE_HOSTNAME= and re-run EMCA script 2) ORACLE_HOSTNAME is set. Unset it and re-run EMCA script Jul 21, 2016 2:06:56 PM oracle.sysman.emcp.EMReposConfig invoke INFO: Dropping the EM repository (this may take a while) ... Jul 21, 2016 2:08:09 PM oracle.sysman.emcp.EMReposConfig invoke INFO: Repository successfully dropped Enterprise Manager configuration completed successfully FINISHED EMCA at Jul 21, 2016 2:08:10 PM [oracle@rac2 ~]$
Step 2. Create the OEM repository
[oracle@rac2 ~]$ emca -repos create STARTED EMCA at Jul 21, 2016 2:08:43 PM EM Configuration Assistant, Version 11.2.0.3.0 Production Copyright (c) 2003, 2011, Oracle. All rights reserved. Enter the following information: Database SID: cat Listener port number: 1521 Password for SYS user: Password for SYSMAN user: Do you wish to continue? [yes(Y)/no(N)]: yes Jul 21, 2016 2:08:56 PM oracle.sysman.emcp.EMConfig perform INFO: This operation is being logged at /u01/app/oracle/cfgtoollogs/emca/cat/emca_2016_07_21_14_08_43.log. Jul 21, 2016 2:08:56 PM oracle.sysman.emcp.EMReposConfig createRepository INFO: Creating the EM repository (this may take a while) ... Jul 21, 2016 2:12:29 PM oracle.sysman.emcp.EMReposConfig invoke INFO: Repository successfully created Enterprise Manager configuration completed successfully FINISHED EMCA at Jul 21, 2016 2:12:29 PM [oracle@rac2 ~]$
Step 3. Confitgure EM db control
[oracle@rac2 ~]$ emca -config dbcontrol db STARTED EMCA at Jul 21, 2016 2:26:10 PM EM Configuration Assistant, Version 11.2.0.3.0 Production Copyright (c) 2003, 2011, Oracle. All rights reserved. Enter the following information: Database SID: cat Listener port number: 1521 Listener ORACLE_HOME [ /u01/app/11.2.0/grid ]: 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/11.2.0/db_1 Local hostname ................ rac2.rajasekhar.com Listener ORACLE_HOME ................ /u01/app/11.2.0/grid Listener port number ................ 1521 Database SID ................ cat Email address for notifications ............... Outgoing Mail (SMTP) server for notifications ............... ----------------------------------------------------------------- Do you wish to continue? [yes(Y)/no(N)]: yes Jul 21, 2016 2:34:25 PM oracle.sysman.emcp.EMConfig perform INFO: This operation is being logged at /u01/app/oracle/cfgtoollogs/emca/cat/emca_2016_07_21_14_26_10.log. Jul 21, 2016 2:34:29 PM oracle.sysman.emcp.EMReposConfig uploadConfigDataToRepository INFO: Uploading configuration data to EM repository (this may take a while) ... Jul 21, 2016 2:35:10 PM oracle.sysman.emcp.EMReposConfig invoke INFO: Uploaded configuration data successfully Jul 21, 2016 2:35:10 PM oracle.sysman.emcp.ParamsManager getLocalListener WARNING: Error retrieving listener for rac2.rajasekhar.com Jul 21, 2016 2:35:12 PM oracle.sysman.emcp.util.DBControlUtil secureDBConsole INFO: Securing Database Control (this may take a while) ... Jul 21, 2016 2:35:58 PM oracle.sysman.emcp.util.DBControlUtil secureDBConsole INFO: Database Control secured successfully. Jul 21, 2016 2:35:58 PM oracle.sysman.emcp.util.DBControlUtil startOMS INFO: Starting Database Control (this may take a while) ... Jul 21, 2016 2:36:38 PM oracle.sysman.emcp.EMDBPostConfig performConfiguration INFO: Database Control started successfully Jul 21, 2016 2:36:39 PM oracle.sysman.emcp.EMDBPostConfig performConfiguration INFO: >>>>>>>>>>> The Database Control URL is https://rac2.rajasekhar.com:1158/em <<<<<<<<<<< Jul 21, 2016 2:36:45 PM 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/11.2.0/db_1/rac2.rajasekhar.com_cat/sysman/config/emkey.ora. 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 Jul 21, 2016 2:36:45 PM [oracle@rac2 ~]$ [oracle@rac2 ~]$ 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://rac2.rajasekhar.com:1158/em/console/aboutApplication Oracle Enterprise Manager 11g is running. ------------------------------------------------------------------ Logs are generated in directory /u01/app/oracle/product/11.2.0/db_1/rac2.rajasekhar.com_cat/sysman/log [oracle@rac2 ~]$ [oracle@rac2 ~]$
Step 4. Verify the configuration by typing Database Control URL
How to check the status of EM database control
[oracle@rac2 ~]$ 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://rac2.rajasekhar.com:1158/em/console/aboutApplication Oracle Enterprise Manager 11g is running. ------------------------------------------------------------------ Logs are generated in directory /u01/app/oracle/product/11.2.0/db_1/rac2.rajasekhar.com_cat/sysman/log [oracle@rac2 ~]$
How to stop EM database control
[oracle@rac2 ~]$ emctl stop dbconsole Oracle Enterprise Manager 11g Database Control Release 11.2.0.3.0 Copyright (c) 1996, 2011 Oracle Corporation. All rights reserved. https://rac2.rajasekhar.com:1158/em/console/aboutApplication Stopping Oracle Enterprise Manager 11g Database Control ... ... Stopped. [oracle@rac2 ~]$ [oracle@rac2 ~]$ 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://rac2.rajasekhar.com:1158/em/console/aboutApplication Oracle Enterprise Manager 11g is not running. [oracle@rac2 ~]$
How to start EM database control
[oracle@rac2 ~]$ emctl start dbconsole Oracle Enterprise Manager 11g Database Control Release 11.2.0.3.0 Copyright (c) 1996, 2011 Oracle Corporation. All rights reserved. https://rac2.rajasekhar.com:1158/em/console/aboutApplication Starting Oracle Enterprise Manager 11g Database Control ........ started. ------------------------------------------------------------------ Logs are generated in directory /u01/app/oracle/product/11.2.0/db_1/rac2.rajasekhar.com_cat/sysman/log [oracle@rac2 ~]$ [oracle@rac2 ~]$ 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://rac2.rajasekhar.com:1158/em/console/aboutApplication Oracle Enterprise Manager 11g is running. ------------------------------------------------------------------ Logs are generated in directory /u01/app/oracle/product/11.2.0/db_1/rac2.rajasekhar.com_cat/sysman/log [oracle@rac2 ~]$
Caution: Your use of any information or materials on this website is entirely at your own risk. It is provided for educational purposes only. It has been tested internally, however, we do not guarantee that it will work for you. Ensure that you run it in your test environment before using.