Re: TomCat 3.2.3 not respond suddenly.
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]
Re: TomCat 3.2.3 not respond suddenly.
Hi Ralph, Thanks for your reply first. If there is no error message in the logs, I guess it's a deadlock in the database. Reply: The thing that I do not understand is why do you think it could be a deadlock in DB because I just restart TomCat but not Oracle, the TomCat can talk to Oracle (test from login screen where it actually reads table from Oracle)? Can you provide more info about the jsp that hangs ? Reply: When the problem happens, all the pages that will access to Oracle DB can not work, for example the login screen page which read from table in Oracle. However, other JSP pages that do not access Oracle can be executed. Try a kill -QUIT tomcat pid and have a look at the stacktrace to see where the threads are. Reply: I will try it out when it happens again. Have a look at the oracle console (can't remember the name of the management console for oracle, it's too long ago that I used it) to find out which connections and statements are open. Reply: Oracle console - if you are saying Oracle Enterprise Manager, actually it is not implemented. Any other alternative? Thanks. - Original Message - From: Ralph Einfeldt [EMAIL PROTECTED] To: Tomcat Users List [EMAIL PROTECTED] Sent: Tuesday, July 02, 2002 7:08 PM Subject: AW: TomCat 3.2.3 not respond suddenly. If there is no error message in the logs, I guess it's a deadlock in the database. Can you provide more info about the jsp that hangs ? Try a kill -QUIT tomcat pid and have a look at the stacktrace to see where the threads are. Have a look at the oracle console (can't remember the name of the management console for oracle, it's too long ago that I used it) to find out which connections and statements are open. -Ursprüngliche Nachricht- Von: TEOH KANG YIH [mailto:[EMAIL PROTECTED]] Gesendet: Dienstag, 2. Juli 2002 12:53 An: [EMAIL PROTECTED] Betreff: Re: TomCat 3.2.3 not respond suddenly. 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. -- 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]
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]
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
TomCat 3.2.3 stop responding issue.
Hi everybody, I am using TomCat 3.2.3 running on Solaris 8 (with May 2002 108528-14 patch). I found that TomCat will intermittently stop responding where the process ../native_threads/java -Xms32m -Xmx256m -Dtom still exists. The interval is not fixed where it can happen anytime, say once every 2 weeks and once every few days. When this happens, I have to restart TomCat by typing shutdown.sh and type startup.sh again. I have tested with a lot of solutions, as follows: a. using nohup to run startup.sh b. investigate the output of the TomCat and modify necessary code accordingly c. Install recommended patches and patches recommended by patchdiag utility d. Upgrade to JDK 1.3 I will appreciate much if anybody can help on this problem. 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