I received the following ORA-27300 error in my alert log:
ORA-27300: OS system dependent operation:spcdr:9261:4200 failed with status: 997
failure message: Overlapped I/O operation is in progress
ORA-27302: failure occurred at: skgpspawn
Process startup failed, error stack:
Errors in file /u01/home/oracle/diag/rdbms/xxxx.trc:
OS system dependent operation: fork failed with status: 11
ORA-27301: OS failure message: Resource temporarily unavailable
ORA-27302: failure occurred at: skgpspawn5
How do I deal with this ORA-27300 error?
To diagnose any error, you first start by using the
oerr utility to display the ORA-27300 error:
ORA-27300: OS system dependent operation: string failed with status:
OS system call error
Contact Oracle Support
I noted that the maximum user process for this server was set to
2047 and when I check the total number of process it is reaching the
OS limit, causing the ORA-27300 error. We need to check the
"processes" Oracle parameter to ensure that it is large enough and
we also need to increase the process limit to fix the ORA-27300
error and here are the commands for each OS:
Increase the nproc in /etc/security/limits.conf file
10: Increase the project.max-lwps value
For HP and
Solaris: Increase the maxuprc
Support advises that there is a bug: BUG 5607984 - ORACLE DOES NOT CLOSE
TCP CONNECTIONS. REMAINS IN CLOSE_WAIT STATE. on Windows 32-bit.
Patch number 5639232 that Oracle Support can provide is supposed to solve the problem for
10.2.0.2.0. This bug is also supposed to be solved in the 10.2.0.3.0 patchset
that is available on the Metalink site.
Get the Complete
Oracle SQL Tuning Information
The landmark book
SQL Tuning The Definitive Reference" is
filled with valuable information on Oracle SQL Tuning.
This book includes scripts and tools to hypercharge Oracle 11g
performance and you can
for 30% off directly from the publisher.