Oracle RAC 10g - maximum number of session exceeded
Dear experts,
Good morning ,
I need your help please
I have oracle 10g RAC database installed on HP UNIX with 2 nodes
I have the following parameters values :
processes = 600 on node 1 & node 2
sessions = 665 on node 1 & node 2
and always reach the maximum number of sessions
I need to increase the number of sessions to 1000
what is the steps. And how I can confirm that my HP-UNIX server will handle 1000 session on each node
Thank you node1-sessions.png node2-sessions.png
You are going to have to look at the semaphore kernel parameters as well. I didn't see that in the link that was posted. Unless something has changed and Oracle does something special (like it does with memory segments), you are going to need enough semaphores to support 1000 sessions. It is likely the parameters can already handle that, but you need to check.
Ziad Abuqasem
ASKER
Thanks alot experts for your comments
this is the semaphore kernel parameters:
semaem 16384 Default
semmni 4200 4200
semmns 8400 8400
semmnu 4196 (nproc-4)
semmsl 2048 Default Immed
semume 100 Default
semvmx 32767 Default
shlib_debug_enable 0 Default Immed
shmmax 8589934592 8589934592 Immed
shmmni 512 512 Immed
shmseg 300 Default Immed
can you check it.
I dont have experience in kernel parameters.
Also what is the best way to change the parameters
Change processes parameter only or change processes and sessions and transaction all.