oracle

推荐列表 站点导航

当前位置:首页 > 数据库 > oracle >

oracle 11g em重建报唯一约束错误解决方法

来源:网络整理  作者:网络  发布时间:2020-12-13 13:57
今天在手工配置Oracle11g的EM时总是报如下错误,也没有找到解决办法,以下是我的解决过程,希望可以帮助你们...
SEVERE:Errorcreatingtherepository
INFO:DroppingtheEMrepository(thismaytakeawhile)...
2、配置EM时的步骤
BANNER
[oracle@Core-Nbu-Rollback~]$emca-configdbcontroldb-reposrecreate
TNSforLinux:Version11.2.0.3.0-Production
WARNING:ORA-00001:uniqueconstraint(SYSMAN.PARAMETERS_PRIMARY_KEY)violated
WARNING:Whilerepositoryisdroppedthedatabasewillbeputinquiescemode.
Nov23,20123:52:56PMoracle.sysman.emcp.EMReposConfiginvoke
----------------------------------------------------------------------
Nov23,20123:57:30PMoracle.sysman.emcp.EMReposConfiginvoke
OutgoingMail(SMTP)serverfornotifications(optional):
Copyright(c)2003,2011,Oracle.Allrightsreserved.
Doyouwishtocontinue?[yes(Y)/no(N)]:Y
OracleDatabase11gEnterpriseEditionRelease11.2.0.3.0-64bitProduction
今天在手工配置Oracle11g的EM时总是报如下错误:
DatabaseSID:test
PasswordforDBSNMPuser:
------------------------------------------------------------------------------------------------------------------------------
Emailaddressfornotifications...............
SQL>select*fromv$version;
INFO:Thisoperationisbeingloggedat/soft/ora11g/cfgtoollogs/emca/test/emca_2012_11_23_15_52_07.log.
以Metalink上也没有找到解决办法,以下是我的解决过程:
Nov23,20123:52:33PMoracle.sysman.emcp.EMConfigperform
ORA-06512:at"SYSMAN.EMD_LOADER",line4986
Emailaddressfornotifications(optional):
ListenerORACLE_HOME................/soft/ora11g/11202
NLSRTLVersion11.2.0.3.0–Production
OutgoingMail(SMTP)serverfornotifications...............
ORA-06512:at"SYSMAN.EMD_LOADER",line4986
Enterthefollowinginformation:
SEVERE:Errorcreatingtherepository
Refertothelogfileat/soft/ora11g/cfgtoollogs/emca/test/emca_2012_11_23_15_52_07.logformoredetails.
ORA-06512:atline1
ORA-06512:atline1
----------------------------------------------------------------------
Couldnotcompletetheconfiguration.Refertothelogfileat/soft/ora11g/cfgtoollogs/emca/test/emca_2012_11_23_15_52_07.logformoredetails. Nov23,20123:54:57PMoracle.sysman.emcp.EMReposConfigcreateRepository
PasswordforSYSuser:
INFO:StoppingDatabaseControl(thismaytakeawhile)...
Localhostname................Core-Nbu-Rollback
Listenerportnumber................1521
----------------------------------------------------------------------
INFO:Refertothelogfileat/soft/ora11g/cfgtoollogs/emca/test/emca_repos_create_<date>.logformoredetails.
----------------------------------------------------------------------
INFO:CreatingtheEMrepository(thismaytakeawhile)...
Thiswillremovetheexistingconfigurationandthedefaultsettingsandperform.afreshconfiguration
-----------------------------------------------------------------
Youhavespecifiedthefollowingsettings
CORE11.2.0.3.0Production
Nov23,20123:54:56PMoracle.sysman.emcp.EMReposConfiginvoke

1、数据库版本
EMConfigurationAssistant,Version11.2.0.3.0Production
Doyouwishtocontinue?[yes(Y)/no(N)]:Y
PasswordforSYSMANuser:
Nov23,20123:52:35PMoracle.sysman.emcp.util.DBControlUtilstopOMS
PL/SQLRelease11.2.0.3.0-Production
Nov23,20123:57:30PMoracle.sysman.emcp.EMReposConfigcreateRepository
YouhavechosentoconfigureDatabaseControlformanagingthedatabasetest
Nov23,20123:57:30PMoracle.sysman.emcp.EMConfigperform
-----------------------------------------------------------------
DatabaseORACLE_HOME................/soft/ora11g/11202
WARNING:ORA-00001:uniqueconstraint(SYSMAN.PARAMETERS_PRIMARY_KEY)violated
STARTEDEMCAatNov23,20123:52:08PM

Nov23,20123:57:30PMoracle.sysman.emcp.EMReposConfiginvoke
DatabaseControlisalreadyconfiguredforthedatabasetest
WARNING:Whilerepositoryisdroppedthedatabasewillbeputinquiescemode.
INFO:Repositorysuccessfullydropped
DatabaseSID................test
ListenerORACLE_HOME[/soft/ora11g/11202]:

相关热词: oracle 方法 解决

本站内容来源于网络,如有侵权请与我们联系,我们会及时删除,我们深感抱歉!
注:本站所有信息仅供用于网络技术学习参考,学习中请遵循相关法律法规!

