RE: Urgent -Pls Help -- Connection problem

Kean,
Some more thoughts if not yet fixed:
Are there any errors in the listener log? Any thing in alert log or udump dirs?
Does the logon make it to the database but logon is failing? eg can you turn on auditing for successful and unsuccessful database = logins?
What if you turn on SQL Net tracing on the middle tier and check the = sqlnet trace logs?

If it's fixed, can you please let us know what the problem was?

HTH,
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: Kean Jacinta [mailto:jacintakean_at_yahoo.com] Sent: Tuesday, 3 February 2004 2:34 PM
To: Reardon, Bruce (CALBBAY)
Subject: RE: Urgent -Pls Help -- Connection problem

Yes i can sqlplus. The internet connection is fine, To access the application , i have to key in username and passwrd. There is no area to access the application without userlogin.=20

THe OS is Linux AS.

• "Reardon, Bruce (CALBBAY)" wrote:
  > 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?
  >=20
  > 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?
  >=20
  > Bruce Reardon
  >=20
  > 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.
  >=20 >=20
  > -----Original Message-----
  > From: oracle-l-bounce_at_freelists.org
  > [mailto:oracle-l-bounce_at_freelists.org]On Behalf Of
  > Kean Jacinta
  > Sent: Tuesday, 3 February 2004 1:52 PM
  >=20
  > Dear All
  >=20
  > I have an web application program in java . The
  > database used is Oracle 9i, App Server : Apache ,
  > and
  > Tomcat.
  >=20
  > 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 ?
  >=20
  > 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
  >=20
  > Pls help me , what other troubleshooting i should do
  > ?
  >=20
  > Thank in Advanced
  >=20
  > JKean
  

  ---

  Please see the official ORACLE-L FAQ: http://www.orafaq.com

  ---

  To unsubscribe send email to: oracle-l-request_at_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

  ---