EXPDP - ORA-39127 ORA-04045 ORA-02290 (check constraint (SYS.JAVA_DEV_DISABLED) violated) ORA-06508 (Doc ID 1981824.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 11.1.0.7 to 12.1.0.2 [Release 11.1 to 12.1]
Oracle Database - Personal Edition - Version 11.1.0.7 to 12.1.0.2 [Release 11.1 to 12.1]
Oracle Database - Standard Edition - Version 11.1.0.7 to 12.1.0.2 [Release 11.1 to 12.1]
Enterprise Manager for Oracle Database - Version 11.1.0.7 to 12.1.0.7.0 [Release 11.1 to 12.1]
Information in this document applies to any platform.

Symptoms

1. You recently installed the JAVA "Mitigation" patch in accordance to the 'Alternative Approach' as mentioned in:
<Note 1929745.1> - Oracle Recommended Patches -- "Oracle JavaVM Component Database PSU" (OJVM PSU) Patches

2. After some later point in time when an outage could be taken you installed the Oracle JAVA Virtual Machine Patch Set Update (OJVM PSU) patch.

3. After the installation of the OJVM PSU, you ran a schema level export with Export DataPump, e.g.:

$ expdp system/manager directory=my_dir dumpfile=expdp_f.dmp logfile=expdp_f.log full=y content=metadata_only schemas=iem

Export: Release 11.1.0.7.0 - 64bit Production on Monday, 09 February, 2015 8:10:05
Copyright (c) 2003, 2007, Oracle.  All rights reserved.

Connected to: Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
FLASHBACK automatically enabled to preserve database integrity.
Starting "SYSTEM"."SYS_EXPORT_SCHEMA_01":  system/******** directory=my_dir dumpfile=expdp_f.dmp logfile=expdp_f.log full=y content=metadata_only schemas=iem
Processing object type SCHEMA_EXPORT/USER
Processing object type SCHEMA_EXPORT/SYSTEM_GRANT
Processing object type SCHEMA_EXPORT/DEFAULT_ROLE
Processing object type SCHEMA_EXPORT/TABLESPACE_QUOTA
ORA-39127: unexpected error from call to export_string :=SYS.DBMS_CDC_EXPDP.schema_info_exp('IEM',0,1,'11.01.00.00.00',newblock)
ORA-04045: errors during recompilation/revalidation of SYS.DBMS_CDC_UTILITY
ORA-02290: check constraint (SYS.JAVA_DEV_DISABLED) violated
ORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_CDC_UTILITY"
ORA-06512: at "SYS.DBMS_CDC_EXPDP", line 340
ORA-06512: at line 1
ORA-06512: at "SYS.DBMS_METADATA", line 5929
ORA-39127: unexpected error from call to export_string :=SYS.DBMS_CDC_EXPVDP.schema_info_exp('IEM',0,1,'11.01.00.00.00',newblock)
ORA-04045: errors during recompilation/revalidation of SYS.DBMS_CDC_UTILITY
ORA-02290: check constraint (SYS.JAVA_DEV_DISABLED) violated
ORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_CDC_UTILITY"
ORA-06512: at "SYS.DBMS_CDC_EXPVDP", line 16
ORA-06512: at line 1
ORA-06512: at "SYS.DBMS_METADATA", line 5929
Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
Processing object type SCHEMA_EXPORT/SEQUENCE/SEQUENCE
Processing object type SCHEMA_EXPORT/SEQUENCE/GRANT/OWNER_GRANT/OBJECT_GRANT
Processing object type SCHEMA_EXPORT/SEQUENCE/GRANT/CROSS_SCHEMA/OBJECT_GRANT
Processing object type SCHEMA_EXPORT/TABLE/TABLE
Processing object type SCHEMA_EXPORT/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT
Processing object type SCHEMA_EXPORT/TABLE/GRANT/CROSS_SCHEMA/OBJECT_GRANT
Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX
Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
Processing object type SCHEMA_EXPORT/PACKAGE/PACKAGE_SPEC
Processing object type SCHEMA_EXPORT/PACKAGE/COMPILE_PACKAGE/PACKAGE_SPEC/ALTER_PACKAGE_SPEC
Processing object type SCHEMA_EXPORT/VIEW/VIEW
Processing object type SCHEMA_EXPORT/PACKAGE/PACKAGE_BODY
Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
Processing object type SCHEMA_EXPORT/TABLE/POST_INSTANCE/PROCACT_INSTANCE
Processing object type SCHEMA_EXPORT/TABLE/POST_INSTANCE/PROCDEPOBJ
ORA-39127: unexpected error from call to export_string :=SYS.DBMS_CDC_EXPDP.schema_info_exp('IEM',1,1,'11.01.00.00.00',newblock)
ORA-04045: errors during recompilation/revalidation of SYS.DBMS_CDC_UTILITY
ORA-02290: check constraint (SYS.JAVA_DEV_DISABLED) violated
ORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_CDC_UTILITY"
ORA-06512: at "SYS.DBMS_CDC_EXPDP", line 340
ORA-06512: at line 1
ORA-06512: at "SYS.DBMS_METADATA", line 5929
ORA-39127: unexpected error from call to export_string :=SYS.DBMS_CDC_EXPVDP.schema_info_exp('IEM',1,1,'11.01.00.00.00',newblock)
ORA-04045: errors during recompilation/revalidation of SYS.DBMS_CDC_UTILITY
ORA-02290: check constraint (SYS.JAVA_DEV_DISABLED) violated
ORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_CDC_UTILITY"
ORA-06512: at "SYS.DBMS_CDC_EXPVDP", line 16
ORA-06512: at line 1
ORA-06512: at "SYS.DBMS_METADATA", line 5929
Processing object type SCHEMA_EXPORT/POST_SCHEMA/PROCACT_SCHEMA
ORA-39126: Worker unexpected fatal error in KUPW$WORKER.UNLOAD_METADATA []
ORA-31642: the following SQL statement fails:
BEGIN "SYS"."DBMS_CDC_EXPDP".SCHEMA_CALLOUT(:1,1,1,'11.01.00.00.00'); END;
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: at "SYS.DBMS_METADATA", line 923
ORA-04045: errors during recompilation/revalidation of SYS.DBMS_CDC_UTILITY
ORA-02290: check constraint (SYS.JAVA_DEV_DISABLED) violated
ORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_CDC_UTILITY"

ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: at "SYS.KUPW$WORKER", line 7834

----- PL/SQL Call Stack -----
 object      line  object
 handle    number  name
c00000222deb8c30     18237  package body SYS.KUPW$WORKER
c00000222deb8c30      7866  package body SYS.KUPW$WORKER
c00000222deb8c30      2744  package body SYS.KUPW$WORKER
c00000222deb8c30      8504  package body SYS.KUPW$WORKER
c000002231988460         1  anonymous block
c00000222db24040      1575  package body SYS.DBMS_SQL
c00000222deb8c30      8342  package body SYS.KUPW$WORKER
c00000222deb8c30      1545  package body SYS.KUPW$WORKER
c00000223349fa10         2  anonymous block

Job "SYSTEM"."SYS_EXPORT_SCHEMA_01" stopped due to fatal error at 08:11:50

 

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