My Oracle Support Banner

EXPDP Failed with ORA-31623: A Job Is Not Attached To This Session Via The Specified Handle (Doc ID 2731229.1)

Last updated on AUGUST 30, 2023

Applies to:

Oracle Database Cloud Service - Version N/A to N/A [Release 1.0]
Oracle Cloud Infrastructure - Database Service - Version N/A to N/A [Release 1.0]
Information in this document applies to any platform.

Symptoms

+ Datapump Job (Expdp) failed with below error :

 

########## START of the export process #################

EE Edition export started

Export: Release 12.2.0.1.0 - Production on Tue Nov 10 04:00:01 2020

Copyright (c) 1982, 2017, Oracle and/or its affiliates. All rights reserved.

Connected to: Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production

UDE-31623: operation generated ORACLE error 31623
ORA-31623: a job is not attached to this session via the specified handle
ORA-06512: at "SYS.DBMS_DATAPUMP", line 4750
ORA-06512: at "SYS.KUPV$FT_INT", line 1872
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 79
ORA-06512: at "SYS.KUPV$FT_INT", line 1805
ORA-06512: at "SYS.DBMS_DATAPUMP", line 2266
ORA-06512: at "SYS.DBMS_DATAPUMP", line 4498
ORA-06512: at "SYS.DBMS_DATAPUMP", line 6104
ORA-06512: at line 1

 

Changes

+ Golden Gate Extract activity increased and started consuming more memory.

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.