ORACLE/TroubleShooting2018. 10. 16. 08:20
반응형

ORA-39125: KUPW$WORKER.UNLOAD_METADATA [DBMS_METADATA.FETCH_XML_CLOB]

ORA-39125: KUPW$WORKER.UNLOAD_METADATA [DBMS_METADATA.FETCH_XML_CLOB]을(를) 호출하는 중 TABLE_DATA:"TSMSYS"."SRS$"에서 작업자의 예상치 않은 치명적 오류 발생
ORA-31642: 다음 SQL 문 실패:
BEGIN "SYS"."DBMS_SCHED_EXPORT_CALLOUTS".SCHEMA_CALLOUT(:1,1,1,'10.02.00.03.00'); END;
ORA-06512: "SYS.DBMS_SYS_ERROR", 줄 86에서
ORA-06512: "SYS.DBMS_METADATA", 줄 907에서
ORA-20001: [SDB220001][owner:DBSEC][TABLE][DROP] You cannot do structural changes to this object[SCHEDULER$_PROGRAM_ARG]
ORA-06512: "SYS.DBMS_SYS_ERROR", 줄 105에서
ORA-06512: "SYS.KUPW$WORKER", 줄 6255에서
----- PL/SQL Call Stack -----
object line object
handle number name
B4E12C64 14938 package body SYS.KUPW$WORKER
B4E12C64 6314 package body SYS.KUPW$WORKER
B4E12C64 2340 package body SYS.KUPW$WORKER
B4E12C64 6875 package body SYS.KUPW$WORKER
B4E12C64 1260 package body SYS.KUPW$WORKER
B4C98474 2 anonymous block
"SYSTEM"."SYS_EXPORT_FULL_01" 작업이 10:48:38에서 치명적인 오류로 인해 정지됨
==> drop user tsmsys cascade;

. . "SYSTEM"."SQLPLUS_PRODUCT_PROFILE" 0 KB 0행이 엑스포트됨
ORA-39125: KUPW$WORKER.UNLOAD_METADATA [DBMS_METADATA.FETCH_XML_CLOB]을(를) 호출하는 중 TABLE_DATA:"SYSTEM"."SQLPLUS_PRODUCT_PROFILE"에서 작업자의 예상치 않은 치명적 오류 발생
ORA-31642: 다음 SQL 문 실패:
BEGIN "SYS"."DBMS_SCHED_EXPORT_CALLOUTS".SCHEMA_CALLOUT(:1,1,1,'10.02.00.03.00'); END;
ORA-06512: "SYS.DBMS_SYS_ERROR", 줄 86에서
ORA-06512: "SYS.DBMS_METADATA", 줄 907에서
ORA-20001: [SDB220001][owner:DBSEC][TABLE][DROP] You cannot do structural changes to this object[SCHEDULER$_PROGRAM_ARG]
ORA-06512: "SYS.DBMS_SYS_ERROR", 줄 105에서
ORA-06512: "SYS.KUPW$WORKER", 줄 6255에서
----- PL/SQL Call Stack -----
object line object
handle number name
B4E12C64 14938 package body SYS.KUPW$WORKER
B4E12C64 6314 package body SYS.KUPW$WORKER
B4E12C64 2340 package body SYS.KUPW$WORKER
B4E12C64 6875 package body SYS.KUPW$WORKER
B4E12C64 1260 package body SYS.KUPW$WORKER
D4F866F8 2 anonymous block
"SYSTEM"."SYS_EXPORT_FULL_03" 작업이 11:14:55에서 치명적인 오류로 인해 정지됨
==> @?/rdbms/admin/owmuinst.plb


SQL> purge dba_recyclebin;
purge dba_recyclebin
*
1행에 오류:
ORA-00604: 순환 SQL 레벨 2 에 오류가 발생했습니다
ORA-20001: [SDB220001][owner:DBSEC][TABLE][DROP] You cannot do structural changes to this object[BIN$uzXlsYgaREynfQJjXhC5jQ==$0]
ORA-06512: 줄 8에서


ALTER SYSTEM SET "_system_trig_enabled"=FALSE SCOPE=MEMORY;


expdp.sh
===============================================================================================================
sqlplus '/as sysdba' <<EOF
ALTER SYSTEM SET "_system_trig_enabled"=FALSE SCOPE=MEMORY;
EOF

expdp system/pwd directory=expdp dumpfile=full.`date +%y%m%d`.dmp logfile=full.`date +%y%m%d`.log full=y

sqlplus '/as sysdba' <<EOF
ALTER SYSTEM SET "_system_trig_enabled"=TRUE SCOPE=MEMORY;
drop table system.SYS_EXPORT_FULL_01 purge;
drop table system.SYS_EXPORT_FULL_02 purge;
drop table system.SYS_EXPORT_FULL_03 purge;
drop table system.SYS_EXPORT_FULL_04 purge;
drop table system.SYS_EXPORT_FULL_05 purge;
drop table system.SYS_EXPORT_FULL_06 purge;
drop table system.SYS_EXPORT_FULL_07 purge;
drop table system.SYS_EXPORT_FULL_08 purge;
drop table system.SYS_EXPORT_FULL_09 purge;
drop table system.SYS_EXPORT_FULL_10 purge;
EOF

반응형
Posted by [PineTree]