Irregular TNS -12535 , did some diagnosis and now need a little guidance
870957Jul 6 2011 — edited Jul 6 2011Hey Guys,
I tried searching and searching for this error, tried a couple of different things but right now I am stuck. I must first say that this forum is very helpful so thank you for everyone who contributes and answers the questions.
Here i go
This is the error message I am randomly getting :
Fatal NI connect error 12170.
VERSION INFORMATION:
TNS for IBM/AIX RISC System/6000: Version 11.2.0.1.0 - Production
TCP/IP NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.1.0 - Production
Oracle Bequeath NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.1.0 - Production
Time: 05-JUL-2011 21:20:09
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: 78
nt OS err code: 0
Client address: (ADDRESS=(PROTOCOL=tcp)(HOST=10.66.6.89)(PORT=1526))
What i have done is on the server machine (database 2) within the listener.ora set INBOUND_CONNECT_TIMEOUT_LISTENER=0
I also setup a sqlnet.ora file within $ORACLE_HOME/network/admin with the parameters
DIAG_ADR_ENABLED =OFF
SQLNET.INBOUND_CONNECT_TIMEOUT=0
in the client machine(database 1) i have the same as above within the listener.ora set INBOUND_CONNECT_TIMEOUT_LISTENER=0
I also setup a sqlnet.ora file within $ORACLE_HOME/network/admin with the parameters
DIAG_ADR_ENABLED =OFF
SQLNET.INBOUND_CONNECT_TIMEOUT=0
Also within the tnsnames.ora files i have put (SERVER=DEDICATED) (just to be on the safe side)
I thought with this there should not be a tns error at all..yet i am getting them daily at random times.
I tried to talk to networking but lets just say I need to proof it somehow that its there issue not mine.
Thanks in advance for your help