How to fix the Oracle error ORA-29706: incorrect value string for parameter ACTIVE_INSTANCE_COUNT?

In this post, you’ll learn more about the Oracle ErrorORA-29706: incorrect value string for parameter ACTIVE_INSTANCE_COUNT with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

ORA-29706: incorrect value string for parameter ACTIVE_INSTANCE_COUNT

Reason for the Error ORA-29706: incorrect value string for parameter ACTIVE_INSTANCE_COUNT

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.

How to fix the Error ORA-29706: incorrect value string for parameter ACTIVE_INSTANCE_COUNT ?

You can fix this error in Oracle by following the below steps

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.