Skip to Main Content

SQL & PL/SQL

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

DBMS_DataPump.OPEN fails in Oracle 18c error:

User_TK218Sep 16 2021

Recently I am upgrading from Oracle 11g to 18c.
So everything was working fine in 11g but in 18c I am getting an error
ORA 31626: job does not exist
So the work flow is I have a scheduler job named CREATE_BACKUP which runs every week. It contains all the code to create the backup
To create DB backup we use DBMS_DataPump API and initially doing
DBMS_DataPump.OPEN(operation => 'EXPORT', job_mode => 'SCHEMA', remote_link => NULL, job_name => 'J$AIM_BACKUP', VERSION => 'LATEST');
Once again everything is working fine in Oracle 11g but when I run in 18c I am getting an error
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 79
ORA-06512: at "SYS.DBMS_DATAPUMP", line 1137
ORA-06512: at "SYS.DBMS_DATAPUMP", line 5285
ORA-06512: at line 14

  • ORA-31626: job does not exist

I am already granting EXP_FULL_DATABASE and DATAPUMP_EXP_FULL_DATABASE to the corresponding user while database installation.
Do you think, there might be something I can check what's the specific reason for the error? Or anything I missed or any suggestions?

Comments

Processing

Post Details

Added on Sep 16 2021
15 comments
720 views