升级11g重复执行catupgrd.sql脚本，引起大量ORA-00001错误

最新推荐文章于 2025-06-20 13:29:20 发布

wenzhongyan

最新推荐文章于 2025-06-20 13:29:20 发布

阅读量1.5k

点赞数

CC 4.0 BY-SA版权

分类专栏： ORACLE-问题处理

本文链接：https://blog.youkuaiyun.com/wenzhongyan/article/details/54343322

ORACLE-问题处理专栏收录该内容

30 篇文章

订阅专栏

本文介绍了解决catupgrd.sql脚本重复运行导致的ORA-00001唯一约束错误的方法。这些错误通常可以安全地忽略，并且不会影响数据库升级过程。若遇到DBMS_SESSION相关问题，建议执行dbmsutil.sql和prvtutil.plb。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

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