Ora-27300: OS System Dependent Operation:Createthread Failed With Status: 8

(Doc ID 1310453.1)

Last updated on DECEMBER 06, 2016

Applies to:

Oracle Database - Standard Edition - Version 10.1.0.2 and later
Oracle Database - Enterprise Edition - Version 10.2.0.4 to 10.2.0.4 [Release 10.2]
Microsoft Windows (32-bit)
Microsoft Windows x64 (64-bit)
**Checked for relevance 27-AUG-2014

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 C:\ORACLE\ADMIN\FPRD\diag\rdbms\fprd\fprd\trace\fprd_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

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms