The following error is always reported when you manually configure Oracle11g EM today, and no solution is found. The following is my solution process and I hope to help you
The following error is always reported when you manually configure Oracle11g EM today, and no solution is found. The following is my solution process and I hope to help you
The following error is always reported when you manually configure the EM of Oracle11g:
WARNING: ORA-00001: uniqueconstraint (SYSMAN. PARAMETERS_PRIMARY_KEY) violated
ORA-06512: at "SYSMAN. EMD_LOADER", line4986
ORA-06512: atline1.
No solution was found in Metalink. The following is my solution process:
1. database version
SQL> select * fromv $ version;
BANNER
Bytes ------------------------------------------------------------------------------------------------------------------------------
OracleDatabase11gEnterpriseEditionRelease11.2.0.3.0-64 bitProduction
PL/SQLRelease11.2.0.3.0-Production
CORE11.2.0.3.0Production
TNSforLinux: Version11.2.0.3.0-Production
NLSRTLVersion11.2.0.3.0-Production
2. Steps for configuring EM
[Oracle @ Core-Nbu-Rollback ~] $ Emca-configdbcontroldb-reposrecreate
STARTEDEMCAatNov23, 20123:52:08 PM
EMConfigurationAssistant, Version11.2.0.3.0Production
Copyright (c) Private, Oracle. Allrightsreserved.
Enterthefollowinginformation:
DatabaseSID: test
DatabaseControlisalreadyconfiguredforthedatabasetest
YouhavechosentoconfigureDatabaseControlformanagingthedatabasetest
Thiswillremovetheexistingconfigurationandthedefasetsettingsandperform. afreshconfiguration
----------------------------------------------------------------------
WARNING: Whilerepositoryisdroppedthedatabasewillbeputinquiescemode.
----------------------------------------------------------------------
Doyouwishtocontinue? [Yes (Y)/no (N)]: Y
ListenerORACLE_HOME [/soft/ora11g/11202]:
PasswordforSYSuser:
PasswordforDBSNMPuser:
PasswordforSYSMANuser:
Emailaddressfornotifications (optional ):
OutgoingMail (SMTP) serverforconfigurications (optional ):
-----------------------------------------------------------------
Youhavespecifiedthefollowingsettings
DatabaseORACLE_HOME.../soft/ora11g/11202
Localhostname ...... Core-Nbu-Rollback
ListenerORACLE_HOME.../soft/ora11g/11202
Listenerportnumber ......
DatabaseSID ...... test
Emailaddressforpolicications ...............
OutgoingMail (SMTP) serverforconfigurications ...............
-----------------------------------------------------------------
----------------------------------------------------------------------
WARNING: Whilerepositoryisdroppedthedatabasewillbeputinquiescemode.
----------------------------------------------------------------------
Doyouwishtocontinue? [Yes (Y)/no (N)]: Y
Nov23, 20123: 52: 33PMoracle. sysman. emcp. EMConfigperform
INFO: Thisoperationisbeingloggedat/soft/ora11g/export toollogs/emca/test/emca_2012_11_23_15_52_07.log.
Nov23, 20123: 52: 35PMoracle. sysman. emcp. util. DBControlUtilstopOMS
INFO: StoppingDatabaseControl (thismaytakeawhile )...
Nov23, 20123: 52: 56PMoracle. sysman. emcp. EMReposConfiginvoke
INFO: DroppingtheEMrepository (thismaytakeawhile )...
Nov23, 20123: 54: 56PMoracle. sysman. emcp. EMReposConfiginvoke
INFO: Repositorysuccessfullydropped
Nov23, 20123: 54: 57PMoracle. sysman. emcp. EMReposConfigcreateRepository
INFO: CreatingtheEMrepository (thismaytakeawhile )...
Nov23, 20123: 57: 30PMoracle. sysman. emcp. EMReposConfigcreateRepository
WARNING: ORA-00001: uniqueconstraint (SYSMAN. PARAMETERS_PRIMARY_KEY) violated
ORA-06512: at "SYSMAN. EMD_LOADER", line4986
ORA-06512: atline1.
Nov23, 20123: 57: 30PMoracle. sysman. emcp. EMReposConfiginvoke
SEVERE: Errorcreatingtherepository
Nov23, 20123: 57: 30PMoracle. sysman. emcp. EMReposConfiginvoke
INFO: Refertothelogfileat/soft/ora11g/export toollogs/emca/test/emca_repos_create _ . Logformoredetails.
Nov23, 20123: 57: 30PMoracle. sysman. emcp. EMConfigperform
SEVERE: Errorcreatingtherepository
Refertothelogfileat/soft/ora11g/export toollogs/emca/test/emca_2012_11_23_15_52_07.logformoredetails.
Couldnotcompletetheconfiguration. Refertothelogfileat/soft/ora11g/export toollogs/emca/test/emca_2012_11_23_15_52_07.logformoredetails.
