Expdp failed with ORA-31626, ORA-31650, ORA-1653: unable to extend table SYS.EXP_HEAD$
(Doc ID 2523631.1)
Last updated on AUGUST 30, 2023
Applies to:
Oracle Database Cloud Service - Version N/A to N/A [Release 1.0]Linux x86-64
Symptoms
Expdp job failed with errors:
[oracle@host]$ expdp user@pdb directory=DATAPUMP dumpfile=dumpfile.dmp logfile=logfile.log schemas=schema1 exclude=trigger
Export: Release 12.2.0.1.0 - Production on Thu Mar 28 04:43:54 2019
Copyright (c) 1982, 2017, Oracle and/or its affiliates. All rights reserved.
Password:
Connected to: Oracle Database 12c EE High Perf Release 12.2.0.1.0 - 64bit Production
ORA-31626: job does not exist
ORA-31650: timeout waiting for master process response
Export: Release 12.2.0.1.0 - Production on Thu Mar 28 04:43:54 2019
Copyright (c) 1982, 2017, Oracle and/or its affiliates. All rights reserved.
Password:
Connected to: Oracle Database 12c EE High Perf Release 12.2.0.1.0 - 64bit Production
ORA-31626: job does not exist
ORA-31650: timeout waiting for master process response
When we verify the server, we had enough memory to execute the job.
In alert.log, we can see error ORA-1653 for table SYS.EXP_HEAD$ on SYSAUX tablespace.
ORA-1653: unable to extend table SYS.EXP_HEAD$ by 8192 in tablespace SYSAUX [****]
2019-03-28T04:54:34.325761+00:00
ORA-1653: unable to extend table SYS.EXP_HEAD$ by 8192 in tablespace SYSAUX [****]
2019-03-28T04:54:34.328089+00:00
unable to extend table SYS.EXP_HEAD$ by 8192 in tablespace SYSAUX [****]
2019-03-28T04:54:34.376853+00:00
2019-03-28T04:54:34.325761+00:00
ORA-1653: unable to extend table SYS.EXP_HEAD$ by 8192 in tablespace SYSAUX [****]
2019-03-28T04:54:34.328089+00:00
unable to extend table SYS.EXP_HEAD$ by 8192 in tablespace SYSAUX [****]
2019-03-28T04:54:34.376853+00:00
Changes
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 |