Have friends in the Library Alert log report ORA-27300 ORA-27301 ORA-27302 error, let help analyze the reason
ORA-27300 ORA-27301 ORA-27302
Fri Oct 28 22:15:33 2016
Process startup failed, error stack:
Errors in file d:\app\diag\rdbms\xifenfei\xifenfei\trace\xifenfei_psp0_4856.trc:
Ora-27300:os system dependent Operation:createthread failed with Status:8
Ora-27301:os Failure Message: There is not enough storage space to process this command.
Ora-27302:failure occurred AT:SSTHRDDCR
Fri Oct 28 22:15:34 2016
Process J001 died, and its trace file
Kkjcre1p:unable to spawn JOBQ slave process
Errors in file d:\app\diag\rdbms\xifenfei\xifenfei\trace\xifenfei_cjq0_5664.trc:
Fri Oct 28 22:16:35 2016
Process startup failed, error stack:
Errors in file d:\app\diag\rdbms\xifenfei\xifenfei\trace\xifenfei_psp0_4856.trc:
Ora-27300:os system dependent Operation:createthread failed with Status:8
Ora-27301:os Failure Message: There is not enough storage space to process this command.
Ora-27302:failure occurred AT:SSTHRDDCR
Fri Oct 28 22:16:36 2016
Process J001 died, and its trace file
Kkjcre1p:unable to spawn JOBQ slave process
Errors in file d:\app\diag\rdbms\xifenfei\xifenfei\trace\xifenfei_cjq0_5664.trc:
Fri Oct 28 22:17:36 2016
Process startup failed, error stack:
Errors in file d:\app\diag\rdbms\xifenfei\xifenfei\trace\xifenfei_psp0_4856.trc:
Ora-27300:os system dependent Operation:createthread failed with Status:8
Ora-27301:os Failure Message: There is not enough storage space to process this command.
Ora-27302:failure occurred AT:SSTHRDDCR
System version win 2008 32-bit
System State
Database version
Database memory configuration
New session Cannot connect
2 August-October -2016 22:46:59 * (Connect_data= (Sid=xifenfei) (Cid= (program=) (host=__jdbc__) (User=administrator)) * (ADDRESS= (PROTOCOL=TCP) (host=172.16.91.5) (port=54383)) * Establish * Xifenfei * 12518
Tns-12518:tns: The listener was unable to distribute the client connection
TNS-12560:TNS: Protocol Adapter error
2 August-October -2016 22:46:59 * (Connect_data= (Sid=xifenfei) (Cid= (program=) (host=__jdbc__) (User=administrator)) * (ADDRESS= (PROTOCOL=TCP) (host=172.16.91.5) (port=54384)) * Establish * Xifenfei * 12518
Tns-12518:tns: The listener was unable to distribute the client connection
TNS-12560:TNS: Protocol Adapter error
2 August-October -2016 22:46:59 * (Connect_data= (Sid=xifenfei) (Cid= (program=) (host=__jdbc__) (User=administrator)) * (ADDRESS= (PROTOCOL=TCP) (host=172.16.91.5) (port=54385)) * Establish * Xifenfei * 12518
Tns-12518:tns: The listener was unable to distribute the client connection
TNS-12560:TNS: Protocol Adapter error
2 August-October -2016 22:46:59 * (Connect_data= (Sid=xifenfei) (Cid= (program=) (host=__jdbc__) (User=administrator)) * (ADDRESS= (PROTOCOL=TCP) (host=172.16.91.5) (port=54386)) * Establish * Xifenfei * 12518
Tns-12518:tns: The listener was unable to distribute the client connection
TNS-12560:TNS: Protocol Adapter error
2 August-October -2016 22:46:59 * (Connect_data= (Sid=xifenfei) (Cid= (program=) (host=__jdbc__) (User=administrator)) * (ADDRESS= (PROTOCOL=TCP) (host=172.16.91.5) (port=54388)) * Establish * Xifenfei * 12518
Tns-12518:tns: The listener was unable to distribute the client connection
TNS-12560:TNS: Protocol Adapter error
2 August-October -2016 22:46:59 * (Connect_data= (Sid=xifenfei) (Cid= (program=) (host=__jdbc__) (User=administrator)) * (ADDRESS= (PROTOCOL=TCP) (host=172.16.91.5) (port=54389)) * Establish * Xifenfei * 12518
Tns-12518:tns: The listener was unable to distribute the client connection
TNS-12560:TNS: Protocol Adapter error
2 August-October -2016 22:46:59 * (Connect_data= (Sid=xifenfei) (Cid= (program=) (host=__jdbc__) (User=administrator)) * (ADDRESS= (PROTOCOL=TCP) (host=172.16.91.5) (port=54390)) * Establish * Xifenfei * 12518
Tns-12518:tns: The listener was unable to distribute the client connection
TNS-12560:TNS: Protocol Adapter error
2 August-October -2016 22:47:00 * (Connect_data= (Sid=xifenfei) (Cid= (program=) (host=__jdbc__) (User=administrator)) * (ADDRESS= (PROTOCOL=TCP) (host=172.16.91.5) (port=54391)) * Establish * Xifenfei * 12518
Tns-12518:tns: The listener was unable to distribute the client connection
TNS-12560:TNS: Protocol Adapter error
20161028224020
Fault Handling
HKEY_LOCAL_MACHINE System\currentcontrolset\services\lanmanserver\parameters
Value name:irpstacksize
Data Type:dword
The default value of the IRPStackSize parameter is 15. The range is from (0xb hexadecimal) through (0x32 hexadecimal).
Register
Reference: Ora-27300:os System Dependent operation:createthread Failed with Status:8 (Doc ID 1310453.1)
Original from: http://www.xifenfei.com/2016/10/ora-27300-ora-27301-ora-27302.html