Sunday, July 12, 2009

Error uploading configuration data to the repository

[ERROR MESSAGE]

Jul 11, 2009 9:33:34 PM oracle.sysman.emcp.EMReposConfig unlockMGMTAccount
CONFIG: Unlocked mgmt_view account
Jul 11, 2009 9:33:34 PM oracle.sysman.emcp.EMReposConfig invoke
CONFIG: Successfully unlocked mgmt_view account
Jul 11, 2009 9:33:34 PM oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter ORACLE_HOSTNAME.
Jul 11, 2009 9:33:34 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
CONFIG: SQLEngine connecting with SID: OCP11G, oracleHome: /apps/oracle/product/11.2.0, and user: SYS
Jul 11, 2009 9:33:34 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
CONFIG: SQLEngine created successfully and connected
Jul 11, 2009 9:33:40 PM oracle.sysman.emcp.ParamsManager checkListenerStatusForDBControl
CONFIG: Passed listener validation check.Listener is up and running.
Jul 11, 2009 9:33:40 PM oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter ORACLE_HOSTNAME.
Jul 11, 2009 9:33:40 PM oracle.sysman.emcp.EMReposConfig uploadConfigDataToRepository
INFO: Uploading configuration data to EM repository (this may take a while) ...
Jul 11, 2009 9:33:48 PM oracle.sysman.emcp.EMReposConfig uploadConfigDataToRepository
CONFIG: Error uploading configuration data to the repository
oracle.sysman.emdrep.config.ConfigurationException: FATAL Configuration Exceptions

at oracle.sysman.emdrep.config.EMSchemaConfiguration.perform(EMSchemaConfiguration.java:232)
at oracle.sysman.emcp.EMReposConfig.uploadConfigDataToRepository(EMReposConfig.java:674)
at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:370)
at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:147)
at oracle.sysman.emcp.EMConfig.perform(EMConfig.java:222)
at oracle.sysman.emcp.EMConfigAssistant.invokeEMCA(EMConfigAssistant.java:535)
at oracle.sysman.emcp.EMConfigAssistant.performConfiguration(EMConfigAssistant.java:1215)
at oracle.sysman.emcp.EMConfigAssistant.statusMain(EMConfigAssistant.java:519)
at oracle.sysman.emcp.EMConfigAssistant.main(EMConfigAssistant.java:468)
Jul 11, 2009 9:33:48 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Refer to the log file at /apps/oracle/cfgtoollogs/emca/OCP11G/emca_repos_config_.log for more details.
Jul 11, 2009 9:33:48 PM oracle.sysman.emcp.EMReposConfig invoke
SEVERE: Error uploading configuration data to the repository
Jul 11, 2009 9:33:48 PM oracle.sysman.emcp.EMConfig perform
SEVERE: Error uploading configuration data to the repository
Refer to the log file at /apps/oracle/cfgtoollogs/emca/OCP11G/emca_2009_07_11_21_27_18.log for more details.
Jul 11, 2009 9:33:48 PM oracle.sysman.emcp.EMConfig perform
CONFIG: Stack Trace:
oracle.sysman.emcp.exception.EMConfigException: Error uploading configuration data to the repository
at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:382)
at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:147)
at oracle.sysman.emcp.EMConfig.perform(EMConfig.java:222)
at oracle.sysman.emcp.EMConfigAssistant.invokeEMCA(EMConfigAssistant.java:535)
at oracle.sysman.emcp.EMConfigAssistant.performConfiguration(EMConfigAssistant.java:1215)
at oracle.sysman.emcp.EMConfigAssistant.statusMain(EMConfigAssistant.java:519)



[ROOT CAUSE]
try some solution from internet, related to password file, listener, ORACLE_HOSTNAME.

recalled recent there is block error & fixed duing Linux booting , which are related to 11.1.0.7 ORACLE_HOME.

[SOLUTION]
1. reinstall the oracle software
2. copy old PFILE, password file and listener.ora &tnsnames.ora
3.emca -deconfig dbcontrol db -repos drop
4. emca -config dbcontrol db -repos create
cheers, see the follow messages

INFO: >>>>>>>>>>> The Database Control URL is https://localhost:1158/em <<<<<<<<<<<
Jul 12, 2009 2:27:16 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: /apps/oracle/product/11.1.0/localhost_OCP11G/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 at Jul 12, 2009 2:27:16 PM
You have new mail in /var/spool/mail/oracle

No comments:

Post a Comment