本文地址: https://www.juheyunku.com/sql/oracle/3309.shtml

Copyright © www.juheyunku.com      关于 | 合作 | 声明 | 联系 | 更新 | 地图 | Tags

oracle 11g em重建报唯一约束错误解决方法

2020-12-13 编辑:网络

SEVERE:Errorcreatingtherepository
INFO:DroppingtheEMrepository(thismaytakeawhile)...
2、配置EM时的步骤
BANNER
[oracle@Core-Nbu-Rollback~]$emca-configdbcontroldb-reposrecreate
TNSforLinux:Version11.2.0.3.0-Production
WARNING:ORA-00001:uniqueconstraint(SYSMAN.PARAMETERS_PRIMARY_KEY)violated
WARNING:Whilerepositoryisdroppedthedatabasewillbeputinquiescemode.
Nov23,20123:52:56PMoracle.sysman.emcp.EMReposConfiginvoke
----------------------------------------------------------------------
Nov23,20123:57:30PMoracle.sysman.emcp.EMReposConfiginvoke
OutgoingMail(SMTP)serverfornotifications(optional):
Copyright(c)2003,2011,Oracle.Allrightsreserved.
Doyouwishtocontinue?[yes(Y)/no(N)]:Y
OracleDatabase11gEnterpriseEditionRelease11.2.0.3.0-64bitProduction
今天在手工配置Oracle11g的EM时总是报如下错误:
DatabaseSID:test
PasswordforDBSNMPuser:
------------------------------------------------------------------------------------------------------------------------------
Emailaddressfornotifications...............
SQL>select*fromv$version;
INFO:Thisoperationisbeingloggedat/soft/ora11g/cfgtoollogs/emca/test/emca_2012_11_23_15_52_07.log.
以Metalink上也没有找到解决办法,以下是我的解决过程:
Nov23,20123:52:33PMoracle.sysman.emcp.EMConfigperform
ORA-06512:at"SYSMAN.EMD_LOADER",line4986
Emailaddressfornotifications(optional):
ListenerORACLE_HOME................/soft/ora11g/11202
NLSRTLVersion11.2.0.3.0–Production
OutgoingMail(SMTP)serverfornotifications...............
ORA-06512:at"SYSMAN.EMD_LOADER",line4986
Enterthefollowinginformation:
SEVERE:Errorcreatingtherepository
Refertothelogfileat/soft/ora11g/cfgtoollogs/emca/test/emca_2012_11_23_15_52_07.logformoredetails.
ORA-06512:atline1
ORA-06512:atline1
----------------------------------------------------------------------
Couldnotcompletetheconfiguration.Refertothelogfileat/soft/ora11g/cfgtoollogs/emca/test/emca_2012_11_23_15_52_07.logformoredetails. Nov23,20123:54:57PMoracle.sysman.emcp.EMReposConfigcreateRepository
PasswordforSYSuser:
INFO:StoppingDatabaseControl(thismaytakeawhile)...
Localhostname................Core-Nbu-Rollback
Listenerportnumber................1521
----------------------------------------------------------------------
INFO:Refertothelogfileat/soft/ora11g/cfgtoollogs/emca/test/emca_repos_create_<date>.logformoredetails.
----------------------------------------------------------------------
INFO:CreatingtheEMrepository(thismaytakeawhile)...
Thiswillremovetheexistingconfigurationandthedefaultsettingsandperform.afreshconfiguration
-----------------------------------------------------------------
Youhavespecifiedthefollowingsettings
CORE11.2.0.3.0Production
Nov23,20123:54:56PMoracle.sysman.emcp.EMReposConfiginvoke

1、数据库版本
EMConfigurationAssistant,Version11.2.0.3.0Production
Doyouwishtocontinue?[yes(Y)/no(N)]:Y
PasswordforSYSMANuser:
Nov23,20123:52:35PMoracle.sysman.emcp.util.DBControlUtilstopOMS
PL/SQLRelease11.2.0.3.0-Production
Nov23,20123:57:30PMoracle.sysman.emcp.EMReposConfigcreateRepository
YouhavechosentoconfigureDatabaseControlformanagingthedatabasetest
Nov23,20123:57:30PMoracle.sysman.emcp.EMConfigperform
-----------------------------------------------------------------
DatabaseORACLE_HOME................/soft/ora11g/11202
WARNING:ORA-00001:uniqueconstraint(SYSMAN.PARAMETERS_PRIMARY_KEY)violated
STARTEDEMCAatNov23,20123:52:08PM

Nov23,20123:57:30PMoracle.sysman.emcp.EMReposConfiginvoke
DatabaseControlisalreadyconfiguredforthedatabasetest
WARNING:Whilerepositoryisdroppedthedatabasewillbeputinquiescemode.
INFO:Repositorysuccessfullydropped
DatabaseSID................test
ListenerORACLE_HOME[/soft/ora11g/11202]:

本站内容来源于网络,如有侵权请与我们联系,我们会及时删除,我们深感抱歉!
注:本站所有信息仅供学习参考!
本文地址为 https://www.juheyunku.com/sql/oracle/3309.shtml

相关文章

风云图片

推荐阅读

返回oracle频道首页