While examining logs I have found lots of “TNS Operation Timeout Errors” in sqlnet.log file
Fatal NI connect error 12170.
VERSION INFORMATION:
TNS for Linux: Version 10.2.0.4.0 - Production
Oracle Bequeath NT Protocol Adapter for Linux: Version 10.2.0.4.0 - Production
TCP/IP NT Protocol Adapter for Linux: Version 10.2.0.4.0 - Production
Time: 06-MAY-2009 18:54:41
Tracing not turned on.
Tns error struct:
ns main err code: 12535
TNS-12535: TNS:operation timed out
ns secondary err code: 12560
nt main err code: 505
TNS-00505: Operation timed out
nt secondary err code: 110
nt OS err code: 0
Client address: (ADDRESS=(PROTOCOL=tcp)(HOST=*.*.*.*)(PORT=3448))
The same error message was repeating during whole day almost for every application server.
I’ve finally found what was causing the problem. Our database is behind a firewall. Firewall has an “idle session timeout” value. If a connection remains idle for more than the “idle session timeout” value it drops the connections.
Application developers usually configure their connection pools to remain alive for a long time, which is more than the “idle session timeout” value of the firewall. Not all the connections in the pool are used. Some stays idle. After sometime the firewall drops them and I get those operation timed out problems.
Solution:
Add the following line to the sqlnet.ora file on the server.
SQLNET.EXPIRE_TIME=10
In this configuration database will probe the application servers every 10 minutes to see if they are up. In fact this is a mechanism to determine stale connections by database. Because it sends packets to application servers every ten minutes, the connections are detected as active by firewalls and they are not broken.
8 comments:
A great post.
I had the same problem with an Oracle 12.1.0.10 and I have solved adding SQLNET.EXPIRE_TIME = 10 in the last line of file SQLNET.ORA
Thanks!
how to check firewall idle session timeout bcos I have same issue
About odp.net ora-03113
https://community.oracle.com/thread/3870860?start=0&tstart=0
There are some interesting closing dates on this article but I don’t know if I see all of them middle to heart. There may be some validity but I will take maintain opinion till I look into it further. Good article , thanks and we want extra! Added to FeedBurner as well betfair online casino
A VPN secures data involving you and your business enterprise, or you can get anonymity and protection for your own personal details. Get more interesting details about best vpn check out here.
Therefore, if you're on the lookout for an ideal VPN that balances price and performance, NordVPN is the best winner. Want to know more about surfeasy review? Find more information on this website.
Hello,
I am receiving the the same messages in alert after upgrade to 19C.
even i have set SQLNET.EXPIRE_TIME=10 in the sqlnet.ora.
But still getting the messages.
Another option is L2TP. This is another protocol that can be used on either a computer or a router. It works just like the PPTP connection but it does require the use of a network cable and router. If you want to get more interesting details about vpn services, check out this site.
Post a Comment