DataPump Export (EXPDP) Failed On Identifier SYS.DBMS_JVM_EXP_PERMS Must Be Declared (Doc ID 1095533.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.1 to 11.1.0.7 [Release 10.2 to 11.1]
Oracle Database - Enterprise Edition - Version 11.2.0.4 to 11.2.0.4 [Release 11.2]
Information in this document applies to any platform.
***Checked for relevance on 06-May-2013***

Symptoms

Working in 11.1.0.7 the following errors are raised while exporting the Database with DataPump:

ORA-39127: unexpected error from call to
BEGIN :1=SYS.DBMS_JVM_EXP_PERMS.grant_sysprivs_exp(11.01.00.00.00,:3); END;
ORA-06550: line 1, column 13:  PLS-00201: identifier 'SYS.DBMS_JVM_EXP_PERMS' must be declared

Changes

The JVM was removed from this DB while working in 10.2.0.4, before upgrading to 11g.

DBA registry information shows:

connect / as sysdba

select comp_name, version, status from dba_registry;

COMP_NAME                     VERSION    STATUS
----------------------------- ---------- -------
JServer JAVA Virtual Machine  10.2.0.4.0 REMOVED
Oracle Database Java Packages 10.2.0.4.0 REMOVED

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