error between AIX and oracle

[hraa]

i have server p550 , os AIX5.3 and oracle 10g R2 fileset 3
after open database ps (peging space) used 95% and show the error in log file
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

what do i do

 

[khalidaaa]

I'm not a DBA but i think you have problem with your RAM! If your RAM is enough, you would have not been using the paging space!

Regards,
Khalid

 

[unixfreak]

hraa: Please post output of `lsps -a` when starting up

 

[andy61]

The fork failed indicates out of paging space ie there is not enough room to move out memory pages to disk to meet the demands of the starting process. On AIX 5.1, I've found that in these circumstances the kill and the chps command work where other processes fail.

 

[RMGBELGIUM]

the more ram you have for a database server the better, this way you won't have that much swapping, and more performance.

 

[Chapter11]

AIX by default uses a bunch of RAM for disk caching.

If you have nmon installed, you can see these values in the memory panel:

Min/Maxperm 429MB( 15%) 1717MB( 61%) <--% of RAM

Off the top of my head, the defaults are 15% to 75%.

For Oracle servers, I change this via the "vmo" command to 5%-15%.

vmo -o minperm%=5 -o maxperm%=15 -o maxclient%=15 -o strict_maxclient=1

My history here has shown that Oracle servers left at the defaults will eventually cripple the system due to excessive paging. Using the 5%-15% values has always cleared that problem.