Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i133Eam17339 for ; Mon, 2 Feb 2004 21:14:36 -0600 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id i133EWo17327 for ; Mon, 2 Feb 2004 21:14:34 -0600 Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 010CC394D2D; Mon, 2 Feb 2004 22:10:25 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Mon, 02 Feb 2004 22:09:35 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from mail.riotinto.com.au (mail.riotinto.com.au [57.70.13.254]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 28C99394C45 for ; Mon, 2 Feb 2004 22:09:27 -0500 (EST) Received: from CORESMTP1.ex.riotinto.org ([10.0.3.1]) by mail.riotinto.com.au with Microsoft SMTPSVC(5.0.2195.6713); Tue, 3 Feb 2004 14:15:57 +1100 Received: from 203.3.63.116 by CORESMTP1.ex.riotinto.org (InterScan E-Mail VirusWall NT); Tue, 03 Feb 2004 14:12:14 +1100 Received: from calbrsv026.cal.riotinto.org ([203.4.57.7]) by corehub1.ex.riotinto.org with Microsoft SMTPSVC(5.0.2195.6713); Tue, 3 Feb 2004 14:08:20 +1100 Received: from calbbsv025.cal.riotinto.org ([203.4.82.25]) by calbrsv026.cal.riotinto.org with Microsoft SMTPSVC(5.0.2195.6713); Tue, 3 Feb 2004 13:08:15 +1000 content-class: urn:content-classes:message MIME-Version: 1.0 Content-type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Subject: RE: Urgent -Pls Help -- Connection problem X-MimeOLE: Produced By Microsoft Exchange V6.0.6487.1 Date: Tue, 3 Feb 2004 14:08:15 +1100 Message-ID: X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: Urgent -Pls Help -- Connection problem Thread-Index: AcPqAaW99jvcPM+eTcSHl7YaNZzQXwAADFwQ From: "Reardon, Bruce (CALBBAY)" To: Cc: "Kean Jacinta" X-OriginalArrivalTime: 03 Feb 2004 03:08:15.0969 (UTC) FILETIME=[F77FD510:01C3EA02] X-archive-position: 622 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: Bruce.Reardon@comalco.riotinto.com.au Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l >From the box that the App server is on, can you connect via SQLplus? ie is a connection from that server to the database ok? And from the Internet, can you connect to areas of the app server that = don't require login? ie - is the App server / Internet connection all working ok? Also, what OS(s) is involved? Bruce Reardon NOTICE: This e-mail and any attachments are private and confidential and = may contain legally privileged information. If you are not an = authorised recipient, the copying or distribution of this e-mail and any = attachments is prohibited and you must not read, print or act in = reliance on this e-mail or attachments. This notice should not be = removed. -----Original Message----- From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org]On Behalf Of Kean Jacinta Sent: Tuesday, 3 February 2004 1:52 PM Dear All I have an web application program in java . The database used is Oracle 9i, App Server : Apache , and Tomcat. Currently i am not able to login into this application from internet. There is no error log generated by the system. I have check the database and it's up. Tnping seem ok . What else should i do ? I am suspecting the connection might broken . How can i query sql stametment to check if the connection is still alive. The application use JDBC connection.=20 Pls help me , what other troubleshooting i should do ? Thank in Advanced JKean ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------