Ora-27300: OS System Dependent Operation:Createthread Failed With Status: 8
(Doc ID 1310453.1)
Last updated on FEBRUARY 02, 2022
Applies to:
Oracle Database Exadata Cloud Machine - Version N/A and laterOracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Oracle Database Cloud Schema Service - Version N/A and later
Microsoft Windows x64 (64-bit)
Microsoft Windows (32-bit)
Symptoms
Running 11.1.0.7 version, Generic RDBMS
When attempting to connect with more than 150 users,
the following error occurs.
ERROR
-----------------------
User connection error ora-12518
Found follwoing error in alert log and user connection was almost 150 sessions.
Wed Mar 02 15:16:35 2011
Process startup failed, error stack:
Errors in file <PATH>\<SID>_psp0_2744.trc:
ORA-27300: OS system dependent operation:CreateThread failed with status: 8
ORA-27301: OS failure message: Not enough storage is available to process this command.
ORA-27302: failure occurred at: ssthrddcr
Due to this issue, no more sessions can be created
Changes
When max number of sessions is more than 150.
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 |