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