Solaris + Oracle & multiple db's

[Igaduma]

Hello All,

I have a problem that is doing my head in.
On a V880 server with 8Gb ram there are about 3 running databases.
Each time I want to startup a fourth one, I get an error.

Making the other db's smaller in SGA doesn't seem to have any impact so it must be coming from the /etc/system file, although that seems correct.
The machine reports 3 db's up, top shows me 7.3Gb still free and 700Mb swap in use, with additional 5Gb swap free
Each db is configured with a very small SGA of 128Mb

This is the error I get when I try to start up the fourth db:

ORA-27302: failure occurred at: skgpwreset1
ORA-27303: additional information: invalid shared ctx
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: sskgpcreates

Setting the actual db to 128Mb of SGA in the ini.ora file doesn't seem to change anything.

This is the /etc/system part for oracle:

*Oracle required params
* forceload: misc/ipc
forceload: sys/shmsys
forceload: sys/semsys
* forceload: sys/msgsys
set noexec_user_stack=1
set semsys:seminfo_semmni=100
set semsys:seminfo_semmns=1024
set semsys:seminfo_semmsl=256
set semsys:seminfo_semvmx=32767
set shmsys:shminfo_shmmax=4294967295

I tried upping the shmmax to 7Gb but to no avail, it seems to be another parameter.

Any help here is greatly appriciated!
Iga

 

[Scunningham99]

Hi

We have a v880 with 3 instances running same memory 8gb. Heres what works for us which you could try:-


* Added by SC 15-03-05 8gigRam 4x CPU's
set shmsys:shminfo_shmmax=9663676416
set shmsys:shminfo_shmseg=64
set shmsys:shminfo_shmmin=1
set shmsys:shminfo_shmmni=128
set semsys:seminfo_semmni=1000
set semsys:seminfo_semmsl=2048
set semsys:seminfo_semmns=3584
set semsys:seminfo_semopm=128
set semsys:seminfo_semvmx=32767

hth

Sy UK