Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Impdp is getting failed due below error ORA-31626,ORA-06512, ORA-39080,ORA-04021

SHANOJApr 22 2015 — edited May 5 2015

BANNER

--------------------------------------------------------------------------------

Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

PL/SQL Release 11.2.0.4.0 - Production

CORE    11.2.0.4.0      Production

TNS for Linux: Version 11.2.0.4.0 - Production

NLSRTL Version 11.2.0.4.0 - Production

Error:

====

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

With the Partitioning, Automatic Storage Management, OLAP, Data Mining

and Real Application Testing options

ORA-31626: job does not exist

ORA-31637: cannot create job SS_NEW for user SYS

ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95

ORA-06512: at "SYS.KUPV$FT_INT", line 798

ORA-39080: failed to create queues "KUPC$C_1_20150221000500" and "" for Data Pump job

ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95

ORA-06512: at "SYS.KUPC$QUE_INT", line 1534

ORA-04021: timeout occurred while waiting to lock object

Parfile:

=====

userid="/ as sysdba"

schemas=PEPSI

dumpfile=expdat.dmp

logfile=PEPSI_export.log

directory=MY_DIR

parallel=4

exclude=sequence

TABLE_EXISTS_ACTION=REPLACE

JOB_NAME=JOB1_TK

Please advice what is the solution ....

Thanks in advance.

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 2 2015
Added on Apr 22 2015
5 comments
3,062 views