ORA-04063: package body "SYS.DBMS_DATAPUMP" has errors
By running an import datapump with a 11.2.0.3 database I encountered the following error:
UDI-04063: operation generated ORACLE error 4063
ORA-04063: package body "SYS.DBMS_DATAPUMP" has errors
ORA-06508: PL / SQL: program unit of Appointee "SYS.DBMS_DATAPUMP" found
ORA-06512: a line 1
I tried to compile invalid objects, but always the same problem:
? SYS> @ / rdbms / admin / utlrp
SYS> dbms_datapump alter package compile body;
Warning: package body changes with compilation errors.
SYS> show errors
Errors for DBMS_DATAPUMP PACKAGE BODY:
LINE / COL ERROR
-------- ---------------------------- -------------------------------------
4490/3 PL / SQL: Statement ignored
4490/3 PLS -00 306: number or types of arguments in erroneous call
'GET_STATUS_INT'
See the list of invalid objects:
select u.name owner, object_name o.name, o.status status
from SYS.USER $ u, $ o sys.obj
Where u.user # = # o.owner
and o.status! = 1
order by owner;
DBMS_DATAPUMP SYS 3
SYS _NEXT_OBJECT 0
Reload datapump therefore as follows:
? SYS> @ / rdbms / admin / dbmsdp.sql
This generates other invalid objects but SYS.DBMS_DATAPUMP is not in the list:
select u.name owner, o.name object_name, o.status status
from SYS.USER $ u, $ o sys.obj
where u.user # = # o.owner
and o.status! = 1
order by owner;
OWNER OBJECT_NAME STATUS
------------------------------ ----------------- ------------- ----------
SYS KUPC _Exit $ 5
SYS KUPC _SQL_FILE_JOB $ 5
SYS KUPC _ESTIMATE_JOB $ 5
SYS KUPC _LOAD_DATA $ 5
SYS KUPC _LOAD_METADATA $ 5
SYS KUPC $ 5 _UNLOAD_DATA
SYS KUPC _UNLOAD_METADATA $ 5
SYS KUPC _RELEASE_FILES $ 5
SYS KUPC _SEQUENTIAL_FILE $ 5
SYS KUPC _DISK_FILE $ 5
SYS KUPC _STOP_JOB $ 5
SYS KUPC _START_JOB $ 5
SYS KUPC _SET_PARAMETER $ 5
OWNER OBJECT_NAME STATUS
--------- --------------------- ----------------------------- - ----------
SYS KUPC _SET_PARALLEL $ 5
SYS KUPC _OPEN $ 5
SYS KUPC _METADATA_REMAP $ 5
SYS KUPC _METADATA_TRANSFORM $ 5
SYS KUPC _METADATA_FILTER $ 5
SYS KUPC _LOG_ERROR $ 5
SYS KUPC _LOG_ENTRY $ 5
SYS KUPC $ _DATA_REMAP 5
SYS KUPC _DATA_FILTER $ 5
SYS KUPC _RESTART $ 5
SYS KUPC _ADD_FILE $ 5
OWNER OBJECT_NAME STATUS
------------------------------ - ----------------------------- ----------
SYS KUPC _ADD_DEVICE $ 5
SYS KUPC _MESSAGE $ 5
SYS KUPCC 5
SYS _NEXT_OBJECT 0
SYS DBMS_CUBE_EXP 5
SYS DBMS_AW_EXP 5
SYS DBMS_CDC_EXPDP 5
SYS DBMS_CDC_DPUTIL 5
SYS DBMS_DST 5
SYS DBMS_DATA_MINING 5
SYS DBMS_DM_IMP_INTERNAL 5
OWNER OBJECT_NAME STATUS
--------------------- --------- ------------------------------ ----------
SYS DBMS_DM_EXP_INTERNAL 5
SYS DBMS_DM_MODEL_IMP 5
SYS DBMS_DM_MODEL_EXP 5
SYS DBMS_DM_EXP_INTERNAL 5
SYS DMP_SEC 5
SYS DBMS_SQLTCB_INTERNAL 5
SYS DBMS_FILE_GROUP_UTL_INVOK 5
SYS DBMS_STREAMS_TABLESPACE_ADM 5
SYS DBMS_STREAMS_TBS_INT_INVOK 5
SYS DBMS_STREAMS_TBS_INT 5
SYS DBMS_STREAMS_DATAPUMP_UTIL 5
OWNER OBJECT_NAME STATUS
--------------- --------------- ------------------------------ ----- -----
SYS DBMS_STREAMS_DATAPUMP 5
SYS DBMS_STREAMS_RPC 5
SYS DBMS_LOGREP_IMP 5
SYS DBMS_LOGREP_EXP 5
SYS DBMS_STREAMS_MT 5
SYS DBMS_REPCAT_EXP 5
SYS DBMS_WRR_INTERNAL 5
SYS DBMS_SWRF_INTERNAL 5
SYS LOGSTDBY_INTERNAL 5
SYS DBMS_RULE_EXP_UTL 5
SYS DBMS_TTS 5
OWNER OBJECT_NAME STATUS
--------- --------------------- ----------------------------- - ----------
SYS DBMS_PLUGTS 5
SYS KUPV FT_INT $ 5
SYS FT KUPV $ 5
SYS KUPD DATA_INT $ 5
SYS KUPD $ 5 DATA
SYS KUPP $ PROC 5
SYS Kupf $ 5 FILE
SYS Kupf FILE_INT $ 5
SYS KUPM $ 5 MCP
SYS KUPW $ 5 WORKER
SYS KUPC QUE_INT $ 5
OWNER OBJECT_NAME STATUS
------------------------------ --- ---------- ---------------------------
SYS KUPC QUEUE_INT $ 5
SYS DBMS_DATAPUMP 5
SYS DBMS_METADATA_UTIL 5
SYS DBMS_METADATA_INT 5
SYS DBMS_METADATA 5
SYS DBMS_SCHED_MAIN_EXPORT 5
SYS DBMS_STREAMS_TBS_INT_INVOK 5
SYS Kupf FILE_INT $ 5
SYS KUPC _WORKER_GET_PWD $ 5
SYS KUPC _WORKER_FILE_LIST $ 5
SYS KUPC _WORKER_EXIT $ 5
OWNER OBJECT_NAME STATUS
----------------- ------------- ------------------------------ ------- ---
SYS KUPC _WORKERERROR $ 5
SYS KUPC _WORKER_LOG_ENTRY $ 5
SYS KUPC _TABLE_DATA_ARRAY $ 5
SYS KUPC _BAD_FILE $ 5
SYS KUPC _DEVICE_IDENT $ 5
SYS KUPC _WORKER_FILE $ 5
SYS KUPC _GET_WORK $ 5
SYS KUPC _ENCRYPTED_PWD $ 5
SYS KUPC _FILE_LIST $ 5
SYS KUPC $ 5 _MASTERJOBINFO
SYS KUPC _MASTERERROR $ 5
OWNER OBJECT_NAME STATUS
------------------------------ --------- --------------------- ----------
SYS KUPC _API_ACK $ 5
SYS KUPC _POST_MT_INIT $ 5
Compile invalid objects:
SYS> @? / rdbms / admin / utlrp
After compilation:
select u.name owner, object_name o.name, o.status status
from SYS.USER $ u, $ o sys.obj
where u.user # = # o.owner
and o. status = 1!
order by owner;
SYS _NEXT_OBJECT 0
