Step by Step recreating dbconsole in Oracle 11g database

Step 1: First check if dbconsole is already running. Now set the password for DBSNMP, SYS, and SYSMAN user. Set ORACLE_SID and set PORT

Step 2: Drop the emctl repository. $emca -deconfig dbcontrol db -repos drop oracle: test:/eu01/app/oracle/product/11.2.0.4/dbhome_1/sysman/config> emca -deconfig dbcontrol db -repos drop STARTED EMCA at Sep 25, 2016 3:39:15 AM EM Configuration Assistant, Version 11.2.0.3.0 Production Copyright (c) 2003, 2011, Oracle.  All rights reserved.   Enter the following information: Database SID: test 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)]: Y Sep 25, 2016 3:39:38 AM oracle.sysman.emcp.EMConfig perform INFO: This operation is being logged at /eu01/app/oracle/cfgtoollogs/emca/test/emca_2016_09_25_03_39_14.log. Sep 25, 2016 3:39:39 AM oracle.sysman.emcp.util.DBControlUtil stopOMS INFO: Stopping Database Control (this may take a while) ... Sep 25, 2016 3:39:50 AM oracle.sysman.emcp.EMReposConfig invoke INFO: Dropping the EM repository (this may take a while) ...   Sep 25, 2016 3:43:02 AM oracle.sysman.emcp.EMReposConfig invoke INFO: Repository successfully dropped Enterprise Manager configuration completed successfully FINISHED EMCA at Sep 25, 2016 3:43:06 AM

Step 3: Create repository using below commands. oracle:test:/eu01/app/oracle/product/11.2.0.4/dbhome_1/sysman/config> emca -config dbcontrol db -repos create   STARTED EMCA at Sep 25, 2016 3:52:48 AM EM Configuration Assistant, Version 11.2.0.3.0 Production Copyright (c) 2003, 2011, Oracle.  All rights reserved. Enter the following information: Database SID: test Listener port number: 1521 Listener ORACLE_HOME [ /eu01/app/oracle/product/11.2.0.4/dbhome_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 ................ /eu01/app/oracle/product/11.2.0.4/dbhome_1   Local hostname ................ testserver Listener ORACLE_HOME ................ /eu01/app/oracle/product/11.2.0.4/dbhome_1 Listener port number ................ 1521 Database SID ................ test Email address for notifications ............... Outgoing Mail (SMTP) server for notifications ...............   ----------------------------------------------------------------- Do you wish to continue? [yes(Y)/no(N)]: Y Sep 25, 2016 3:53:43 AM oracle.sysman.emcp.EMConfig perform INFO: This operation is being logged at /eu01/app/oracle/cfgtoollogs/emca/test/emca_2016_09_25_03_52_47.log. Sep 25, 2016 3:53:44 AM oracle.sysman.emcp.EMReposConfig createRepository INFO: Creating the EM repository (this may take a while) ...   Sep 25, 2016 4:03:07 AM oracle.sysman.emcp.EMReposConfig invoke INFO: Repository successfully created Sep 25, 2016 4:03:13 AM oracle.sysman.emcp.EMReposConfig uploadConfigDataToRepository INFO: Uploading configuration data to EM repository (this may take a while) ... Sep 25, 2016 4:04:59 AM oracle.sysman.emcp.EMReposConfig invoke INFO: Uploaded configuration data successfully Sep 25, 2016 4:05:02 AM oracle.sysman.emcp.ParamsManager getLocalListener WARNING: Error retrieving listener for testserver Sep 25, 2016 4:05:05 AM oracle.sysman.emcp.util.DBControlUtil secureDBConsole INFO: Securing Database Control (this may take a while) ... Sep 25, 2016 4:05:18 AM oracle.sysman.emcp.util.DBControlUtil secureDBConsole INFO: Database Control secured successfully. Sep 25, 2016 4:05:18 AM oracle.sysman.emcp.util.DBControlUtil startOMS INFO: Starting Database Control (this may take a while) ...   Sep 25, 2016 4:06:10 AM oracle.sysman.emcp.EMDBPostConfig performConfiguration INFO: Database Control started successfully Sep 25, 2016 4:06:11 AM oracle.sysman.emcp.EMDBPostConfig performConfiguration INFO: >>>>>>>>>>> The Database Control URL is https://testserver:5501/em <<<<<<<<<<< Sep 25, 2016 4:06:25 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: /eu01/app/oracle/product/11.2.0.4/dbhome_1/testserver_test/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 Sep 25, 2016 4:06:25 AM

Thanks for reading this post ! Please comment if you like this post ! Click on FOLLOW to get future blog updates !