ORA-610 INTERNAL ERROR CODE, KKJCRE1P: UNABLE TO SPAWN JOBQ
(Doc ID 436509.1)
Last updated on JULY 08, 2021
Applies to:Oracle Database - Enterprise Edition - Version 188.8.131.52 and later
Oracle Database Cloud Schema Service - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Information in this document applies to any platform.
When running a job from the scheduler on a very heavily loaded database you could receive an ora-610 error. The job secondary process creation takes a long time and raises a reported error as a fatal error in the background process.
The resulting trace file will have this information listed in it:
New process timed out
error 610 in job queue process
ORA-00610: Internal error code
Died during process startup with error 447 (seq=109)
OPIRIP: Uncaught error 447. Error stack:
ORA-00447: fatal error in background process
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