我是靠谱客的博主 耍酷树叶,这篇文章主要介绍升级11g重复执行catupgrd.sql脚本,引起大量ORA-00001错误,现在分享给大家,希望可以做个参考。

Re-running the catupgrd.sql script caused many ORA-00001 errors similar to below:

ORA-00001: unique constraint (SYS.I_SYSTEM_PRIVILEGE_MAP) violated
ORA-00001: unique constraint (SYS.I_SYSTEM_PRIVILEGE_MAP) violated
ORA-00001: unique constraint (SYS.I_SYSTEM_PRIVILEGE_MAP) violated
ORA-00001: unique constraint (SYS.I_SYSTEM_PRIVILEGE_MAP) violated
ORA-00001: unique constraint (SYS.I_SYSTEM_PRIVILEGE_MAP) violated
ORA-00001: unique constraint (SYS.I_TABLE_PRIVILEGE_MAP) violated
ORA-00001: unique constraint (SYS.I_TABLE_PRIVILEGE_MAP) violated
ORA-00001: unique constraint (SYS.I_STMT_AUDIT_OPTION_MAP) violated
ORA-00001: unique constraint (SYS.I_STMT_AUDIT_OPTION_MAP) violated
ORA-00001: unique constraint (SYS.I_STMT_AUDIT_OPTION_MAP) violated


原因是由于bug引起
Bug 5501515 TST&PERF VIOLATED SOME TABLE'S UNIQUE CONSTRAINT WHILE UPGRADING TO 11G
Bug 8834797 APPSST GSI 11G UNIQUE CONSTRAINT VIOLATED WHILE RUNNING CATUPGRD

这个错误可以忽略,不影响正常库使用,也可以执行下dbmsutil.sql和prvtutil.plb

Unique constraint errors are expected and acceptable on re-run of catupgrd.sql or utlu111s.sql. These ORA-1 errors can be safely ignored and should not impact the upgrade process in anyway.
If still having issues with DBMS_SESSION then request  run dbmsutil.sql prvtutil.plb SYS

最后

以上就是耍酷树叶最近收集整理的关于升级11g重复执行catupgrd.sql脚本,引起大量ORA-00001错误的全部内容,更多相关升级11g重复执行catupgrd内容请搜索靠谱客的其他文章。

本图文内容来源于网友提供,作为学习参考使用,或来自网络收集整理,版权属于原作者所有。
点赞(119)

评论列表共有 0 条评论

立即
投稿
返回
顶部