ITPub博客

首页 > 数据库 > Oracle > ORA-3136

ORA-3136

原创 Oracle 作者:zhulch 时间:2007-01-25 14:40:54 0 删除 编辑
....[@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博客 ” ,链接:https://blog.itpub.net/7318139/viewspace-893540/ ,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论
  • 博文量
    554
  • 访问量
    2318262