Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux 
Mostly, Enterprise Manager has problems with repository. Because it takes a long time to detect and resolve problems, it will be shorter to recreate.
First of all, it is necessary to drop the existing repository and recreate it.
Drop Enterprise Manager Repository:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 | [oracle@srv-orcl ~]$ emca -deconfig dbcontrol db -repos drop STARTED EMCA at Dec 6, 2013 3:04:17 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: ORCL 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 Dec 6, 2013 3:04:38 PM oracle.sysman.emcp.EMConfig perform INFO: This operation is being logged at /oracle/cfgtoollogs/emca/ORCL/emca_2013_12_06_15_04_16.log. Dec 6, 2013 3:04:38 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=<hostname> and re-run EMCA script 2) ORACLE_HOSTNAME is set. Unset it and re-run EMCA script Dec 6, 2013 3:04:38 PM oracle.sysman.emcp.EMReposConfig invoke INFO: Dropping the EM repository (this may take a while) ... Dec 6, 2013 3:07:00 PM oracle.sysman.emcp.EMReposConfig invoke INFO: Repository successfully dropped Enterprise Manager configuration completed successfully FINISHED EMCA at Dec 6, 2013 3:07:00 PM |
Create Enterprise Manager Repository:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 | [oracle@srv-orcl ~]$ emca -config dbcontrol db -repos create STARTED EMCA at Dec 6, 2013 3:07:28 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: ORCL Listener port number: 1521 Listener ORACLE_HOME [ /oracle/11.2.0/grid ]: /oracle/product/11.2.0/db_1 Password for SYS user: Password for DBSNMP user: Password for SYSMAN user: 1 Email address for notifications (optional): Outgoing Mail (SMTP) server for notifications (optional): ASM ORACLE_HOME [ /oracle/11.2.0/grid ]: ASM SID [ +ASM ]: ASM port [ 1521 ]: ASM username [ ASMSNMP ]: ASMSNMP ASM user password: ----------------------------------------------------------------- You have specified the following settings Database ORACLE_HOME ................ /oracle/product/11.2.0/db_1 Local hostname ................ srv-orcl Listener ORACLE_HOME ................ /oracle/product/11.2.0/db_1 Listener port number ................ 1521 Database SID ................ ORCL Email address for notifications ............... Outgoing Mail (SMTP) server for notifications ............... ASM ORACLE_HOME ................ /oracle/11.2.0/grid ASM SID ................ +ASM ASM port ................ 1521 ASM user role ................ SYSDBA ASM username ................ ASMSNMP ----------------------------------------------------------------- Do you wish to continue? [yes(Y)/no(N)]: Y Dec 6, 2013 3:08:35 PM oracle.sysman.emcp.EMConfig perform INFO: This operation is being logged at /oracle/cfgtoollogs/emca/ORCL/emca_2013_12_06_15_07_27.log. Dec 6, 2013 3:08:36 PM oracle.sysman.emcp.EMReposConfig createRepository INFO: Creating the EM repository (this may take a while) ... Dec 6, 2013 3:12:48 PM oracle.sysman.emcp.EMReposConfig invoke INFO: Repository successfully created Dec 6, 2013 3:12:50 PM oracle.sysman.emcp.EMReposConfig uploadConfigDataToRepository INFO: Uploading configuration data to EM repository (this may take a while) ... Dec 6, 2013 3:13:33 PM oracle.sysman.emcp.EMReposConfig invoke INFO: Uploaded configuration data successfully Dec 6, 2013 3:13:39 PM oracle.sysman.emcp.util.DBControlUtil secureDBConsole INFO: Securing Database Control (this may take a while) ... Dec 6, 2013 3:13:46 PM oracle.sysman.emcp.util.DBControlUtil secureDBConsole INFO: Database Control secured successfully. Dec 6, 2013 3:13:46 PM oracle.sysman.emcp.util.DBControlUtil startOMS INFO: Starting Database Control (this may take a while) ... Dec 6, 2013 3:14:13 PM oracle.sysman.emcp.EMDBPostConfig performConfiguration INFO: Database Control started successfully Dec 6, 2013 3:14:13 PM oracle.sysman.emcp.EMDBPostConfig performConfiguration INFO: >>>>>>>>>>> The Database Control URL is https://srv-orcl:5501/em <<<<<<<<<<< Dec 6, 2013 3:14:14 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: /oracle/product/11.2.0/db_1/srv-orcl_ORCL/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 Dec 6, 2013 3:14:14 PM |
