• 监听lsnrctl status查询状态报错linux error 111:connection refused


    报错现象
    今天给客户一个单实例环境配置监听,创建正常,查询状态异常报错
    tns 12541 tns 12560 tns 00511 linux error 111:connection refused
    
    匹配MOS
    Starting TNS Listener or LSNRCTL Start Yields TNS-12541, Linux Error: 111: Connection Refused (文档 ID 343295.1)
    
    >lsnrctl status
    Any of the following listener error stacks might be thrown:
    Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=<hostname>)(PORT=1521)))
    TNS-12541: TNS:no listener
    TNS-12560: TNS:protocol adapter error
    TNS-00511: No listener
    Linux Error: 111: Connection refused
    
    Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))
    TNS-12537: TNS:connection closed
    TNS-12560: TNS:protocol adapter error
    TNS-00507: Connection closed
    
    Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=<hostname>)(PORT=1521))) 
    TNS-12547: TNS:lost contact 
    TNS-12560: TNS:protocol adapter error 
    TNS-00517: Lost contact 
    Linux Error: 104: Connection reset by peer
    
    CHANGES
    This is likely a new installation.
    CAUSE
    1. There is possibly an incorrect IP Address specified for the host in the /etc/hosts file.
    For example:
    192.xxx.yyy.zzz <hostname>.<domain name>
    Whereas the actual ip address for the host "<hostname>.<domain name>" is 192.aaa.bbb.ccc
    2. Also, the localhost reference may be incorrect or missing from the /etc/hosts file.
    3. Oracle may not have read access to /etc/nsswitch.conf file.
    
    SOLUTION
    To implement the solution, please execute the following steps:
    1. Correct the mapping in the /etc/hosts file by adding/correcting the IP address and/or hostname reference for the Unix/Linux Server (both long and short host names).
    For example:
    # Add or edit the /etc/hosts file to include a valid entry for the Server:
    192.aaa.bbb.ccc <hostname>.<domain name> <hostname>
    2. Check that the localhost loopback name and address are correct (both long and short host names).
    An example of a correct localhost entry would be as follows:
    127.0.0.1 localhost.localdomain localhost
    3. Remember to save the /etc/hosts file and then start the listener.
    
    本次是配置/etc/hosts文件时,未注意直接清空/etc/hosts文件导致Localhost信息丢失,最终导致监听程序无法正常运行
    
    4. Check permissions on /etc/nsswitch.conf file to ensure group and other have read access.
    
    - If necessary change permisions on /etc/nsswitch.conf as follows:
    
    chmod 644 /etc/nsswitch.conf
  • 相关阅读:
    算法分析(3)——冒泡排序真的慢吗?
    算法分析(2)——大O和大Θ
    算法分析(1)——数据的影响和函数的增长
    递归的逻辑(5)——米诺斯的迷宫
    递归的逻辑(4)——递归与分形
    李洪强和你一起学习前端之(9)规避脱标,CSS可见性,滑动门案例
    iOS应用管理(优化)
    iOS开发-应用管理
    iOS开发-Tom猫
    iOS 10.3.3 更新背后的故事
  • 原文地址:https://www.cnblogs.com/lvcha001/p/11262327.html
Copyright © 2020-2023  润新知