How to fix the Oracle error ORA-29704: cannot specify ACTIVE_INSTANCE_COUNT in 8.1.5 or earlier release?

In this post, you’ll learn more about the Oracle ErrorORA-29704: cannot specify ACTIVE_INSTANCE_COUNT in 8.1.5 or earlier release with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

ORA-29704: cannot specify ACTIVE_INSTANCE_COUNT in 8.1.5 or earlier release

Reason for the Error ORA-29704: cannot specify ACTIVE_INSTANCE_COUNT in 8.1.5 or earlier release

The ACTIVE_INSTANCE_COUNT parameter was specified when one of the instances in the cluster was running Oracle 8.1.5 or an earlier release.

How to fix the Error ORA-29704: cannot specify ACTIVE_INSTANCE_COUNT in 8.1.5 or earlier release ?

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

Restart the instance without specifying the ACTIVE_INSTANCE_COUNT parameter. Or, upgrade all instances to Oracle 8.1.6 or later release and then specify the parameter.