HPUX 11 - ORA-27300: OS system dependent operation:fork faied with status :11

[Chandrashekhar]

process startup failed, error stack:

ORA-27300: OS system dependent operation:fork faied with status :11

ORA-27301: OS failure message: Resource temporarily unavailable

ORA-27302: failure occured at: skgpspawn5

tail -20 alert_2K.log
ORA-27300: OS system dependent operation:fork failed with status: 11
ORA-27301: OS failure message: Resource temporarily unavailable
ORA-27302: failure occurred at: skgpspawn5
ORA-27303: additional information: skgpspawn5
Tue Feb 16 11:07:47 2010
Process q001 died, see its trace file
Tue Feb 16 11:07:47 2010
ksvcreate: Process(q001) creation failed
Tue Feb 16 11:07:58 2010
Process startup failed, error stack:
Tue Feb 16 11:07:58 2010
Errors in file ...._psp0_22791.trc:
ORA-27300: OS system dependent operation:fork failed with status: 11
ORA-27301: OS failure message: Resource temporarily unavailable
ORA-27302: failure occurred at: skgpspawn5
ORA-27303: additional information: skgpspawn5

P.S. This thread has been moevd from HP-UX > System Administration to HP-UX > databases. - Hp Forum Moderator

[Dennis Handly]

You are most likely out of swap space.  What does this show when you get that error/?

swapinfo -tam

I suppose maxdsiz could be too small too?

[Chandrashekhar]

# swapinfo -tam
Mb Mb Mb PCT START/ Mb
TYPE AVAIL USED FREE USED LIMIT RESERVE PRI NAME
dev 24576 6 24570 0% 0 - 1 /dev/vg00/lvol2
reserve - 24570 -24570
memory 31073 6456 24617 21%
total 55649 31032 24617 56% - 0 -
#

[Dennis Handly]

You have 24 GB free, if you ran this at the same time as the abort.

Assuming 11 is EAGAIN, perhaps you are running into the too many processes limit, kernel parms nproc(5) or maxuprc(5).

[Chandrashekhar]

We already set this parameter last week.

# kctune maxuprc=4090

     ==> Update the automatic 'backup' configuration first? y

       * The automatic 'backup' configuration has been updated.

       * Future operations will update the backup without prompting.

       * The requested changes have been applied to the currently

         running configuration.

Tunable            Value  Expression  Changes

maxuprc  (before)   3686  3686        Immed

         (now)      4090  4090

# kctune -v -q maxuprc

Tunable             maxuprc

Description         Maximum number of processes for each non-root user

Module              pm_proc

Current Value       4090

Value at Next Boot  4090

Value at Last Boot  3686

Default Value       256

Constraints         maxuprc >= 3

                    maxuprc <= nproc - 5

Can Change          Immediately or at Next Boot

[Dennis Handly]

>We already set this parameter last week.

What about nproc(5)?