oracle10.2.0.4 server issue.

[nyck]

Hello,

I have a Dell R900 running Red Hat 5.4 with oracle10.2.0.4 installed and after a while when trying to start a database we are getting the following error messages appearing in the alert log:-

ORA-27300: OS system dependent operation:fork failed with status: 2
ORA-27301: OS failure message: No such file or directory
ORA-27302: failure occurred at: skgpspawn5
ORA-27303: additional information: skgpspawn5
Fri Apr 23 12:01:45 2010
Process m000 died, see its trace file
Fri Apr 23 12:01:45 2010
ksvcreate: Process(m000) creation failed

Any suggestions on how I resolve this issue?

The server in question as got 128GB Ram

cheers

nick

 

[carp]

Nick -
There is a direct hit on your error messages on support.oracle.com. I will just include the solution part here:

Solution

Increase the maxproc kernel parameter. Start with 1024 or 2048 and adjust as appropriate.

To check the currrent setting:
unix> /usr/sbin/lsattr -E -l sys0 -a maxuproc -F value

To change the value:
1. login as root.

2. use smitty utility
Select 'System Environments'
Select 'Change / Show Characteristics of Operating System'
Maximum number of PROCESSES allowed per user' ---> change to an appropriate value

OR

3. use command line:
chdev -l sys0 -a maxuproc <n>
where:
n is an appropraite value

References
NOTE:392006.1 - Ora-27300 OS system dependent operation:fork failed with status: 11

Please let us know if this works for you.

 

[nyck]

Hello,

The above solution is for AIX, do you have one for Red Hat 5.4 Linux?