Oracle10g ORA-27300 error

Saturday, October 4, 2008

My Oracle10g (10.2.0.4 Standard Edition) database running on Windows Server 2003 Standard Edition SP2 with 3GB of RAM was intermittently encountering the errors below in the alert.log:

Thu Oct 02 13:06:09 2008
Process startup failed, error stack:
Thu Oct 02 13:06:09 2008
Errors in file i:\oradba\admin\stad101\bdump\stad101_psp0_7268.trc:
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

In addition, a corresponding error was found in the Windows Event Viewer:

Unable to begin another thread.

Searched Google using “unable to begin another thread” and found a discussion on the OTN Discussion Forum mentioning the /3GB switch.

More information on how to set this switch in this Microsoft Technet article.  Some in-depth information about the /3GB switch from Ask the Performance Team.  Amit Bansal provides some insight on AWE at AskDba.org.

The plan right now is to set the OS switch and reboot the server.  We’ll see if this resolves the problem.  My initial thoughts are positive from what I have read and when this error occurs.  I will update this blog entry once I have a more definitive result.

References
DBASupport.com Forum – Calculate Size of PGA

Update (24-Oct-2008)
The Oracle instance has been running for two weeks now since we set the /3GB switch.  We have yet to encounter any errors as previously mentioned.

Advertisements