Operating System - HP-UX
1748252 Members
3839 Online
108760 Solutions
New Discussion юеВ

Oracle 9i Standby mode problem

 
George Nikoloudis_1
Frequent Advisor

Oracle 9i Standby mode problem

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?
2 REPLIES 2
Steven E. Protter
Exalted Contributor

Re: Oracle 9i Standby mode problem

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
Steven E Protter
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
Jeff Schussele
Honored Contributor

Re: Oracle 9i Standby mode problem

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
PERSEVERANCE -- Remember, whatever does not kill you only makes you stronger!