ORA-29707

ORA-29707: inconsistent value string for initialization parameter string with other instances

Example:

SQL> startup

ORA-29707: inconsistent value 2 for initialization parameter cluster_database_in

stances with other instances

SQL>

SQL>

Details:

In the event that you startup a node on a RAC cluster and you receive an ORA-29707 as above 

check "cluster_database" parameter on all nodes in the rac cluster.

SQL> show parameter cluster
 
NAME                                 TYPE        VALUE
------------------------------------ ----------- ----------------------
cluster_database                     boolean     TRUE
cluster_database_instances           integer     2
cluster_interconnects                string

Note: There is no need to set cluster_database_instances

Solution:

Set cluster_database parameter to true on all nodes of the cluster

SQL> alter system set cluster_database=true;