This content has been marked as final. Show 11 replies
user8039531 wrote:When was last time SQL*Net worked without any error?
I have Oracle DB 11.2 ON Linux Suse: In my alert log, I can see:
Fatal NI connect error 12170.
TNS for Linux: Version 220.127.116.11.0 - Production
Oracle Bequeath NT Protocol Adapter for Linux: Version 18.104.22.168.0 - Production
TCP/IP NT Protocol Adapter for Linux: Version 22.214.171.124.0 - Production
Time: 21-AUG-2012 11:19:28
Tracing not turned on.
Tns error struct:
ns main err code: 12535
TNS-12535: TNS:operation timed out
ns secondary err code: 12606
nt main err code: 0
nt secondary err code: 0
nt OS err code: 0
Client address: (ADDRESS=(PROTOCOL=tcp)(HOST=126.96.36.199)(PORT=61658))
WARNING: inbound connection timed out (ORA-3136)
what changed since then?
a common cause for timeout is FireWall on or between client & DB Server.
1 Errors can be looked up in the online documentation PRIOR to asking a question.
You just used copy and paste without doing any analysis, this is a violation of Forums Etiquette which recommends to consult documentation first
2 Using hardcoded IP addresses is a big no no, as it will make your 'system' maintenance prone
3 12170 in conjunction with 12535 means one thing: firewall
There are standard solutions for that, they are documented, and I have posted them here many times, so I'm not going to repeat them.
Senior Oracle DBA
I have installed Oracle 11g Release 2 Cluster Database and using DNS for SCAN connectivity. I am unable to connect from 10.2.0.4 client. The connection hangs indefinitely and then times out with the error "ORA-12170: TNS:Connect timeout occurred". Sqlnet.log recorded "Fatal NI connect error 12170".
I have an environment where firewalls are used. As you say, if this is a firewall issue, then how to workaround it?