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 =
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?
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 =
From: Kean Jacinta
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
THe OS is Linux AS.
"Reardon, Bruce (CALBBAY)"
From the box that the App server is on, can you
connect via SQLplus?
ie is a connection from that server to the database
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
Also, what OS(s) is involved?
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
On Behalf Of
Sent: Tuesday, 3 February 2004 1:52 PM
I have an web application program in java . The
database used is Oracle 9i, App Server : Apache,
Currently i am not able to login into this
from internet. There is no error log generated by
system. I have check the database and it's up.
seem ok . What else should i do ?
I am suspecting the connection might broken . How
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
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.