ORACLE RAC VIP飘到priv IP上的问题解决

最新推荐文章于 2024-04-09 22:04:57 发布

转载最新推荐文章于 2024-04-09 22:04:57 发布 · 1.6k 阅读

文章标签：

#oracle #resources #database #file #service

Oracle 专栏收录该内容

7 篇文章

订阅专栏

本文记录了一次在配置RAC过程中遇到的问题及解决过程。由于网络接口选择不当导致虚拟IP漂移，通过调整网络设置并手动修改VIP配置文件最终解决了问题。

前几天在安装RAC的时候遇到的问题，完全相同的环境，装了几次了，都没问题，最后一次的时候网卡选的不是ent0，在运行VIPCA的时候，把public（ent9)和private(ent11）俩块网卡都选了，然后有一台机器的vip就老是飘到priv－ip上，郁闷了一晚上。

以后还是规规矩矩的使用ent0做public吧

Make sure there is a recent copy of the OCR file before making any changes:
ocrconfig –showbackup

To fix an incorrect USR_ORA_IF attribute of the VIP resource do as follows:
(1) Log in as root.
(2) set the ORA_CRS_HOME in your environment to the crs home
(2) Recreate a 'cap', file for the vips:
crs_stat -p ora.dbserver1.vip > $ORA_CRS_HOME/crs/profile/ora.dbserver1.vip.cap
crs_stat -p ora.dbserver2.vip > $ORA_CRS_HOME/crs/profile/ora.dbserver2.vip.cap

(3) Stop the vips, this will also require you to stop resources that depending on
them.(database,instance,asm ,service)
crs_stop -f ora.dbserver1.vip
crs_stop -f ora.dbserver2.vip

(4) Edit the profiles(.cap files) manually .. modify the
USR_ORA_IF=ipge0|ipge2
to
USR_ORA_IF=ipge0
(5)Update the OCR records by re-registering the resource with the update
option:
crs_register -u ora.dbserver1.vip
crs_register -u ora.dbserver2.vip

(6) Print the resources to make sure it took ok:
crs_stat -p ora.dbserver1.vip ora.dbserver2.vip

(7) Then start them:
crs_start ora.dbserver1.vip ora.dbserver2.vip