However, we don't get the error like "maximum process exceeded".----- Original Message ----- From: "Vikramjit Singh" <[EMAIL PROTECTED]> To: "'Tomcat Users List'" <[EMAIL PROTECTED]> Sent: Thursday, July 04, 2002 12:22 PM Subject: RE: TomCat 3.2.3 not respond suddenly. > > 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]> > > -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
