Failure of Datapatch on Multitenant Enviroment Can Cause DataPump Dictionary Inconsisteny in Pluggable Database (PDB)

(Doc ID 2327652.1)

Last updated on NOVEMBER 14, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.2 to 12.1.0.2 [Release 12.1]
Information in this document applies to any platform.

Symptoms

Data Pump Job (expdp or impdp) is failing with 'ORA-00942: table or view does not exist' on both CDB$ROOT and PDBs.

The trace file shows the following information:

ORA-39126: Worker unexpected fatal error in KUPW$WORKER.FETCH_XML_OBJECTS [PROCACT_SCHEMA:"SYS"]
ORA-00942: table or view does not exist

ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPW$WORKER", line 11259

----- PL/SQL Call Stack -----
 object      line  object
 handle    number  name
0x9fab8720     27116  package body SYS.KUPW$WORKER
0x9fab8720     11286  package body SYS.KUPW$WORKER
0x9fab8720     13515  package body SYS.KUPW$WORKER
0x9fab8720      3173  package body SYS.KUPW$WORKER
0x9fab8720     12035  package body SYS.KUPW$WORKER
0x9fab8720      2081  package body SYS.KUPW$WORKER
0x1091ee8f0         2  anonymous block

KUPF$FILE.WRITE_LOB
KUPF$FILE.WRITE_LOB
MD FilePieces Count: 1
FORALL
FORALL
DBMS_LOB.TRIM
DBMS_LOB.TRIM
DBMS_METADATA.FETCH_XML_CLOB
DBMS_METADATA.FETCH_XML_CLOB
In procedure DETERMINE_FATAL_ERROR with ORA-00942: table or view does not exist
ORA-39126: Worker unexpected fatal error in KUPW$WORKER.FETCH_XML_OBJECTS []
ORA-22814: attribute or element value is larger than specified in type

 

Enabling tracing for ORA-00942 error with:

SQL> alter system set events = '942 trace name ERRORSTACK level 3';

has helped to determine that the AQ$KUPC$DATAPUMP_QUETAB_1 view is missing.
The missing object can be different then the one showing below, as long as the object belongs to sys this indicates that tan object is missing from Data Pump catalog.

In this case, the generated trace file shows:

dbkedDefDump(): Starting a non-incident diagnostic dump (flags=0x0, level=3, mask=0x0)
----- Error Stack Dump -----
ORA-00942: table or view does not exist
----- Current SQL Statement for this session (sql_id=9gjr17ahr9fx1) -----
CREATE OR REPLACE FORCE VIEW "SYS"."AQ$KUPC$DATAPUMP_QUETAB_1" sharing=none  AS SELECT  q_name QUEUE, qt.msgid MSG_ID, corrid CORR_ID,  priority MSG_PRIORITY,  decode(bitand(s.subscriber_type,2) , 2,'UNDELIVERABLE',decode(h.dequeue_time, NULL,decode(l.dequeue_time, NULL, decode(state, 0,   'READY',   . . . . . . . . .

 

Changes

This issue has started to be hit after failed post patch activity of July 2017 QFSDP (Quarterly Full Stack Database Patchset)

WITH ERRORS
/u01/app/oracle/cfgtoollogs/sqlpatch/26609798/21481992/26609798_apply_<db_name>_DB_2017Oct29_09_19_15.log

This issue could also occur if a Generic DataPump patch was applied on a Multitenant environment.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms