Having problems starting Oracle DB'S on HPUX. NEED HELP!!!

[David Heard]

ORA-27300: OS System dependent operation: fork failed with status : 22
ORA-27301: OS failure message: Invalid Argument
ORA-27302: failure occurred at: skgpspawn5

[Joseph Loo]

hi,

have you configure your kernel parameters, i.e. IPC Semaphores, IPC Shared Memory, etc?

regards.

[Mark Grant]

Bit odd that one because error 22 agrees with the error message i.e. invalid argument.

Normally fork errors are associated with system limits being exceeded or being out of swap. You could check these but I would wonder why you are getting "invalid argument". Has this installation of oracle been installed from scratch from the right platform?

[David Heard]

yes I have. Just as they are in the Oracle setup manual.

[David Heard]

This Installation was installed from scratch

[Cheryl Griffin]

http://www.orafaq.net/msgboard/server/messages/13394.htm suggests a problem with the nodename.

http://www.orafaq.net/archive/comp.databases.oracle.server/2002/05/11/146822.htm suggests checking your semaphore parameters.

[Robert-Jan Goossens]

Hi David,

http://www5.itrc.hp.com/service/cki/docDisplay.do?docLocale=en_US&docId=200000068402524

PROBLEM: Oracle 8.1.6 on HPUX 11.0, Oracle fails to start with the errors:
ORA-27146: post/wait initialization failed
ORA-27300: OS system dependent operation:semget failed with status: 28
ORA-27301: OS failure message: No space left on device
ORA-27302: failure occurred at: sskgpsemsper

increase SEMMNI and SEMMNS or decrease the value in the init.ora

Robert-Jan

[Tim Sanko]

Gentlemen,

I have seen that particular message with to few maxuprcs. Bump the parameter to say 400 and see what happens.

Tim