{"rsdb":{"rid":"156493","subhead":"","postdate":"0","aid":"117463","fid":"57","uid":"1","topic":"1","content":"<p>Re-running the catupgrd.sql script caused many ORA-00001 errors similar to below\uff1a<br \/>ORA-00001: unique constraint (SYS.I_SYSTEM_PRIVILEGE_MAP) violated<br \/>ORA-00001: unique constraint (SYS.I_SYSTEM_PRIVILEGE_MAP) violated<br \/>ORA-00001: unique constraint (SYS.I_SYSTEM_PRIVILEGE_MAP) violated<br \/>ORA-00001: unique constraint (SYS.I_SYSTEM_PRIVILEGE_MAP) violated<br \/>ORA-00001: unique constraint (SYS.I_SYSTEM_PRIVILEGE_MAP) violated<br \/>ORA-00001: unique constraint (SYS.I_TABLE_PRIVILEGE_MAP) violated<br \/>ORA-00001: unique constraint (SYS.I_TABLE_PRIVILEGE_MAP) violated<br \/>ORA-00001: unique constraint (SYS.I_STMT_AUDIT_OPTION_MAP) violated<br \/>ORA-00001: unique constraint (SYS.I_STMT_AUDIT_OPTION_MAP) violated<br \/>ORA-00001: unique constraint (SYS.I_STMT_AUDIT_OPTION_MAP) violated<\/p><br\/><p>\u539f\u56e0\u662f\u7531\u4e8ebug\u5f15\u8d77<\/p><br\/><p>Bug 5501515 TST&PERF VIOLATED SOME TABLE'S UNIQUE CONSTRAINT WHILE UPGRADING TO 11G<br \/>Bug 8834797 APPSST GSI 11G UNIQUE CONSTRAINT VIOLATED WHILE RUNNING CATUPGRD<\/p><br\/><p>\u8fd9\u4e2a\u9519\u8bef\u53ef\u4ee5\u5ffd\u7565\uff0c\u4e0d\u5f71\u54cd\u6b63\u5e38\u5e93\u4f7f\u7528\uff0c\u4e5f\u53ef\u4ee5\u6267\u884c\u4e0bdbmsutil.sql\u548cprvtutil.plb<\/p><br\/><p>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.<br \/>If still having issues with DBMS_SESSION then request? run dbmsutil.sql prvtutil.plb SYS<\/p><br\/>","orderid":"0","title":"\u5347\u7ea7Oracle 11g\u91cd\u590d\u6267\u884ccatupgrd.sql\u811a\u672c\u5f15\u8d77\u5927\u91cfORA-00001\u9519\u8bef","smalltitle":"","mid":"0","fname":"\u6570\u636e\u5e93\u7f16\u7a0b","special_id":"0","bak_id":"0","info":"0","hits":"350","pages":"1","comments":"0","posttime":"2017-02-21 08:15:57","list":"1487636157","username":"admin","author":"","copyfrom":"","copyfromurl":"","titlecolor":"","fonttype":"0","titleicon":"0","picurl":"https:\/\/www.cppentry.com\/upload_files\/","ispic":"0","yz":"1","yzer":"","yztime":"0","levels":"0","levelstime":"0","keywords":"<A HREF='https:\/\/www.cppentry.com\/do\/search.php?type=keyword&keyword=%C9%FD%BC%B6' target=_blank>\u5347\u7ea7<\/A> <A HREF='https:\/\/www.cppentry.com\/do\/search.php?type=keyword&keyword=Oracle' target=_blank>Oracle<\/A> <A HREF='https:\/\/www.cppentry.com\/do\/search.php?type=keyword&keyword=11g' target=_blank>11g<\/A> <A HREF='https:\/\/www.cppentry.com\/do\/search.php?type=keyword&keyword=%D6%D8%B8%B4' target=_blank>\u91cd\u590d<\/A> <A HREF='https:\/\/www.cppentry.com\/do\/search.php?type=keyword&keyword=%D6%B4%D0%D0' target=_blank>\u6267\u884c<\/A> <A HREF='https:\/\/www.cppentry.com\/do\/search.php?type=keyword&keyword=catupgrd.sql' target=_blank>catupgrd.sql<\/A> <A HREF='https:\/\/www.cppentry.com\/do\/search.php?type=keyword&keyword=%BD%C5%B1%BE' target=_blank>\u811a\u672c<\/A> <A HREF='https:\/\/www.cppentry.com\/do\/search.php?type=keyword&keyword=%D2%FD%C6%F0' target=_blank>\u5f15\u8d77<\/A> <A HREF='https:\/\/www.cppentry.com\/do\/search.php?type=keyword&keyword=%B4%F3%C1%BF' target=_blank>\u5927\u91cf<\/A> <A HREF='https:\/\/www.cppentry.com\/do\/search.php?type=keyword&keyword=ORA-00001' target=_blank>ORA-00001<\/A> <A HREF='https:\/\/www.cppentry.com\/do\/search.php?type=keyword&keyword=%B4%ED%CE%F3' target=_blank>\u9519\u8bef<\/A>","jumpurl":"","iframeurl":"","style":"","template":"a:3:{s:4:\"head\";s:0:\"\";s:4:\"foot\";s:0:\"\";s:8:\"bencandy\";s:0:\"\";}","target":"0","ip":"14.17.22.31","lastfid":"0","money":"0","buyuser":"","passwd":"","allowdown":"","allowview":"","editer":"","edittime":"0","begintime":"0","endtime":"0","description":"\u5347\u7ea7Oracle 11g\u91cd\u590d\u6267\u884ccatupgrd.sql\u811a\u672c\u5f15\u8d77\u5927\u91cfORA-00001\u9519\u8bef","lastview":"1713606214","digg_num":"7842","digg_time":"0","forbidcomment":"0","ifvote":"0","heart":"","htmlname":"","city_id":"0"},"page":"1"}