Then you should consult your DBA. Anyways, i can give you some tips, ok fire this query, in your database,
SELECT COUNT(*) FROM V$PROCESS; This shall give you the number of processes being used. You can check the init.ora file for the number of processes permitted to you, and the maximum number of cursors alloted to you. Your DBA must have done the setting for u. Regards, Vikramjit Singh, Systems Engineer, GTL Ltd. Ph. 7612929-1031 -----Original Message----- From: TEOH KANG YIH [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 03, 2002 7:30 PM To: Tomcat Users List Subject: Re: TomCat 3.2.3 not respond suddenly. Hi Ramjit, Actually there is no more MAXIMUM OPEN CURSORS EXCEEDED error already. Currently we have 3 app servers (in case the main one has problem, the other 2 can be used first), when this problem happens in server A, there is no problem at all at server B and server C to login (meaning to talk to Oracle DB). Note that server B and server C are only standy, nobody will login from that machine unless told. Kindly provide further advice. Thanks. ----- Original Message ----- From: "Vikramjit Singh" <[EMAIL PROTECTED]> To: "'Tomcat Users List'" <[EMAIL PROTECTED]> Sent: Wednesday, July 03, 2002 2:32 PM Subject: RE: TomCat 3.2.3 not respond suddenly. > check the logs in tomcat, if none, then your MAXIMUM OPEN CURSORS EXCEEDED > error might be there, which causes no furthere interaction with oracle, and > you have to restart the server. This error occurs, if you dont close the > connections, or resultset. You could check that. > > Regards, > Vikramjit Singh, > Systems Engineer, > GTL Ltd. > Ph. 7612929-1031 > > > -----Original Message----- > From: TEOH KANG YIH [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, July 02, 2002 3:53 AM > To: [EMAIL PROTECTED] > Subject: Re: TomCat 3.2.3 not respond suddenly. > > > Hi TomCat user, > > Remember I post this question 1 week ago and there is no feedback from > you all? However, I have found out further information as follows: > > 1. Port 8080 still can be telneted in > 2. Other JSP files still can be accessed > > These 2 important tell us that TomCat is still functioning! Only it > can't talk to Oracle Database, until I restart TomCat. > > In order to refresh you, TomCat 3.2.3 runs on Solaris 8. > > Any idea or experience with this, kindly share with me. > > Thanks. > > > ========== > TEOH, KANG YIH > System Engineer > > Think what you haven't done in the past and plan to do it now. > > GloComp Systems (M) Sdn. Bhd. > Unit 639, Blok A, Kelana Centre Point, > Jalan SS7/19, Kelana Jaya, 47301, > Petaling Jaya, Selangor. > Tel: 03-78808607 > Fax: 03-78808609 > H/P: 012-2252848 > > -- > To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> > For additional commands, e-mail: <mailto:[EMAIL PROTECTED]> > > -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]> -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
