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 ~]$