Çoğunlukla Enterprise Manager , repository kaynaklı sorun yaşamaktadır. Sorunların tespiti ve çözülmesi , yeniden oluşturmaktan daha uzun sürdüğünden dolayı, yeniden oluşturmak her zaman daha kısa sürecektir.
Öncelikle mevcut repository’yi drop edip, yeniden oluşturulması gerekiyor.
EM Repository drop işlemi :
[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
[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