oracle ORA-30511解决方法

outlook

　　报错信息：
　　ORA-39126: Worker unexpected fatal error in KUPW$WORKER.FETCH_XML_OBJECTS [TABLE_DATA:"MIBON"."TEXT_PASSPORT"]
　　ORA-31642: the following SQL statement fails:
　　BEGIN "SYS"."DBMS_SCHED_EXPORT_CALLOUTS".SCHEMA_CALLOUT(:1,1,1,'11.02.00.00.00'); END;
　　ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
　　ORA-06512: at "SYS.DBMS_METADATA", line 1749
　　ORA-30511: invalid DDL operation in system triggers
　　ORA-06512: at line 894
　　ORA-30511: invalid DDL operation in system triggers
　　ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
　　ORA-06512: at "SYS.KUPW$WORKER", line 9001
　　----- PL/SQL Call Stack -----
　　object      line  object
　　handle    number  name
　　0x8c13fba0     20462  package body SYS.KUPW$WORKER
　　0x8c13fba0      9028  package body SYS.KUPW$WORKER
　　0x8c13fba0     10935  package body SYS.KUPW$WORKER
　　0x8c13fba0      2728  package body SYS.KUPW$WORKER
　　0x8c13fba0      9697  package body SYS.KUPW$WORKER
　　0x8c13fba0      1775  package body SYS.KUPW$WORKER
　　0x9170abb8         2  anonymous block
　　Job "SYSTEM"."SYS_EXPORT_SCHEMA_02" stopped due to fatal error at 11:27:40
　　---------------------------------
　　解决方案：
　　参照metalink：
　　OGG Extract Abend with GGS ERROR 2003 or OGG-00458 Cannot Find Metadata Property or Similar [ID 1365809.1]
　　Login as sysdba to the database
　　Step 1) Run the ddl_disable script to disable the DDL trigger.
　　SQL> @ddl_disable.sql
　　sqlplus "/as sysdba"

　　SQL>>　　重启数据库
　　Step 2) Run the ddl_setup script. You will be prompted for:
　　-- The name of the GoldenGate schema.
　　-- The installation mode: Select the INITIALSETUP mode.
　　Depending on the GGS version you may also be prompted for
　　-- Purge RECYCLEBIN for all users: say YES.
　　SQL> @/home/db/ogg/ddl_setup.sql
　　Step 3) Run the ddl_enable.sql script to enable the DDL trigger.
　　SQL> @/home/db/ogg/ddl_enable.sql
　　Step 4). In GGSCI, restart the manager and then start Extract to resume DDL capture.
　　Step 5) Verify if the errors are still reported.
　　如果报如下错：
　　SESS 910580-2012-05-14 13:32:43 : DDL : Cleaning up marker sequence [5536]
　　SESS 910580-2012-05-14 13:32:43 : DDL : Cleaned up [0] rows from marker table
　　SESS 910580-2012-05-14 13:32:43 : DDL : Cleaning up DDL sequence [1]
　　SESS 910580-2012-05-14 13:32:43 : DDL : Cleaned up [0] rows from DDL table
　　SESS 910580-2012-05-14 13:32:43 : DDL : DDL ignored, it is recycle bin DDL, text [alter table "OGG"."BIN$v7zn4ONoHRDgQ2sAqMDpHw==$0" drop constraint "BIN$v7zn4ONmHRDgQ2sAqMDpHw==$0" ]
　　操作：
　　sqlplus ogg/ogg
　　select * from tab;  --查看回收站中的表
　　drop掉所有回收站中的表:
　　drop table "BIN$v7zn4ONoHRDgQ2sAqMDpHw==$0";
　　drop table "BIN$v7zn4ONtHRDgQ2sAqMDpHw==$0";
　　drop table "BIN$v7zn4OOBHRDgQ2sAqMDpHw==$0";
　　drop table "BIN$v7zn4OOEHRDgQ2sAqMDpHw==$0";
　　drop table "BIN$v7zn4OOHHRDgQ2sAqMDpHw==$0";
　　drop table "BIN$v7zn4OOMHRDgQ2sAqMDpHw==$0";
　　drop table "BIN$v7zn4OOYHRDgQ2sAqMDpHw==$0";
　　drop table "BIN$v7zn4OOaHRDgQ2sAqMDpHw==$0";
　　drop table "BIN$v7zn4OOcHRDgQ2sAqMDpHw==$0";
　　drop table "BIN$v7zn4OOeHRDgQ2sAqMDpHw==$0";
　　drop table "BIN$v7zn4OOgHRDgQ2sAqMDpHw==$0";
　　drop table "BIN$v7zn4OOjHRDgQ2sAqMDpHw==$0";