ORA-3136

....[@more@]

环境:

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_ =0 in listener.ora
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博客 ” ，链接：http://blog.itpub.net/7318139/viewspace-893540/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/7318139/viewspace-893540/