I am attempting to connect to my Oracle
database and I get the ORA-03135 error:
ORA-03135: connection lost contact tips
What can I do to avoid the ORA-03135 error?
oerr utility shows this for the ORA-03135 error:
ORA-03135: connection lost contact
Cause: 1) Server unexpectedly terminated or was forced to
or 2) Server timed out the
Action: 1) Check if the server session was
2) Check if the
timeout parameters are set properly in
The ORA-03135 error is common when connecting remotely when a
firewall terminates the connection.
One solution for the ORA-03135 error is to increase the value of
sqlnet.ora expire_time parameter in the sqlnet.ora file or to
check for a
expire parameter in a SQL*Plus profile.
To diagnose the ORA-03135 error, start by checking to see if the
still exists, using the ps –ef|grep syntax.
Check to see if there is a Network Address Translation (NAT)
between the client and server
In Windows, check to see if a Windows firewall is checking for
your local connections:
Windows XP -> Control panel -> security -> Tab
Also, setting the parameters sqlnet.inbound_connect_timeout
and inbound_connect_timeout_listenername to 0 can stop the
Get the Complete
Oracle SQL Tuning Information
The landmark book
SQL Tuning The Definitive Reference" is
filled with valuable information on Oracle SQL Tuning.
This book includes scripts and tools to hypercharge Oracle 11g
performance and you can
for 30% off directly from the publisher.