ORA-00445 Is Reported While Waiting Too Long To Spawn A Process
(Doc ID 1382349.1)
Last updated on MARCH 08, 2023
Applies to:
Oracle Database - Enterprise Edition - Version 9.2.0.1 to 11.2.0.3 [Release 9.2 to 11.2]Oracle Database - Enterprise Edition - Version 12.1.0.2 to 12.1.0.2 [Release 12.1]
Oracle Database - Enterprise Edition - Version 11.2.0.4 to 11.2.0.4 [Release 11.2]
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
Information in this document applies to any platform.
Goal
There are intermittent problems while opening new connections to database. At the problem time frame, alert log file shows the following error message:
...
ORA-00445: background process "J000" did not start after 120 seconds
...
kkjcre1p: unable to spawn jobq secondary process
...
Fatal NI connect error 12537, connecting to:
(LOCAL=NO)
...
TNS-12537: TNS:connection closed
...
kkjcre1p: unable to spawn jobq secondary process
...
Fatal NI connect error 12537, connecting to:
(LOCAL=NO)
...
TNS-12537: TNS:connection closed
...
What does ORA-445 error message mean? and how to investigate it?
Solution
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
| Goal |
| Solution |
| References |