Error ORA-31623 On DataPump Export Via DBScheduler After First Run Was Successful (Doc ID 788301.1)

Last updated on SEPTEMBER 15, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 10.1.0.2 and later
Information in this document applies to any platform.
***Checked for relevance on 14-sep-2017***

Symptoms

When running an export job in DB console, the job will run one time successfully but the subsequent runs will fail with errors:

ERROR: No data pump job named "jobname" exists in the database
ORA-31623: a job is not attached to this session via the specified handle
Execute Failed: ORA-31623: a job is not attached to this session via the
specified handle
ORA-6512: at "SYS.DBMS_DATAPUMP", line 2315
ORA-6512: at "SYS.DBMS_DATAPUMP", line 3157
ORA-6512: at line 27 (DBD ERROR: OCIStmtExecute)


No export log is created.

This procedure is referenced in
<Note 461307.1> - How To Export Database Using DBConsole/OEM In 10G

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms