Simpler Navigation for Servers and Operating Systems - Please Update Your Bookmarks
Completed: a much simpler Servers and Operating Systems section of the Community. We combined many of the older boards, so you won't have to click through so many levels to get at the information you need. Check the consolidated boards here as many sub-forums are now single boards.
If you have bookmarked forums or discussion boards in Servers and Operating Systems, we suggest you check and update them as needed.
Showing results for 
Search instead for 
Did you mean: 

Oracle 9i Standby mode problem

George Nikoloudis_1
Frequent Advisor

Oracle 9i Standby mode problem


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

Steven E Protter
Owner of ISN Corporation
Jeff Schussele
Honored Contributor

Re: Oracle 9i Standby mode problem


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.

PERSEVERANCE -- Remember, whatever does not kill you only makes you stronger!