WARNING: inbound connection timed out (ORA-3136)

最新推荐文章于 2024-11-26 09:15:00 发布

rgb_rgb

最新推荐文章于 2024-11-26 09:15:00 发布

阅读量2k

点赞数

CC 4.0 BY-SA版权

分类专栏： ora

本文链接：https://blog.youkuaiyun.com/rgb_rgb/article/details/37756609

ora 专栏收录该内容

41 篇文章

订阅专栏

本文记录了一次使用SQL*Plus连接Oracle数据库时遇到ORA-01017无效用户名或密码及ORA-3136连接超时错误的问题，并详细介绍了如何通过调整监听器设置来解决这一问题。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

$sqlplus devcrm/adsfee@crm

SQL*Plus: Release 11.2.0.3.0 Production on Mon Jul 14 09:40:58 2014

Copyright (c) 1982, 2011, Oracle.  All rights reserved.

ERROR:
ORA-01017: invalid username/password; logon denied


Enter 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_timeout
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
LISTENER parameter "inbound_connect_timeout" set to 60
The command completed successfully
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               enable_global_dynamic_endpoint     
oracle_home                        pid                                
connection_rate_limit              
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
or
修改listener.ora文件，加入:  INBOUND_CONNECT_TIMEOUT_LISTENER_NAME=0