topic Oracle 9i Standby mode problem in Operating System - HP-UX

Oracle 9i Standby mode problem

George Nikoloudis_1 — Fri, 05 Mar 2004 09:30:10 GMT

hi,

I am running Oracle 9i Stand by on an L CLass server and I am getting the below:

SQL> alter database recover managed standby database disconnect;
alter database recover managed standby database disconnect
*
ERROR at line 1:
ORA-00443: background process "MRP0" did not start
ORA-27300: OS system dependent operation:fork failed with status: 12
ORA-27301: OS failure message: Not enough space
ORA-27302: failure occurred at: skgpspawn3

Any suggestions?

Re: Oracle 9i Standby mode problem

Steven E. Protter — Fri, 05 Mar 2004 09:40:44 GMT

When forks fail that indicates inadequate nfiles/nproc in the kernel.

The fastest way to fix this is to alter the kernerl parameter maxusers to a higher figure, make a new kernel an put it in production.

The fast way to do this is sam kernel configurable parameters.

SEP

Re: Oracle 9i Standby mode problem

Jeff Schussele — Fri, 05 Mar 2004 09:44:56 GMT

Hi,

ERR 12 is ENOMEM which indicates the process couldn't allocate memory for some reason.
Usually this indicates that it couldn't allocate swap reservation space. So you may need to add more secondary swap.

May also indicate that one of the max?siz kernel parms was trying to be exceeded, but it's probably a swap space issue.

Rgds,
Jeff