7 Replies Latest reply on Jun 4, 2020 10:41 AM by TheLonelyDBA

    Full expdp fails after successful upgrade

    TheLonelyDBA

      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