oracle 11g RAC环境修改scan vip


环境
grid：11.2.0.4
oracle：11.2.0.4

原值：
192.168.0.58

新值：
192.168.0.158

su - root
cd /ora11g/grid/crs_home/bin

./srvctl config scan

./srvctl stop scan_listener
./srvctl stop scan

./srvctl modify scan -n 192.168.0.158

./srvctl config scan

./srvctl start scan
./srvctl start scan_listener

============================================================================================================

1、修改前查看

grid[test1]/home/grid> ps -ef|grep tns
grid     16638     1  0 08:13 ?        00:00:00 /ora11g/grid/crs_home/bin/tnslsnr LISTENER_SCAN1 -inherit
grid     22148  5060  0 09:05 pts/2    00:00:00 grep tns
grid[test1]/home/grid> 
grid[test1]/home/grid> lsnrctl status LISTENER_SCAN1

LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 03-MAR-2015 09:06:06

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN1)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER_SCAN1
Version                   TNSLSNR for Linux: Version 11.2.0.4.0 - Production
Start Date                03-MAR-2015 08:13:34
Uptime                    0 days 0 hr. 52 min. 31 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /ora11g/grid/crs_home/network/admin/listener.ora
Listener Log File         /ora11g/grid/crs_home/log/diag/tnslsnr/test1/listener_scan1/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER_SCAN1)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.58)(PORT=1521)))
The listener supports no services
The command completed successfully
grid[test1]/home/grid> 

2、编辑每个节点的/etc/hosts，将scan vip修改为新值。

3、修改ocr中的scan vip

[root@test1 bin]# pwd
/ora11g/grid/crs_home/bin
[root@test1 bin]# 
[root@test1 bin]# ./srvctl config scan
SCAN name: racscan, Network: 1/192.168.0.0/255.255.255.0/eth0
SCAN VIP name: scan1, IP: /racscan/192.168.0.58
[root@test1 bin]# 
[root@test1 bin]# ./srvctl stop scan_listener
[root@test1 bin]# 
[root@test1 bin]# ./srvctl stop scan
[root@test1 bin]# 
[root@test1 bin]# ./srvctl modify scan -n 192.168.0.158
[root@test1 bin]# 
[root@test1 bin]# ./srvctl config scan
SCAN name: 192.168.0.158, Network: 1/192.168.0.0/255.255.255.0/eth0
SCAN VIP name: scan1, IP: /192.168.0.158/192.168.0.158
[root@test1 bin]# 
[root@test1 bin]# ./srvctl start scan
[root@test1 bin]# 
[root@test1 bin]# ./srvctl start scan_listener
[root@test1 bin]# 

4、修改后查看

grid[test1]/home/grid> ps -ef|grep tns
grid     23777     1  0 09:19 ?        00:00:00 /ora11g/grid/crs_home/bin/tnslsnr LISTENER_SCAN1 -inherit
root     23794  4987  0 09:20 pts/1    00:00:00 grep tns
grid[test1]/home/grid> 
grid[test1]/home/grid> lsnrctl status LISTENER_SCAN1

LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 03-MAR-2015 09:20:45

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN1)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER_SCAN1
Version                   TNSLSNR for Linux: Version 11.2.0.4.0 - Production
Start Date                03-MAR-2015 09:19:54
Uptime                    0 days 0 hr. 0 min. 50 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /ora11g/grid/crs_home/network/admin/listener.ora
Listener Log File         /ora11g/grid/crs_home/log/diag/tnslsnr/test1/listener_scan1/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER_SCAN1)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.158)(PORT=1521)))
The listener supports no services
The command completed successfully
grid[test1]/home/grid>