Oracle Error ORA-29706: incorrect value string for parameter ACTIVE_INSTANCE_COUNT

Oracle Error Message

ORA-29706: incorrect value string for parameter ACTIVE_INSTANCE_COUNT

Reason for the Error

The ACTIVE_INSTANCE_COUNT parameter must be set to 1 in a two node cluster database configuration or unspecified if a secondary instance is not needed.

Solution

Check your initialization parameter files and correct the value of the ACTIVE_INSTANCE_COUNT parameter. If you are configuring a two node primary/secondary cluster database, set this value to 1. Otherwise, do not specify any value for the parameter.