Unable to take ASCII backup

Products

• CA eHealth

Issue/Introduction

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.