联系:手机/微信(+86 17813235971) QQ(107644445)
标题:ORA-27300 ORA-27301 ORA-27302
作者:惜分飞©版权所有[未经本人同意,不得以任何形式转载,否则有进一步追究法律责任的权利.]
有朋友库中alert日志报ORA-27300 ORA-27301 ORA-27302错误,让帮忙分析原因
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: 存储空间不足,无法处理此命令。 ORA-27302: failure occurred at: ssthrddcr Fri Oct 28 22:15:34 2016 Process J001 died, see 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: 存储空间不足,无法处理此命令。 ORA-27302: failure occurred at: ssthrddcr Fri Oct 28 22:16:36 2016 Process J001 died, see 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: 存储空间不足,无法处理此命令。 ORA-27302: failure occurred at: ssthrddcr
新会话无法连接
28-10月-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: 监听程序无法分发客户机连接 TNS-12560: TNS: 协议适配器错误 28-10月-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: 监听程序无法分发客户机连接 TNS-12560: TNS: 协议适配器错误 28-10月-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: 监听程序无法分发客户机连接 TNS-12560: TNS: 协议适配器错误 28-10月-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: 监听程序无法分发客户机连接 TNS-12560: TNS: 协议适配器错误 28-10月-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: 监听程序无法分发客户机连接 TNS-12560: TNS: 协议适配器错误 28-10月-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: 监听程序无法分发客户机连接 TNS-12560: TNS: 协议适配器错误 28-10月-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: 监听程序无法分发客户机连接 TNS-12560: TNS: 协议适配器错误 28-10月-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: 监听程序无法分发客户机连接 TNS-12560: TNS: 协议适配器错误
故障处理
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 11 (0xb hexadecimal) through 50 (0x32 hexadecimal).
参考:Ora-27300: OS System Dependent Operation:Createthread Failed With Status: 8 (Doc ID 1310453.1)