环境:
AIX5.3+Oracle 10g R2
问题:
alert.log
WARNING: inbound connection timed out (ORA-3136)
SQLNET.LOG error
Fatal NI connect error 12637, connecting to:
(LOCAL=NO)
VERSION INFORMATION:
TNS for IBM/AIX RISC System/6000: Version 10.2.0.2.0 - Production
TCP/IP NT Protocol Adapter for IBM/AIX RISC System/6000: Version 10.2.0.
2.0 - Production
Oracle Bequeath NT Protocol Adapter for IBM/AIX RISC System/6000: Versio
n 10.2.0.2.0 - Production
Time: 25-JAN-2007 13:39:03
Tracing not turned on.
Tns error struct:
ns main err code: 12637
TNS-12637: Packet receive failed
ns secondary err code: 12532
nt main err code: 0
nt secondary err code: 0
nt OS err code: 0
解决方法:
1.set INBOUND_CONNECT_TIMEOUT_
2. set SQLNET.INBOUND_CONNECT_TIMEOUT = 0 in sqlnet.ora of server.
3. stop and start both listener and database.
4. Now try to connect to DB and observe the behaviour
来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/7318139/viewspace-893540/ ,如需转载,请注明出处,否则将追究法律责任。