EXPDP - ORA-39127 ORA-04045 ORA-02290 (check constraint (SYS.JAVA_DEV_DISABLED) violated) ORA-06508
(Doc ID 1981824.1)
Last updated on NOVEMBER 25, 2019
Applies to:
Oracle Database - Personal Edition - Version 11.1.0.7 to 12.2.0.1 [Release 11.1 to 12.2]Oracle Database - Standard Edition - Version 11.1.0.7 to 12.2.0.1 [Release 11.1 to 12.2]
Oracle Database - Enterprise Edition - Version 11.1.0.7 to 12.2.0.1 [Release 11.1 to 12.2]
Enterprise Manager for Oracle Database - Version 11.1.0.7 to 13.1.2.0.0 [Release 11.1 to 13.1]
Oracle Database Exadata Cloud Machine - Version N/A and later
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/<PASSWORD> directory=<DIRECTORYNAME> dumpfile=<FILENAME>.dmp logfile=<FILENAME>.log full=y content=metadata_only schemas=<SCHEMANAME>
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=<DIRECTORYNAME> dumpfile=<FILENAME>.dmp logfile=<FILENAME>.log full=y content=metadata_only schemas=<SCHEMANAME>
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('<SCHEMANAME>',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('<SCHEMANAME>',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('<SCHEMANAME>',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('<SCHEMANAME>',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
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=<DIRECTORYNAME> dumpfile=<FILENAME>.dmp logfile=<FILENAME>.log full=y content=metadata_only schemas=<SCHEMANAME>
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('<SCHEMANAME>',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('<SCHEMANAME>',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('<SCHEMANAME>',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('<SCHEMANAME>',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
Changes
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 |