oracle数据库脚本自动升级,升级Oracle 11g重复执行catupgrd.sql脚本引起大量ORA-00001错误...

升级Oracle 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