Oracle11g RAC 修改scanip

venux

RAC安裝完成，一切使用都正常，但是在測試修改scanip的時候，IP顯示是切換了，但是啟動listener_scan1之后，查看狀態(tài)總是The listener supports no services，沒有服務(wù)，執(zhí)行alter system register也沒有用，必須兩個節(jié)點重啟crs之后，才能發(fā)現(xiàn)服務(wù)。但是我在網(wǎng)上找的所有資料，好像大家都沒有重啟crs，有沒有人知道這個問題。
節(jié)點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
   

復(fù)制代碼

節(jié)點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
   

復(fù)制代碼

修改IP之后執(zhí)行
#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
    

復(fù)制代碼

重啟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

復(fù)制代碼