This content has been marked as final. Show 7 replies
This error occur when connecting remotely when a firewall terminates the connection.
To diagnose this you need to Check related OS PID is Still exists..
you can increase the value of the sqlnet.ora expire_time parameter in the sqlnet.ora file
or to check for a expire parameter in a SQL*Plus profile
or setting the parameters sqlnet.inbound_connect_timeout and inbound_connect_timeout_listenername to 0 can stop the ORA-03135 error
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 "Advanced"
Edited by: ambrishr24 on Dec 4, 2012 2:47 PM
any changes happened lately
Its looking a bit strange as we don't have any firewalls enabled in the communication path: On App server, Database server, Routers etc...
Is there any chance that we could get this kind of issues in the absence of the firewall even?
be sure that ipchains and iptables are disable:
# service ipchains stop
# service iptables stop
# chkconfig ipchains off
# chkconfig iptables off
Forgotten to mention this. The DB server is AIX one, so no IPtables.
We've disabled all the Firewalls.
Check MOS Note :
ORA-03135 When Connecting to the Database [ID 404724.1]