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!

Full expdp fails after successful upgrade

TheLonelyDBAJun 2 2020 — edited Jun 4 2020

Solaris SPARC

11.2.0.4->19c

Export job has been running fine for a couple of years, but after an upgrade we see this:

DATABASE_EXPORT/SCHEMA/TYPE/GRANT/OWNER_GRANT/OBJECT_GRANT

ORA-39127: unexpected error from call to TAG: SCHEDULER Calling: SYS.DBMS_SCHED_JOB_EXPORT.GRANT_EXP obj: PETUSER.JOB_LOAD_PARSE_UPDATE_RECEIPTS - SCHEDULER JOB

ORA-01031: insufficient privileges

ORA-06512: at "SYS.DBMS_SCHED_MAIN_EXPORT", line 2704

ORA-06512: at "SYS.DBMS_SCHED_JOB_EXPORT", line 53

ORA-06512: at line 1

ORA-06512: at "SYS.DBMS_SCHED_MAIN_EXPORT", line 2704

ORA-06512: at "SYS.DBMS_SCHED_JOB_EXPORT", line 53

ORA-06512: at line 1

ORA-06512: at "SYS.DBMS_METADATA", line 11144

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

The export continues, but would like to fix this

Regards

TheLonelyDBA

Added on Jun 2 2020

#database-key-features, #export-import-sql-loader-external-tables

10 comments

3,326 views