alert_telecom.log日志文件信息错误信息:
***********************************************************************
Fatal NI connect error 12170.
VERSION INFORMATION:
TNS for Linux: Version 11.2.0.2.0 - Production
Oracle Bequeath NT Protocol Adapter for Linux: Version 11.2.0.2.0 - Production
TCP/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.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
这里重起数据库和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]$ id
uid=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/app
SQLNET.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/app
ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER=ON # line added by Agent
INBOUND_CONNECT_TIMEOUT_LISTENER=0 --新加入的内容。
[grid@x3850 admin]$ lsnrctl
LSNRCTL for Linux: Version 11.2.0.2.0 - Production on 30-5月 -2012 16:36:32
Copyright (c) 1991, 2010, Oracle. All rights reserved.
Welcome to LSNRCTL, type "help" for information.
LSNRCTL> show INBOUND_CONNECT_TIMEOUT
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
LISTENER parameter "inbound_connect_timeout" set to 60 --这里是60。
The command completed successfully
LSNRCTL> reload --重新加载监听器
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
The command completed successfully
LSNRCTL> show INBOUND_CONNECT_TIMEOUT
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
LISTENER parameter "inbound_connect_timeout" set to 0 --现在是0了。
The command completed successfully