oracle ORA-30511解决方法
报错信息：ORA-39126: Worker unexpected fatal error in KUPW$WORKER.FETCH_XML_OBJECTS
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 lineobject
handle numbername
0x8c13fba0 20462package body SYS.KUPW$WORKER
0x8c13fba0 9028package body SYS.KUPW$WORKER
0x8c13fba0 10935package body SYS.KUPW$WORKER
0x8c13fba0 2728package body SYS.KUPW$WORKER
0x8c13fba0 9697package body SYS.KUPW$WORKER
0x8c13fba0 1775package body SYS.KUPW$WORKER
0x9170abb8 2anonymous 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
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
SESS 910580-2012-05-14 13:32:43 : DDL : Cleaned up rows from marker table
SESS 910580-2012-05-14 13:32:43 : DDL : Cleaning up DDL sequence
SESS 910580-2012-05-14 13:32:43 : DDL : Cleaned up rows from DDL table
SESS 910580-2012-05-14 13:32:43 : DDL : DDL ignored, it is recycle bin DDL, text
操作：
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";
页:
[1]