Fatal NI Connect Error 12170, 'TNS-12535: TNS:operation timed out'
Posted: Sun Nov 15, 2015 10:21 am
Hi,
After implementing firewalls your Oracle clients may be disconnected due to DCD (Dead Connection Detection) by firewall and killing it after specified duration. To avoid this disconnection add following parameter on your db server in sqlnet.ora,
SQLNET.EXPIRE_TIME=10
Here 10 represents 10 minutes so after each 10 minutes Oracle database will send small packet to client to keep alive the connection. So if idle timeout on firewall is 30 then even if connection is idle the firewall will not kill the connection as after each 10 minutes it will be refreshed.
Once updated you have to reconnect your session as for earlier connections/sessions it will not take effect.
tks
After implementing firewalls your Oracle clients may be disconnected due to DCD (Dead Connection Detection) by firewall and killing it after specified duration. To avoid this disconnection add following parameter on your db server in sqlnet.ora,
SQLNET.EXPIRE_TIME=10
Here 10 represents 10 minutes so after each 10 minutes Oracle database will send small packet to client to keep alive the connection. So if idle timeout on firewall is 30 then even if connection is idle the firewall will not kill the connection as after each 10 minutes it will be refreshed.
Once updated you have to reconnect your session as for earlier connections/sessions it will not take effect.
tks