WARNING: inbound connection timed out (ORA-3136)
来源:互联网 发布:云计算生态系统峰会 编辑:程序博客网 时间:2024/05/03 09:58
$sqlplus devcrm/adsfee@crmSQL*Plus: Release 11.2.0.3.0 Production on Mon Jul 14 09:40:58 2014Copyright (c) 1982, 2011, Oracle. All rights reserved.ERROR:ORA-01017: invalid username/password; logon deniedEnter user-name: Keep the sqlplus session open for 60 seconds and in the alert log after 60th second , you will notice ORA-3136(保持SQL*Plus打开状态,1分钟后,再次查看alert.log文件,将会注意到有ora-3136错误)Mon Jul 14 09:41:58 2014***********************************************************************Fatal NI connect error 12170. VERSION INFORMATION: TNS for IBM/AIX RISC System/6000: Version 11.2.0.3.0 - Production TCP/IP NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 - Production Oracle Bequeath NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 - Production Time: 14-JUL-2014 09:41:58 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=129.100.253.79)(PORT=51588))WARNING: inbound connection timed out (ORA-3136)LSNRCTL> show inbound_connect_timeoutConnecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))LISTENER parameter "inbound_connect_timeout" set to 60The command completed successfullyLSNRCTL> helpThe following operations are availableAn asterisk (*) denotes a modifier or extended command:start stop status services version reload save_config trace spawn change_password quit exit set* show* LSNRCTL> showThe following operations are available after showAn 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 enable_global_dynamic_endpoint oracle_home pid connection_rate_limit LSNRCTL> set inbound_connect_timeout 0Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))LISTENER parameter "inbound_connect_timeout" set to 0The command completed successfullyLSNRCTL> show inbound_connect_timeoutConnecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))LISTENER parameter "inbound_connect_timeout" set to 0The command completed successfullyLSNRCTL> set save_config_on_stop on #表示修改参数永久生效,否则只是临时生效,下次重启监听又还原为原来的值了LSNRCTL> exitor修改listener.ora文件,加入: INBOUND_CONNECT_TIMEOUT_LISTENER_NAME=0
0 0
- WARNING: inbound connection timed out (ORA-3136)
- WARNING: inbound connection timed out (ORA-3136)
- WARNING: inbound connection timed out (ORA-3136)
- WARNING: inbound connection timed out (ORA-3136)
- WARNING: inbound connection timed out (ORA-3136)
- WARNING:inbound connection timed out (ORA-3136)
- 【ORA-3136】WARNING: inbound connection timed out (ORA-3136)
- 【ORA-3136】WARNING: inbound connection timed out (ORA-3136)
- WARNING: inbound connection timed out (ORA-3136) 解决方法
- ORA-3136(WARNING Inbound Connection Timed Out)分析
- WARNING: inbound connection timed out (ORA-3136)连接超时问题
- WARNING: inbound connection timed out (ORA-3136)连接超时
- troubleshooting inbound connection timed out (ORA-3136)
- inbound connection timed out (ORA-3136)
- inbound connection timed out (ORA-3136)
- ORA-3136错误分析——WARNING Inbound Connection Timed Out
- Troubleshooting Guide ORA-3136: WARNING Inbound Connection Timed Out (文档 ID 465043.1)
- Troubleshooting Guide ORA-3136: WARNING Inbound Connection Timed Out (文档 ID 465043.1)
- Princeton Algorithms: Part 1 [week 5: Balanced Search Trees]
- Java提高篇(三二)-----List总结
- Eclipse构建maven项目
- poj2524 Ubiquitous Religions 并查集入门
- 获取全路径文件名的文件名/文件位置/文件的后缀名/文件的前缀
- WARNING: inbound connection timed out (ORA-3136)
- POJ1159
- 客户端跳转与服务器端跳转
- 反渗透技术工艺特点与工作原理
- Swift初见
- 谁偷走了我的效率?
- redis 管道及存储的优化
- TWaver版3D化学元素周期表
- MySQl 日期及格式化