Unable to take ASCII backup

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

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

Environment:
eHealth version: 6.3.1.06 on Linux 5.8
Cause:

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.

Resolution:

Login as sqlplus / as sysdba


Run catproc script to fix this issue:

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

2.To recompile invalid objects, if any:

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


Try to reproduce the issue.