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