-
dedicated server issues !
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
-
im not sure but you need to set
shminfo_shmmni equal to or more than the processes in the init parameter file
HTH
Amar
"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.
Reddy,Sam
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|