Oracle Version
SQL> SELECT * FROM v$version; BANNER -------------------------------------------------------------------------------- Oracle DATABASE 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production PL/SQL Release 11.2.0.1.0 - Production CORE 11.2.0.1.0 Production TNS FOR Linux: Version 11.2.0.1.0 - Production NLSRTL Version 11.2.0.1.0 - Production
Unlock SYSMAN User Account
sqlplus / AS sysdba SQL> ALTER USER sysman account UNLOCK; USER altered.
Remove EM
emca -deconfig dbcontrol db -repos drop ... 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 ... oracle.sysman.emcp.util.DBControlUtil stopOMS INFO: Stopping Database Control (this may take a while) ... oracle.sysman.emcp.EMReposConfig invoke INFO: Dropping the EM repository (this may take a while) ... oracle.sysman.emcp.EMReposConfig invoke INFO: Repository successfully dropped Enterprise Manager configuration completed successfully FINISHED EMCA
Add New EM Config
emca -config dbcontrol db -repos create ... Enter the following information: Database SID: orcl Listener port number: 1521 Listener ORACLE_HOME [ /u01/app/oracle/product/11.2.0/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 ................ /u01/app/oracle/product/11.2.0/dbhome_1 Local hostname ................ dbbox Listener ORACLE_HOME ................ /u01/app/oracle/product/11.2.0/dbhome_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 ... oracle.sysman.emcp.EMReposConfig createRepository INFO: Creating the EM repository (this may take a while) ... oracle.sysman.emcp.EMReposConfig invoke INFO: Repository successfully created oracle.sysman.emcp.EMReposConfig uploadConfigDataToRepository INFO: Uploading configuration data to EM repository (this may take a while) ... oracle.sysman.emcp.EMReposConfig invoke INFO: Uploaded configuration data successfully oracle.sysman.emcp.util.DBControlUtil configureSoftwareLib INFO: Software library configured successfully. oracle.sysman.emcp.EMDBPostConfig configureSoftwareLibrary INFO: Deploying Provisioning archives ... oracle.sysman.emcp.EMDBPostConfig configureSoftwareLibrary INFO: Provisioning archives deployed successfully. oracle.sysman.emcp.util.DBControlUtil secureDBConsole INFO: Securing Database Control (this may take a while) ... oracle.sysman.emcp.util.DBControlUtil secureDBConsole INFO: Database Control secured successfully. oracle.sysman.emcp.util.DBControlUtil startOMS INFO: Starting Database Control (this may take a while) ... oracle.sysman.emcp.EMDBPostConfig performConfiguration INFO: Database Control started successfully oracle.sysman.emcp.EMDBPostConfig performConfiguration INFO: >>>>>>>>>>> The Database Control URL is https://mydbbox:1158/em <<<<<<<<<<< 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/dbhome_1/dbbox_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
References
* Reference: Reconfigure Oracle EM