Help : Sessions limit

From: Eric Bonnet <erbon_at_gengenp.rug.ac.be>
Date: Wed, 03 Apr 2002 14:37:33 +0200
Message-ID: <3CAAF78D.7FB08232@gengenp.rug.ac.be>

I got a problem with an Oracle 9 database running under Solaris. I can't open more than 110 sessions.
The message is (I simulate connections with a small Java program) :

Exception in thread "main" java.sql.SQLException: ORA-00604: error occurred at recursive SQL level 1
ORA-04031: unable to allocate 8984 bytes of shared memory ("large pool","unknown object","Alloc environm","alloc server hndl")

ORA-06512: at "LBACSYS.LBAC_CACHE", line 517
ORA-06512: at "LBACSYS.LBAC_EVENTS", line 82


-----------------------------------------------------------------------------

init parameters :
processes is set to 500
large_pool_size is set to 2048000

kernel parameters :

shminfo_shmmax=4294967295
shminfo_shmmin=1
shminfo_shmmni=100
shminfo_shmseg=10
seminfo_semmns=2000
seminfo_semmsl=1000
seminfo_semmni=100
seminfo_semopm=100
seminfo_semvmx=32767

Could you help me ?

Thanks in advance,

Eric Received on Wed Apr 03 2002 - 06:37:33 CST