dedicated server issues !

[vr76413]

Hello all..

Sun 5.8/ Oracle 9.2

I created a 9.2 database with dedicated server option. I set my processes value to 600 in init.ora file.. This is the only database on this server.

My KErnal Parameters are :

set shmsys:shminfo_shmmax=4294967295
set shmsys:shminfo_shmmin=1
set shmsys:shminfo_shmmni=100
set shmsys:shminfo_shmseg=10

set semsys:seminfo_semmns=3300
set semsys:seminfo_semmni=1700
set semsys:seminfo_semmsl=1700



My developers are still getting error after crossing 150 limit. earlier the 'process' value was default to 150....now when issue show parameter process, it shows 650 since iam using SPFILE.

so what else can i do or make changes to make this work ?...


Dou you think Shared server would have been a better option ?..

Thanks
Ron

[adewri]

im not sure but you need to set

shminfo_shmmni equal to or more than the processes in the init parameter file

HTH

[sreddy]

See are there any locked semaphores using 'ipcs -sb' command (after shutting down the database). Remove them using 'ipcrm' command which will allow to bring required number of semaphores upon startup of instance.

Those commands are solaris specific, not sure other unix flavors equivalent commands.