• rac node1节点侦听地址为127.0.0.1问题


    node1

    node1-> lsnrctl status
    LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 14-NOV-2018 10:26:39
    Copyright (c) 1991, 2011, Oracle.  All rights reserved.
    Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
    STATUS of the LISTENER
    ------------------------
    Alias                     LISTENER
    Version                   TNSLSNR for Linux: Version 11.2.0.3.0 - Production
    Start Date                14-NOV-2018 10:24:40
    Uptime                    0 days 0 hr. 1 min. 58 sec
    Trace Level               off
    Security                  ON: Local OS Authentication
    SNMP                      OFF
    Listener Parameter File   /u01/app/11.2.0/grid/network/admin/listener.ora
    Listener Log File         /u01/app/grid/diag/tnslsnr/node1/listener/alert/log.xml
    Listening Endpoints Summary...
      (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER)))
      (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521)))
      (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.10.11)(PORT=1521)))
    Services Summary...
    Service "devdb" has 1 instance(s).
      Instance "devdb1", status READY, has 1 handler(s) for this service...
    Service "devdbXDB" has 1 instance(s).
      Instance "devdb1", status READY, has 1 handler(s) for this service...
    The command completed successfully
     
     
    node2
    node2-> lsnrctl status
    LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 14-NOV-2018 10:25:29
    Copyright (c) 1991, 2011, Oracle.  All rights reserved.
    Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
    STATUS of the LISTENER
    ------------------------
    Alias                     LISTENER
    Version                   TNSLSNR for Linux: Version 11.2.0.3.0 - Production
    Start Date                14-NOV-2018 10:24:40
    Uptime                    0 days 0 hr. 0 min. 48 sec
    Trace Level               off
    Security                  ON: Local OS Authentication
    SNMP                      OFF
    Listener Parameter File   /u01/app/11.2.0/grid/network/admin/listener.ora
    Listener Log File         /u01/app/grid/diag/tnslsnr/node2/listener/alert/log.xml
    Listening Endpoints Summary...
      (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER)))
      (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.10.20)(PORT=1521)))
      (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.10.21)(PORT=1521)))
    The listener supports no services
    The command completed successfully
     
     
    -----------------------------------------------------
    节点1上通过netca修改为192.168.10.10后,依然为127.0.0.1
     
    检查hosts文件
    发现127.0.0.1指向node1
    [root@node1 ~]# more /etc/hosts
    # Do not remove the following line, or various programs
    # that require network functionality will fail.
    127.0.0.1  node1.localdomain node1 localhost.localdomain localhost
    ::1  localhost6.localdomain6 localhost6
    #node1
    192.168.10.10  node1.localdomain      node1
    192.168.10.11  node1-vip.localdomain      node1-vip
    192.168.20.10  node1-priv.localdomain      node1-priv
    #node2
    192.168.10.20  node2.localdomain      node2
    192.168.10.21  node2-vip.localdomain      node2-vip
    192.168.20.20  node2-priv.localdomain      node2-priv
    #scan-ip
    192.168.10.30  scan-cluster.localdomain scan-cluster
     
    删掉127.0.0.1中node1信息
    reloda lsnrctl
    无效
     
    检查hosts文件
    删除127.0.0.1中node1.localdomain信息
    reload lsnrctl
    无效
     
    因为不了解crs节点lisenter的启动流程,推断需要reload crs节点的lisenter信息
    通过srvctl stop/start lisenter重启
    恢复正常
     
     
  • 相关阅读:
    POJ2454 Jersey Politics
    Codeforces 798D
    BZOJ4556 HEOI2016 字符串
    BZOJ1009 [HNOI2008]GT考试
    POJ3693 Maximum repetition substring
    POJ1226 Substrings
    POJ3450 Corporate Identity
    POJ3415 Common Substrings
    CSS Sprites(CSS精灵) 的优缺点
    window.location.replace
  • 原文地址:https://www.cnblogs.com/ggykx/p/9956601.html
Copyright © 2020-2023  润新知