ORA-27300: OS system dependent operation: CreateThread failed

 

    一个朋友发了一个alert.log日志给我，让我帮忙看看什么问题，数据库可以正常运行，但是后台会有告警。
    平台：windows 
     db version: 10.2.0.4
     alter.log info:
..................
Thread 1 advanced to log sequence 5165 (LGWR switch)
  Current log# 2 seq# 5165 mem# 0: E:\ORACLE\PRODUCT\10.2.0\ORADATA\IMSCMDB1\REDO02.LOG
Sun Jul 05 17:11:09 2009
Process startup failed, error stack:
Sun Jul 05 17:11:10 2009
Errors in file e:\oracle\product\10.2.0\admin\imscmdb1\bdump\imscmdb1_psp0_3668.trc:
ORA-27300: 操作系统系统相关操作: CreateThread 失败, 状态为: 1450
ORA-27301: 操作系统故障消息: 系统资源不足，无法完成请求的服务。
ORA-27302: 错误发生在: ssthrddcr
Sun Jul 05 17:39:36 2009
Process q001 died, see its trace file
Sun Jul 05 17:39:36 2009
ksvcreate: Process(q001) creation failed
Sun Jul 05 17:41:19 2009
Thread 1 advanced to log sequence 5169 (LGWR switch)
  Current log# 3 seq# 5169 mem# 0: E:\ORACLE\PRODUCT\10.2.0\ORADATA\IMSCMDB1\REDO03.LOG
......

  查了很多资料，针对不同的OS平台，不同的数据库版本，有可能出现的原因也各不相同，有的说是oracle的一个bug，但是平台版本跟我不一致，有的说修改OS参数/3G，但是报错的信息与alert中的status参数也不是完全一致。metalink了一把，找到了2个与我碰到的问题很相似的信息：

Symptoms
These errors were encountered and the DB crashed.:
ORA-07445: exception encountered: core dump [ACCESS_VIOLATION] [unable_to_trans_pc]
[PC:0x7C34126B] [ADDR:0x0] [UNABLE_TO_WRITE] []
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.

You may observe this in the trace file.:
"Current SQL information unavailable - no SGA."

Changes
This could be triggered by hardware issues or an increase in volume or by day to day operations.

Cause
Insufficient memory

Solution
Ensure that the existing memory is functioning properly.
If there is no hardware issue, then you have simply run out of available memory and you need to purchase more.
Another option is to decrease the size of the SGA.
Check your OS log for hardware errors.

Purpose
This note helps identify the possible causes of the ORA-2730x errors that have already been reported and provides solution where available.  The errors are usually caused by OS system call error or OS configuration issue and are in the form. of:

ORA-27300: OS system dependent operation:%s failed with status: %s
ORA-27301: OS failure message: %s
ORA-27302: failure occurred at: %s

 

参考文献：
1. Subject:  ora-7445 [ACCESS_VIOLATION] [unable_to_trans_pc] [UNABLE_TO_WRITE] ORA-27301: OS failure message: Not enough storage ORA-27300 ORA-27302
   Doc ID:  466370.1 Type:  PROBLEM
   Modified Date :  27-MAR-2009 Status:  MODERATED

2. Subject:  Troubleshooting ORA-27300 ORA-27301 ORA-27302 errors
   Doc ID:  579365.1 Type:  TROUBLESHOOTING
   Modified Date :  11-FEB-2009 Status:  PUBLISHED

3. http://space.itpub.net/16158219/viewspace-590998

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/9252210/viewspace-609099/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/9252210/viewspace-609099/