Operating System - HP-UX
1753834 Members
8130 Online
108806 Solutions
New Discussion юеВ

Re: Problem with number of connections.

 
Jeff Schussele
Honored Contributor

Re: Problem with number of connections.

Hi Pheroz,

Have you checked the /var/adm/syslog/syslog.log file for any error msgs when the "ceiling" is hit?
I'm wondering if you don't have the maxuprc (kernel parm) set high enough & you're topping out on it.
This parm defines how many total processes can be spawned under a single user name - like oracle or whatever your oracle username is.
Oracle's a rabbit & wants to spawn lots of processes. If it's in the triple digits as a value - bump it up to several K at least.

HTH,
Jeff
PERSEVERANCE -- Remember, whatever does not kill you only makes you stronger!
T G Manikandan
Honored Contributor

Re: Problem with number of connections.

Oracle in a shared environment is much different than running Oracle on a dedicated server.
I am not sure whether you are running the database is the shared mode.
Check your $ORACLE_HOME/dbs/init file to check whether you have limited the number of concurrent connections.

Do you have somtthing like
max_sessions
or
#mts_dispatchers

to some specific value.

Thanks
Ru Lou
New Member

Re: Problem with number of connections.

You probably resolved your problem by now. You
may need to rebuild the special device file by issue: insf -d ptys -n 512 (or whatever)
insf -d ptym -n 512
See DOC# KBRC0000945