This content has been marked as final. Show 3 replies
bobthesungeek76036 wrote:Troubleshooting ORA-27300 ORA-27301 ORA-27302 errors [ID 579365.1]
Getting this on an 11.1 database:
<pre>ORA-27300: OS system dependent operation:fork failed with status: 11
ORA-27301: OS failure message: Resource temporarily unavailable
ORA-27302: failure occurred at: skgpspawn3
Tue Jan 29 12:34:56 2013
Process J000 died, see its trace file
kkjcre1p: unable to spawn jobq slave process</pre>
There's absolutely no memory issues with the server. And ulimit -n for the database owner shows 29995. Googling around it seems there was an issue with 10g and TCP waits. This is a Solaris 10 server and my question is would reducing <b>tcp:tcp_keepalive_interval</b> be an appropriate action here? It's at its default of 7.2M at current. I'm at my wits end trying to figure out where the problem is. "processes" parameter is set at 500 in the init file and the DBA assures me that it is a sufficient number for this database.
Status 11 is about the maximum user process on unix box, so that is why i have said increase the maxuprc parameter to a relevant value more than now.
Ok. My confidence level is not very high but I will increase maxuprc in /etc/system and see what happens. Will report back...