首页 > Linux操作系统 > Linux操作系统 > ORA-27300: OS system dependent operation: CreateThread failed

ORA-27300: OS system dependent operation: CreateThread failed

原创 Linux操作系统 作者:zhanglei_itput 时间:2009-07-14 10:50:25 0 删除 编辑


     db version:
     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


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."

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

Insufficient memory

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.

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


来自 “ ITPUB博客 ” ,链接:,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录


  • 博文量
  • 访问量