我是靠谱客的博主 耍酷树叶,最近开发中收集的这篇文章主要介绍升级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.sql脚本,引起大量ORA-00001错误所遇到的程序开发问题。

如果觉得靠谱客网站的内容还不错,欢迎将靠谱客网站推荐给程序员好友。

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

评论列表共有 0 条评论

立即
投稿
返回
顶部