Home / server / Questions / 28291
Accepted
katriel
Asked: 2009-06-19 11:17:51 +0800 CST

Oracle RAC: Configure instance to depend on VIP

  • 772

In previous version of Oracle RAC with Oracle clusterware, before 10.0.1 I believe, an instance was dependent on a VIP resource. Once a vip was failed or relocated, the Instance would be stopped. In later versiond, this coupling was broken, as I understand it, by costumer requests.

Since an instance is not a regular resource in the CRS cluster, and can not be configured with crs_profile, how can I create a dependency between an Instance and it's VIP?

oracle10g oracle-rac

1 Answers

  1. Best Answer

    Solved! The trick is to re-register the instance resource. As root:

    crs_stat -p ora.db.instance1.inst > /tmp/ora.db.instance1.inst.cap

    Edit /tmp/ora.db.instance1.inst.cap and add the vip resource to REQUIRED_RESOURCES

    Run:

    crs_register ora.db.instance1.inst -d /tmp -u

    the "-u", I'm guessing is update, does the magic. After that you need to re set permission (or maybe run the whole thing as "oracle" user)

    crs_setperm ora.db.instance1.inst -o oracle
crs_setperm ora.db.instance1.inst -g dba
crs_setperm ora.db.instance1.inst -u pgrp:dba:rwx

    That's it. Run a 

    crs_stat -p crs_stat -p ora.db.instance1.inst

    to make sure the changes have been saved and restart the instance

    This is relevent to 10.2.0.4

    • 2