2-instances on a 3-node cluster for active/passive using active_instance_count
A product we have purchased requires the following for a RAC environment:
Oracle RAC (Real Application Cluster) is supported in a two-node active-passive configuration. That is, a configuration where the
active_instance_count
parameter is set to 1. Used in conjunction with connection failover for the JDBC
TM
driver, this configuration provides failover capability for the repository.
From Oracle documentation i read the following:
Note:
This parameter functions only in a cluster with only two instances.
ACTIVE_INSTANCE_COUNT enables you to designate one instance in a two-instance cluster as the primary instance and the other instance as the secondary instance. This parameter has no functionality in a cluster with more than two instances.