dedicated server issues !
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 :
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 ?..
im not sure but you need to set
shminfo_shmmni equal to or more than the processes in the init parameter file
"There is a difference between knowing the path and walking the path."
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.
Click Here to Expand Forum to Full Width