12.2 DataPump Export (EXPDP) Fails Exporting Full PDB Due To ORA-39126 On KUPW$WORKER.FETCH_XML_OBJECTS
(Doc ID 2361799.1)
Last updated on JULY 25, 2023
Applies to:
Oracle Database - Enterprise Edition - Version 12.2.0.1 and laterOracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Information in this document applies to any platform.
Database does not have Data Vault Installed.
Database upgraded from 11.2.X to 12.2
Symptoms
Starting a DataPump Export job to run a full PDB export in 12.2.0.1, fails with the following errors:
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 105
ORA-06512: at "SYS.KUPW$WORKER", line 12098
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 105
ORA-06512: at "SYS.DBMS_METADATA", line 9039
ORA-06512: at "SYS.DBMS_METADATA", line 2792
ORA-06512: at "SYS.DBMS_METADATA", line 3423
ORA-06512: at "SYS.DBMS_METADATA", line 4760
ORA-06512: at "SYS.DBMS_METADATA", line 5079
ORA-06512: at "SYS.DBMS_METADATA", line 9020
ORA-06512: at "SYS.KUPW$WORKER", line 14367
----- PL/SQL Call Stack -----
object line object
handle number name
0x1201393a0 32239 package body SYS.KUPW$WORKER.WRITE_ERROR_INFORMATION
0x1201393a0 12119 package body SYS.KUPW$WORKER.DETERMINE_FATAL_ERROR
0x1201393a0 14693 package body SYS.KUPW$WORKER.FETCH_XML_OBJECTS
0x1201393a0 3689 package body SYS.KUPW$WORKER.UNLOAD_METADATA
0x1201393a0 13063 package body SYS.KUPW$WORKER.DISPATCH_WORK_ITEMS
0x1201393a0 2311 package body SYS.KUPW$WORKER.MAIN
0x76dc0a40 2 anonymous block
DBMS_METADATA.SET_FILTER
DBMS_METADATA.SET_FILTER
DBMS_METADATA.SET_FILTER
In FETCH_XML_OBJECTS
End seqno is: 24
KUPF$FILE.OPEN_CONTEXT
KUPF$FILE.OPEN_CONTEXT
DBMS_METADATA.FETCH_XML_CLOB
DBMS_METADATA.FETCH_XML_CLOB
In procedure DETERMINE_FATAL_ERROR with ORA-00942: table or view does not exist
After enabling tracing for ORA-00942 error with "alter system set events '942 trace name ERRORSTACK level 3' ", revealed that the missing tables are all Database Vault related.
The generated trace file shows that DVSYS.KU$_DV_ISR_VIEW KU$ does not exist in PDB, hence causing PDB expdp job to fail:
Changes
Database was upgraded from 11.2.X to 12.2.
The error is seen in an Multitenant environment where Database Vault is not enabled.
One has to execute the following command to see whether the Oracle software was compiled with the dv_on option:
$ ar -t libknlopt.a | grep -c kzvidv.o
For IBM AIX:
$ ar -X64 -t libknlopt.a | grep -c kzvidv.o
- If the output is 0, the option is disabled.
- If the output is 1, the option is enabled.
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |