数据库alert有错误没有?The database is 10.2.0.3 and the operating system is windows 2003 service pack2.Today morning the alert log has the following entriesORA-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 This might be related to Metalink bug 5999393.On Windows, each session creates a new thread, and by default 1MB is allocated for the session when it connects. How much memory is in the server, and is this the 32 bit or 64 bit version of Windows 2003. The server might be hitting the upper limit for maximum memory per process, which is either 2GB or 3GB depending on the settings in the server's boot.ini.You might find additional error messages in the Windows event log similar to "The server was unable to allocate a work item 2 times in the last 60 seconds." A change to the Windows registry and a reboot will correct the problem reported by this Windows event log entry.I also have similar problem here.But window event view show -Unable to begin another thread.Look like there are resource issue... Server is with 16GB ram. ,Window 2003 Server 32bit.. From: http://forums.oracle.com/forums/thread.jspa?messageID=3578800
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 和操作系统的设置有关的问题
ORA-27301: OS failure message: Not enough storage is available to process this command.
ORA-27302: failure occurred at: ssthrddcr
This might be related to Metalink bug 5999393.On Windows, each session creates a new thread, and by default 1MB is allocated for the session when it connects. How much memory is in the server, and is this the 32 bit or 64 bit version of Windows 2003. The server might be hitting the upper limit for maximum memory per process, which is either 2GB or 3GB depending on the settings in the server's boot.ini.You might find additional error messages in the Windows event log similar to "The server was unable to allocate a work item 2 times in the last 60 seconds." A change to the Windows registry and a reboot will correct the problem reported by this Windows event log entry.I also have similar problem here.But window event view show -Unable to begin another thread.Look like there are resource issue... Server is with 16GB ram. ,Window 2003 Server 32bit..
From: http://forums.oracle.com/forums/thread.jspa?messageID=3578800
ORA-27301: OS failure message: Not enough storage is available to process this command.
ORA-27302: failure occurred at: ssthrddcr 和操作系统的设置有关的问题
先检查下oracle alert日子文件和操作系统日志