Tuesday, December 29, 2015

expdp or exp were failing with ORA-39126 SYS.KUPW$WORKER

The expdp or exp were failing with the below errors:

ORA-39126: Worker unexpected fatal error in KUPW$WORKER.FETCH_XML_OBJECTS [PROCACT_SCHEMA:"OPS$ORACLE"]
ORA-19051: Cannot use fast path insert for this XMLType table
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPW$WORKER", line 9001
----- PL/SQL Call Stack -----
  object      line  object
  handle    number  name
70000007befb878     20462  package body SYS.KUPW$WORKER
70000007befb878      9028  package body SYS.KUPW$WORKER
70000007befb878     10935  package body SYS.KUPW$WORKER
70000007befb878      2728  package body SYS.KUPW$WORKER
70000007befb878      9697  package body SYS.KUPW$WORKER
70000007befb878      1775  package body SYS.KUPW$WORKER
700000072fa8930         2  anonymous block

Reason:
When the 11g DB was started LD_LIBRARY_PATH and LIBPATH were pointing to 10g Home (any DB at the time of startup if the above Library variables are not pointing to current DB ORCLE_HOME)

- in my case we have oracle versions in the server 11g and 10g, at the time 11g DB startup LIB variables are pointing to 10g.

Fix:
I’ve set the below parameters explicitly and restart the database which has fixed the issue
ushux37$ export LIBPATH=/u01/app/oracle/product/11.2.0/lib:/u01/app/oracle/product/11.2.0/lib32
ushux37$ export LD_LIBRARY_PATH=/u01/app/oracle/product/11.2.0/lib:/u01/app/oracle/product/11.2.0/network/lib

No comments:

Post a Comment