Oracle11g RAC 修改scanip

venux

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

1. 
   
2. LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 15-AUG-2024 08:50:46
   
3. 
   
4. Copyright (c) 1991, 2013, Oracle.  All rights reserved.
   
5. 
   
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

复制代码