Analysis of ORA-27300 ORA-27301 ORA-27302 errors in Oracle

Source: Internet
Author: User

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

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.