In a 11gR2 RAC cluster a VIP was showing as INTERMEDIATE and the listener was running fine on both node the actions i took to move the resource back to the correct node
Checking the status
The output from crsctl status resource -t
ora.rac2.vip
1 ONLINE INTERMEDIATE rac1 FAILED OVER
Moving the VIP back to the correct node
[oracle@rac1 ~]$ crsctl status resource ora.rac2.vip
NAME=ora.rac2.vip
TYPE=ora.cluster_vip_net1.type
TARGET=ONLINE
STATE=INTERMEDIATE on rac1
[oracle@rac1 ~]$ crsctl stop resource ora.rac2.vip
CRS-2673: Attempting to stop ‘ora.rac2.vip’ on ‘rac1’
CRS-2677: Stop of ‘ora.rac2.vip’ on ‘rac1’ succeeded
[oracle@rac1 ~]$ crsctl start resource ora.rac2.vip
CRS-2672: Attempting to start ‘ora.rac2.vip’ on ‘rac2’
CRS-2676: Start of ‘ora.rac2.vip’ on ‘rac2’ succeeded
[oracle@rac1 ~]$ crsctl status resource ora.rac2.vip
NAME=ora.rac2.vip
TYPE=ora.cluster_vip_net1.type
TARGET=ONLINE
STATE=ONLINE on rac2
Possible Resource States
The possible resource states from the oracle documentation
State | Description |
---|---|
ONLINE | The resource is running. |
OFFLINE | The resource is not running. |
UNKNOWN | An attempt to stop the resource has failed. Oracle Clusterware does not actively monitor resources that are in this state. You must perform an application-specific action to ensure that the resource is offline, such as stop a process, and then run the crsctl stop resource command to reset the state of the resource to OFFLINE. |
INTERMEDIATE | A resource can be in the INTERMEDIATE state because of one of two events:
Oracle Clusterware actively monitors resources that are in the INTERMEDIATE state and, typically, you are not required to intervene. If the resource is in the INTERMEDIATE state due to the preceding reason 1, then as soon as the state of the resource is established, Oracle Clusterware transitions the resource out of the INTERMEDIATE state. If the resource is in the INTERMEDIATE state due to the preceding reason 2, then it stays in this state if it remains partially online. For example, the home server of the VIP must rejoin the cluster so the VIP can switch over to it. A database administrator must issue a command to open the database instance. In either case, however, Oracle Clusterware transitions the resource out of the INTERMEDIATE state automatically as soon as it is appropriate.Use the |