URGENT! about - maximum number of sessions exceeded...

[GoSooJJ]

anyone knows why i'm getting this error?
==================
500 Servlet Exception
java.sql.SQLException: ORA-00604: error occurred at recursive SQL level
1
ORA-00018: maximum number of sessions exceeded

==================
i'm getting this error almost every hours...
Please help!!!!

JJ //

 

[rcurva]

It exceeded sessions parameter, the reason could be a spawned session that is not closed at program level. Robbie

"The rule is, not to besiege walled cities if it can possibly be avoided" -- Art of War

 

[lfoata]

You need to increase the value of the SESSIONS parameter in the &quot;init<SID>.ora&quot;, or Increase the value of PROCESSES since SESSIONS is derived off of the PROCESSES parameter.

SESSIONS: derived (1.1 * PROCESSES + 5)

Then bounce the instance.

 

[GoSooJJ]

thx all, i got it now...
lfoata, ur the MAN! ^^
thx again.