Re: HP-UX 11 - ORA-27300: OS system dependent operation:fork failed with status :11 (669 Views)
Reply
Occasional Contributor
Chandrashekhar
Posts: 6
Registered: ‎08-23-2005
Message 1 of 6 (721 Views)

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

[ Edited ]

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

Acclaimed Contributor
Dennis Handly
Posts: 25,072
Registered: ‎03-06-2006
Message 2 of 6 (713 Views)

Re: HP-UX 11 - ORA-27300: OS system dependent operation:fork failed with status :11

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?

Occasional Contributor
Chandrashekhar
Posts: 6
Registered: ‎08-23-2005
Message 3 of 6 (703 Views)

Re: HP-UX 11 - ORA-27300: OS system dependent operation:fork failed with status :11

# 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 -
#
Acclaimed Contributor
Dennis Handly
Posts: 25,072
Registered: ‎03-06-2006
Message 4 of 6 (680 Views)

Re: HP-UX 11 - ORA-27300: OS system dependent operation:fork failed with status :11

[ Edited ]

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).

Occasional Contributor
Chandrashekhar
Posts: 6
Registered: ‎08-23-2005
Message 5 of 6 (675 Views)

Re: HP-UX 11 - ORA-27300: OS system dependent operation:fork failed with status :11

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

 

Acclaimed Contributor
Dennis Handly
Posts: 25,072
Registered: ‎03-06-2006
Message 6 of 6 (669 Views)

Re: HP-UX 11 - ORA-27300: OS system dependent operation:fork failed with status :11

>We already set this parameter last week.

 

What about nproc(5)?

The opinions expressed above are the personal opinions of the authors, not of HP. By using this site, you accept the Terms of Use and Rules of Participation.