ORA-3136 —— Fatal NI connect error 12170

alert_telecom.log日志文件信息错误信息：

***********************************************************************Fatal NI connect error 12170.  VERSION INFORMATION:TNS for Linux: Version 11.2.0.2.0 - ProductionOracle Bequeath NT Protocol Adapter for Linux: Version 11.2.0.2.0 - ProductionTCP/IP NT Protocol Adapter for Linux: Version 11.2.0.2.0 - Production  Time: 28-5月 -2012 16:50:52  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=10.199.189.10)(PORT=1884))WARNING: inbound connection timed out (ORA-3136)

这是和网络连接相关的一个错误,Metalink上给出了如下的解决方案:

1.set INBOUND_CONNECT_TIMEOUT_<listenername>=0 in listener.ora2. 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

这里重起数据库和Listener我认为是没有必要的,我们reload一下Listner应该就可以了.
参考：http://www.eygle.com/archives/2006/07/sqlnet_inbound_connect_timeout.html
            http://space.itpub.net/90986/viewspace-711664
            http://hi.baidu.com/qdseashore/blog/item/2bf20e7b08cb93eb0bd1872e.html

下面是具体操作：

[grid@x3850 admin]$ iduid=502(grid) gid=501(oinstall) groups=501(oinstall),502(dba),503(asmdba),504(asmadmin)[grid@x3850 admin]$ pwd/opt/app/grid/network/admin[grid@x3850 admin]$ cat sqlnet.ora # sqlnet.ora Network Configuration File: /opt/app/grid/network/admin/sqlnet.ora# Generated by Oracle configuration tools.NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)ADR_BASE = /opt/appSQLNET.INBOUND_CONNECT_TIMEOUT=0      --新加入的内容。[grid@x3850 admin]$ cat listener.ora# listener.ora Network Configuration File: /opt/app/grid/network/admin/listener.ora# Generated by Oracle configuration tools.LISTENER =  (DESCRIPTION_LIST =    (DESCRIPTION =      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))      (ADDRESS = (PROTOCOL = TCP)(HOST = x3850)(PORT = 1521))    )  )ADR_BASE_LISTENER = /opt/appENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER=ON# line added by AgentINBOUND_CONNECT_TIMEOUT_LISTENER=0   --新加入的内容。

[grid@x3850 admin]$ lsnrctlLSNRCTL for Linux: Version 11.2.0.2.0 - Production on 30-5月 -2012 16:36:32Copyright (c) 1991, 2010, Oracle.  All rights reserved.Welcome to LSNRCTL, type "help" for information.LSNRCTL> show INBOUND_CONNECT_TIMEOUTConnecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))LISTENER parameter "inbound_connect_timeout" set to 60  --这里是60。The command completed successfullyLSNRCTL> reload  --重新加载监听器Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))The command completed successfullyLSNRCTL> show INBOUND_CONNECT_TIMEOUTConnecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))LISTENER parameter "inbound_connect_timeout" set to 0  --现在是0了。The command completed successfully