DOYENSYS Knowledge Portal




We Welcome you to visit our DOYENSYS KNOWLEDGE PORTAL : Doyensys Knowledge Portal




Wednesday, January 11, 2017

ORA-39125: Worker unexpected fatal error in KUPW$WORKER.GET_TABLE_DATA_OBJECTS while calling DBMS_METADATA.FETCH_XML_CLOB []

While taking EXPDP backup of the schema of 10.2.0.4.0 database got the following error

ORA-39125: Worker unexpected fatal error in KUPW$WORKER.GET_TABLE_DATA_OBJECTS while calling DBMS_METADATA.FETCH_XML_CLOB []

[oracle@mums00100252 install]$ expdp TFWUSR1/TFWQAOS01PWD1 schemas=TFWUSR1 directory=DATAPUMP_DIR dumpfile=TFWUSR1.dmp logfile=TFWUSR1.log
Export: Release 10.2.0.4.0 - 64bit Production on Wednesday, 11 July, 2012 16:05:42 Copyright (c) 2003, 2007, Oracle.  All rights reserved.
Connected to: Oracle Database 10g Release 10.2.0.4.0 - 64bit Production
Starting TFWUSR1.SYS_EXPORT_SCHEMA_01:  TFWUSR1/******** schemas=TFWUSR1 directory=DATAPUMP_DIR dumpfile=TFWUSR1.dmp logfile=TFWUSR1.log
Estimate in progress using BLOCKS method...
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
ORA-39125: Worker unexpected fatal error in KUPW$WORKER.GET_TABLE_DATA_OBJECTS while calling DBMS_METADATA.FETCH_XML_CLOB []
ORA-31642: the following SQL statement fails:
BEGIN DMSYS.DBMS_DM_MODEL_EXP.SCHEMA_CALLOUT(:1,0,1,'10.02.00.04.00'); END;
ORA-06512: at SYS.DBMS_SYS_ERROR, line 86
ORA-06512: at SYS.DBMS_METADATA, line 907
ORA-04063: package body DMSYS.DBMS_DM_IMP_INTERNAL has errors
ORA-06508: PL/SQL: could not find program unit being called: DMSYS.DBMS_DM_IMP_INTERNAL
ORA-06512: at SYS.DBMS_SYS_ERROR, line 95
ORA-06512: at SYS.KUPW$WORKER, line 6307
----- PL/SQL Call Stack -----
  object      line  object
  handle    number  name
0x740c0e80     15032  package body SYS.KUPW$WORKER
0x740c0e80      6372  package body SYS.KUPW$WORKER
0x740c0e80      9206  package body SYS.KUPW$WORKER
0x740c0e80      1936  package body SYS.KUPW$WORKER
0x740c0e80      6944  package body SYS.KUPW$WORKER
0x740c0e80      1314  package body SYS.KUPW$WORKER
0x742ab940         2  anonymous block


Job TFWUSR1.SYS_EXPORT_SCHEMA_01 stopped due to fatal error at 16:05:49


When I checked the status of components , I found the Oracle packages & Types found invalid,

17:59:47 SYS@TFWQAOS1 > col COMP_NAME format a40
17:59:53 SYS@TFWQAOS1 > col STATUS format a7
17:59:53 SYS@TFWQAOS1 > col COMP_ID format a8
17:59:53 SYS@TFWQAOS1 > col VERSION format a10
17:59:53 SYS@TFWQAOS1 > 
17:59:54 SYS@TFWQAOS1 > SELECT COMP_ID, COMP_NAME, VERSION, STATUS FROM DBA_REGISTRY;

COMP_ID  COMP_NAME                                VERSION    STATUS             
-------- ---------------------------------------- ---------- -------            
ODM      Oracle Data Mining                       10.2.0.4.0 VALID              
SDO      Spatial                                  10.2.0.4.0 VALID              
ORDIM    Oracle interMedia                        10.2.0.4.0 VALID              
AMD      OLAP Catalog                             10.2.0.4.0 INVALID            
EM       Oracle Enterprise Manager                10.2.0.4.0 VALID              
XDB      Oracle XML Database                      10.2.0.4.0 VALID              
CONTEXT  Oracle Text                              10.2.0.4.0 VALID              
EXF      Oracle Expression Filter                 10.2.0.4.0 INVALID            
RUL      Oracle Rules Manager                     10.2.0.4.0 INVALID            
OWM      Oracle Workspace Manager                 10.2.0.4.3 VALID              
CATALOG  Oracle Database Catalog Views            10.2.0.4.0 VALID              

COMP_ID  COMP_NAME                                VERSION    STATUS             
-------- ---------------------------------------- ---------- -------            
CATPROC  Oracle Database Packages and Types       10.2.0.4.0 INVALID            
JAVAVM   JServer JAVA Virtual Machine             10.2.0.4.0 VALID              
XML      Oracle XDK                               10.2.0.4.0 VALID              
CATJAVA  Oracle Database Java Packages            10.2.0.4.0 VALID              
APS      OLAP Analytic Workspace                  10.2.0.4.0 INVALID            
XOQ      Oracle OLAP API                          10.2.0.4.0 INVALID            

17 rows selected.



This was due to some issues at the time of upgradation from 10.2.0.1.0 to 10.2.0.4.0
This error mainly due to EXFSYS schema is not installed properly.
Problem Resolved after installing EXFSYS schema.
Follow the steps mentioned below to install EXFSYS schema,
 Solution:
Installing the EXFSYS schema: 
1. Login as SYSDBA 
2. @?/rdbms/admin/catexf.sql 

No comments: