Avatar of Ziad Abuqasem
Ziad Abuqasem
Flag for Saudi Arabia asked on

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
Oracle DatabaseUnix OS

Avatar of undefined
Last Comment
johnsone

8/22/2022 - Mon
SOLUTION
Alex [***Alex140181***]

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
SOLUTION
slightwv (䄆 Netminder)

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
SOLUTION
Sean Stuber

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.
johnsone

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.
ASKER CERTIFIED SOLUTION
johnsone

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck