ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

Unable to take ASCII backup

book

Article ID: 8592

calendar_today

Updated On:

Products

CA eHealth

Issue/Introduction

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

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.

Environment

eHealth version: 6.3.1.06 on Linux 5.8

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.