修改11g rac vip

1、1：停止数据库

[oracle@qidong2 ~]$ srvctl stop database -d orcl

2、2：查看需要更改某一节点的VIP

[oracle@qidong2 ~]$ srvctl config vip -n qidong2

VIP exists: /qidong2vip/173.18.0.10/173.18.0.0/255.255.255.0/em1, hosting node qidong2

3、3：停止监听并查看状态

[oracle@qidong2 ~]$ srvctl stop listener -n qidong2

[oracle@qidong2 ~]$ srvctl status listener -n qidong2

Listener LISTENER is enabled on node(s): qidong2

Listener LISTENER is not running on node(s): qidong2

4、4：停止vip并查看状态

[oracle@qidong2 ~]$ srvctl stop vip -n qidong2

[oracle@qidong2 ~]$ srvctl status vip -n qidong2

VIP qidong2vip is enabled

VIP qidong2vip is not running

5、5：修改各个节点的 /etc/hosts 文件

修改对应的vip的IP

将节点2的vip 173.18.0.10 修改成 173.18.0.12

6、6：修改需要更改某一节点的vip

[oracle@qidong2 ~]$ srvctl modify nodeapps -n qidong2 -A 173.18.0.12/255.255.255.0/em1

[oracle@qidong2 ~]$ srvctl config vip -n qidong2  修改后检测

VIP exists: /qidong2vip/173.18.0.12/173.18.0.0/255.255.255.0/em1, hosting node qidong2

7、7：启动vip

[oracle@qidong2 ~]$ srvctl start vip -n qidong2

[oracle@qidong2 ~]$ srvctl status vip -n qidong2

VIP qidong2vip is enabled

VIP qidong2vip is running on node: qidong2

8、8：启动监听

[oracle@qidong2 ~]$ srvctl start listener -n qidong2

[oracle@qidong2 ~]$ srvctl status listener -n qidong2

Listener LISTENER is enabled on node(s): qidong2

Listener LISTENER is running on node(s): qidong2

9、9：启动数据库

[oracle@qidong2 ~]$ srvctl start database -d orcl

10、10：查看该节点的 local_listener

重启数据库由oraagent自动将vip注册进去

SQL> show parameter local_listener

NAME                                        TYPE        VALUE

------------------------------------ ----------- ------------------------------

local_listener                          string       (ADDRESS=(PROTOCOL=TCP)(HOST=

                                                         173.18.0.12)(PORT=1521))