Oracle11.2.0.3 ORA-3136 连接超时错误解决
来源:互联网 发布:mzd定位软件下载 编辑:程序博客网 时间:2024/06/01 21:22
1.问题现象
alert日志文件报如下错误
WARNING: inbound connection timed out (ORA-3136)
Mon Oct 20 14:33:52 2008
WARNING: inbound connection timed out (ORA-3136)
Mon Oct 20 14:34:46 2008
WARNING: inbound connection timed out (ORA-3136)
sqlnet.log中记录了如下错误:
Fatal NI connect error 12170.
VERSION INFORMATION:
TNS for Linux: Version 11.2.0.3.0 - Production
Oracle Bequeath NT Protocol Adapter for Linux: Version 11.2.0.3.0 - Production
TCP/IP NT Protocol Adapter for Linux: Version 11.2.0.3.0 - Production
Time: 20-OCT-2008 14:34:46
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=192.168.123.103)(PORT=3124))
2.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
如果不重启只是进行reload也可以修改成功
通过如下方式验证是否修改成功
LSNRCTL> show inbound_connect_timeout
修改listener的inbound_connect_timeout参数的方法
方法一:
$ lsnrctl
LSNRCTL for IBM/AIX RISC System/6000: Version 11.2.0.3.0 - Production on 29-OCT-2007 10:00:57
Copyright (c) 1991, 2006, Oracle. All rights reserved.
Welcome to LSNRCTL, type "help" for information.
LSNRCTL> help
The following operations are available
An asterisk (*) denotes a modifier or extended command:
start stop status
services version reload
save_config trace spawn
change_password quit exit
set* show*
LSNRCTL> show
The following operations are available after show
An asterisk (*) denotes a modifier or extended command:
rawmode displaymode
rules trc_file
trc_directory trc_level
log_file log_directory
log_status current_listener
inbound_connect_timeout startup_waittime
snmp_visible save_config_on_stop
dynamic_registration
LSNRCTL> show inbound_connect_timeout
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
LISTENER parameter "inbound_connect_timeout" set to 60
The command completed successfully
LSNRCTL> set inbound_connect_timeout 0
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
LISTENER parameter "inbound_connect_timeout" set to 0
The command completed successfully
LSNRCTL> show inbound_connect_timeout
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
LISTENER parameter "inbound_connect_timeout" set to 0
The command completed successfully
LSNRCTL> set save_config_on_stop on #表示修改参数永久生效,否则只是临时生效,下次重启监听又还原为原来的值了
LSNRCTL> exit
方法二:
alert日志文件报如下错误
WARNING: inbound connection timed out (ORA-3136)
Mon Oct 20 14:33:52 2008
WARNING: inbound connection timed out (ORA-3136)
Mon Oct 20 14:34:46 2008
WARNING: inbound connection timed out (ORA-3136)
sqlnet.log中记录了如下错误:
Fatal NI connect error 12170.
VERSION INFORMATION:
TNS for Linux: Version 11.2.0.3.0 - Production
Oracle Bequeath NT Protocol Adapter for Linux: Version 11.2.0.3.0 - Production
TCP/IP NT Protocol Adapter for Linux: Version 11.2.0.3.0 - Production
Time: 20-OCT-2008 14:34:46
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=192.168.123.103)(PORT=3124))
2.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
如果不重启只是进行reload也可以修改成功
通过如下方式验证是否修改成功
LSNRCTL> show inbound_connect_timeout
修改listener的inbound_connect_timeout参数的方法
方法一:
$ lsnrctl
LSNRCTL for IBM/AIX RISC System/6000: Version 11.2.0.3.0 - Production on 29-OCT-2007 10:00:57
Copyright (c) 1991, 2006, Oracle. All rights reserved.
Welcome to LSNRCTL, type "help" for information.
LSNRCTL> help
The following operations are available
An asterisk (*) denotes a modifier or extended command:
start stop status
services version reload
save_config trace spawn
change_password quit exit
set* show*
LSNRCTL> show
The following operations are available after show
An asterisk (*) denotes a modifier or extended command:
rawmode displaymode
rules trc_file
trc_directory trc_level
log_file log_directory
log_status current_listener
inbound_connect_timeout startup_waittime
snmp_visible save_config_on_stop
dynamic_registration
LSNRCTL> show inbound_connect_timeout
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
LISTENER parameter "inbound_connect_timeout" set to 60
The command completed successfully
LSNRCTL> set inbound_connect_timeout 0
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
LISTENER parameter "inbound_connect_timeout" set to 0
The command completed successfully
LSNRCTL> show inbound_connect_timeout
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
LISTENER parameter "inbound_connect_timeout" set to 0
The command completed successfully
LSNRCTL> set save_config_on_stop on #表示修改参数永久生效,否则只是临时生效,下次重启监听又还原为原来的值了
LSNRCTL> exit
方法二:
修改listener.ora文件,加入: INBOUND_CONNECT_TIMEOUT_LISTENER_NAME=0
0 0
- Oracle11.2.0.3 ORA-3136 连接超时错误解决
- 连接Oracle11.2.0.1 提示Ora-12541和Ora-12514错误
- Navicat Premium11.0.7连接Oracle11.2.0.1出现错误,错误代码ORA-28547:
- ORA-12170:TNS:连接超时!错误解决方法
- 客户端连接数据库服务端报ORA-12170,连接超时错误
- ORA-3136 错误解决
- ORA-3136错误解决
- Oracle11.2.0.1.0集群数据库不能正常启动,报ORA-01078,ORA-01565,ORA-17503,ORA-12547错误
- oracle11.2.0.3中ORACLE_OCM用户报错12012和29280错误的解决
- 安装Oracle11.2.0.3的时候都遇到PRCR-1079、?ORA-01031、CRS-5017、CRS-2674错误
- ora-01017 ora-02063 database link,oracle11.2g通过dblink连接oracle11.2g
- MyEclipse连接Oracle错误:ORA-00604和ORA-12705解决
- oracle11.2.0.3.0 - 64bit,数据泵导入报ORA-06502,解决
- Oracle10gR2 ORA-3136 错误解决
- Oracle10gR2 ORA-3136 错误解决
- Oracle10gR2 ORA-3136 错误解决
- ORA-12170 TNS 连接超时
- ORA-12170 TNS 连接超时
- python学习笔记之(五)
- html5移动开发物理游戏的方法心得
- 完全卸载oracle11g步骤
- 没法加载协定为“tt.WeatherWebServiceSoap”的终结点配置部分,因为找到了该协定的多个终结点配置。请按名称指示首选的终结点配置部分
- ListView下拉刷新上拉加载更多实现
- Oracle11.2.0.3 ORA-3136 连接超时错误解决
- 存储过程
- java:屏蔽htpps访问时的ssl验证
- hdu2117 Just a Numble
- [Android问答] 如何理解Activity生命周期?
- 给IIC芯片AT24CXXX编写驱动的过程中出现的一些不稳定的问题总结
- Linux rpm 命令参数使用详解[介绍和应用]
- 使用 FileSystem JAVA API 对 HDFS 进行读、写、删除等操作
- ubuntu12.04中安装jdk不成功问题