Unable to take ASCII backup

Document ID : KB000008592
Last Modified Date : 14/02/2018
Show Technical Document Details

ASCII Database backup job is failing with  error  like 'ORA-31626: job does not exist'.

eHealth version: on Linux 5.8

According to Doc ID 2197898, the error like 'ORA-31626: job does not exist', indicates that Data Pump job uses a invalid reference to a job which is no longer executing.

Starting to see Data Pump failures after it has been running fine for a long time may be due to the fact that the data dictionary of this database has an issue.


Login as sqlplus / as sysdba

Run catproc script to fix this issue:

SQL> @?/rdbms/admin/catproc.sql

2.To recompile invalid objects, if any:

SQL> @?/rdbms/admin/utlrp.sql

Try to reproduce the issue.