Chinaunix

标题: Oracle11g RAC 修改scanip [打印本页]
作者: venux    时间: 2024-08-15 10:02
标题: Oracle11g RAC 修改scanip
本帖最后由 venux 于 2024-08-15 10:03 编辑

RAC安装完成，一切使用都正常，但是在测试修改scanip的时候，IP显示是切换了，但是启动listener_scan1之后，查看状态总是The listener supports no services，没有服务，执行alter system register也没有用，必须两个节点重启crs之后，才能发现服务。但是我在网上找的所有资料，好像大家都没有重启crs，有没有人知道这个问题。
节点1
  1. [root@racdb01 app]#  cat /oracle/app/11.2.0/grid/network/admin/listener.ora
  2. LISTENER_SCAN1=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN1))))                # line added by Agent
  3. LISTENER=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER))))                # line added by Agent
  4. ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER=ON                # line added by Agent
  5. ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER_SCAN1=ON                # line added by Agent
  6. VALID_NODE_CHECKING_REGISTRATION_LISTENER_SCAN1 = OFF
复制代码

节点2
  1. [root@racdb02 app]#  cat /oracle/app/11.2.0/grid/network/admin/listener.ora
  2. LISTENER_SCAN1=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN1))))                # line added by Agent
  3. LISTENER=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER))))                # line added by Agent
  4. ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER=ON                # line added by Agent
  5. ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER_SCAN1=ON                # line added by Agent
  6. VALID_NODE_CHECKING_REGISTRATION_LISTENER_SCAN1 = OFF
复制代码

修改IP之后执行
#lsnrctl status LISTENER_SCAN1
总是提示no services

  2. LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 15-AUG-2024 08:50:46

  4. Copyright (c) 1991, 2013, Oracle.  All rights reserved.

  6. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN1)))
  7. STATUS of the LISTENER
  8. ------------------------
  9. Alias                     LISTENER_SCAN1
  10. Version                   TNSLSNR for Linux: Version 11.2.0.4.0 - Production
  11. Start Date                15-AUG-2024 08:35:29
  12. Uptime                    0 days 0 hr. 15 min. 16 sec
  13. Trace Level               off
  14. Security                  ON: Local OS Authentication
  15. SNMP                      OFF
  16. Listener Parameter File   /oracle/app/11.2.0/grid/network/admin/listener.ora
  17. Listener Log File         /oracle/app/11.2.0/grid/log/diag/tnslsnr/racdb02/listener_scan1/alert/log.xml
  18. Listening Endpoints Summary...
  19.   (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER_SCAN1)))
  20.   (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=正确的IP)(PORT=1521)))
  21. The listener supports no services
  22. The command completed successfully
复制代码
重启2台crs之后
  1. Services Summary...
  2. Service "testdb" has 2 instance(s).
  3.   Instance "testdb1", status READY, has 1 handler(s) for this service...
  4.   Instance "testdb2", status READY, has 1 handler(s) for this service...
  5. Service "testdbXDB" has 2 instance(s).
  6.   Instance "testdb1", status READY, has 1 handler(s) for this service...
  7.   Instance "testdb2", status READY, has 1 handler(s) for this service...
  8. The command completed successfully
复制代码








欢迎光临 Chinaunix (http://bbs.chinaunix.net/) Powered by Discuz! X3.2