VIP showing INTERMEDIATE

Posted: February 28, 2013 in RAC

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:

  1. Oracle Clusterware cannot determine the state of the resource but the resource was either attempting to go online or was online the last time its state was precisely known. Usually, the resource transitions out of this state on its own over time, as the conditions that impeded the check action no longer apply.
  2. A resource is partially online. For example, the Oracle Database VIP resource fails over to another server when its home server leaves the cluster. However, applications cannot use this VIP to access the database while it is on a non-home server. Similarly, when an Oracle Database instance is started and not open, the resource is partially online: it is running but is not available to provide services.

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 STATE_DETAILS resource attribute to explain the reason for a resource being in the INTERMEDIATE state and provide a solution to transition the resource out of this state.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

w

Connecting to %s