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