Fatal NI Connect Error 12170, 'TNS-12535: TNS:operation timed out'

In this forum Oracle Applications DBA's, System Administrators & Developers can share their knowledge/issues.
Post Reply
admin
Posts: 2062
Joined: Fri Mar 31, 2006 12:59 am
Location: Pakistan
Contact:

Fatal NI Connect Error 12170, 'TNS-12535: TNS:operation timed out'

Post by admin »

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
Post Reply

Who is online

Users browsing this forum: No registered users and 2 guests