Datapump Error : expdp | ORA-39065 | ORA-01403

Env: 11.2.0.3

I had this env created manually(not using DBCA). I hit the below error while running expdp.

expdp DIRECTORY=DATA_PUMP_DIR DUMPFILE=xxxxxxxxxxxxxxxxxx.....
Username: / as sysdba
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, Oracle Label Security, OLAP,
Data Mining, Oracle Database Vault and Real Application Testing options
ORA-39006: internal error
ORA-39065: unexpected master process exception in DISPATCH
ORA-01403: no data found
ORA-39097: Data Pump job encountered unexpected error 100

Probably i missed to run the misc files which we usually run after creating the DB manually. Finally i got through by executing

cd $ORACLE_HOME/rdbms/admin
sqlplus / as sysdba 
@catmet2.sql 
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.

@utlrp.sql

 

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s