Change Vip in 11gR2 RAC_change vip rac-优快云博客

本文链接：https://blog.youkuaiyun.com/JasonLiu_2012/article/details/8688206

本文详细介绍了如何将数据库从现有服务器迁移到11gR2RAC集群，并更改VIP地址的过程。包括停止服务、查找VIP、停止监听器、停止VIP、修改VIP、调整本地监听器参数、更新主机文件、启动VIP和监听器、重新启动服务等步骤。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

最近需要对主库迁移至11gR2 RAC，其原来的IP地址需要在迁移的时候，改成RAC的一个vip。在测试库上测试了一下，在节点postmallrac1把vip从172.24.138.105改成172.24.138.104，大概过程如下：

1、Stop service of current node

postmallrac1# cd /u01/app/grid/product/11.2.0/bin
postmallrac1# ./srvctl status service -d postmall
...... //service name,or nothing
postmallrac1# ./srvctl stop service -d postmall -s <Service_name1,Service_name2> -n postmallrac1

2、Find VIP address

postmallrac1# ./srvctl config vip -n postmallrac1
VIP exists: /postmallrac1-vip/172.24.138.105/172.24.138.0/255.255.255.0/eth0, hosting node postmallrac1

3、Stop Listener of current node

postmallrac1# ./srvctl stop listener -n postmallrac1

4、Stop VIP of current node

postmallrac1# ./srvctl stop vip -n postmallrac1

5、Modify vip

postmallrac1# ./srvctl modify nodeapps -n postmallrac1 -A 172.24.138.104/255.255.255.0/eth0
postmallrac1# ./srvctl config vip -n postmallrac1 //check config

6、modify parameter "local_listener"

grid@postmallrac1:~> sqlplus / as sysasm
SQL> SHOW PARAMETER LOCAL_LIST

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
local_listener                       string      (DESCRIPTION=(ADDRESS_LIST=(AD
                                                 DRESS=(PROTOCOL=TCP)(HOST=172.
                                                 24.138.105)(PORT=1521))))
SQL> alter system set local_listener='(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=172.24.138.104)(PORT=1521))))' scope=both sid='+ASM1';

SQL> SHOW PARAMETER LOCAL_LIST

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
local_listener                       string      (DESCRIPTION=(ADDRESS_LIST=(AD
                                                 DRESS=(PROTOCOL=TCP)(HOST=172.
                                                 24.138.104)(PORT=1521))))

oracle@postmallrac1:~> sqlplus / as sysdba;
SQL> SHOW PARAMETER LOCAL_LIST

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
local_listener                       string      (DESCRIPTION=(ADDRESS_LIST=(AD
                                                 DRESS=(PROTOCOL=TCP)(HOST=172.
                                                 24.138.105)(PORT=1521))))
SQL> alter system set local_listener='(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=172.24.138.104)(PORT=1521))))' scope=both sid='postmall1';

SQL> SHOW PARAMETER LOCAL_LIST

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
local_listener                       string      (DESCRIPTION=(ADDRESS_LIST=(AD
                                                 DRESS=(PROTOCOL=TCP)(HOST=172.
                                                 24.138.104)(PORT=1521))))