Rebuild the DATAPUMP utility in Internal Error situations

Rebuild the DATAPUMP utility in Internal Error situations
Step1 :
Run the Catproc.sql in affected database:
SQL> @$ORACLE_HOME/rdbms/admin/catproc.sql
Step 2:
Compile the invalid objects, if any
SQL> @$ORACLE_HOME/rdbms/admin/utlrp.sql
Step 3:
Rebuild the DataPump packages with the following steps.
Under the ORACLE_HOME, execute:
cd rdbms/admin
— run the dpload.sql in the CDB with all of the PDBs open
From a SQL*Plus session, connect as sysdba 
and then run dpload.sql:
@dpload.sql
on the affected database. 
Note: If DataPump catalog is not valid in a PDB, same step should be executed to validate the DP catalog on a pluggable database.
  • January 20, 2019 | 28 views
  • Comments