Oracle Database Errors or Warnings from Error ORA-29704 to ORA-29800


ORA-29704: cannot specify ACTIVE_INSTANCE_COUNT in 8.1.5 or earlier release
Cause: 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.
Action: 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.
ORA-29705: ACTIVE_INSTANCE_COUNT is string which is incompatible with the value in other instances
Cause: The value of the ACTIVE_INSTANCE_COUNT parameter must be the same in all Oracle cluster database instances.
Action: Check your initialization parameter files in all instances and ensure that the ACTIVE_INSTANCE_COUNT parameter has the same value. Then restart the instance.
ORA-29706: incorrect value string for parameter ACTIVE_INSTANCE_COUNT
Cause: 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.
Action: 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.

ORA-29707: inconsistent value string for initialization parameter string with other instances
Cause: The value of the initialization parameter in error must be identical on all Oracle cluster database instances and was not.
Action: Check your INIT.ORA files on all instances and ensure that the initialization parameters in error have the same value.
ORA-29740: evicted by member string, group incarnation string
Cause: This member was evicted from the group by another member of the cluster database for one of several reasons, which may include a communications error in the cluster, failure to issue a heartbeat to the control file, etc.
Action: Check the trace files of other active instances in the cluster group for indications of errors that caused a reconfiguration.
ORA-29741: IMR active for some, but not all members of cluster
Cause: The IMR feature is not active for this instance, but is active for another instance in the cluster database.
Action: Ensure that all instances have the same value for the _imr_active init.ora parameter

ORA-29746: Cluster Synchronization Service is being shut down.
Cause: The administrator has shut down the Cluster Synchronization Service daemon. This error message is intended to be informative to users on the status of the service.
Action: Check the log file of the Cluster Synchronization Service daemon to verify the state of the service.
ORA-29760: instance_number parameter not specified
Cause: The init.ora file did not contain a value for the instance_number which is required to identify this instance to other instances of the database running on the same cluster
Action: Assign a value to the instance_number parameter in the init.ora parameter file
ORA-29800: invalid name for operator
Cause: The name specified for the operator is incorrect.
Action: Specify a correct name for the operator.

Above are list of Oracle Database Errors or Warnings from Error ORA-29704 to ORA-29800 received while performing certain operation against Oracle Database or related products.

What are Oracle Database Error Messages?

Oracle Error Messages may be returned while using products which are part of Oracle Database. Each Oracle Database Error or Warning Message mentioned above contains the Warning or Error Message Statement, a short explanation of the probable causes of the Error message, and a recommended action.

Hope this was helpful.

SQLServerF1 Team
Information about Oracle Database Error Messages or Warning Messages on Windows and Linux Operating Systems.


Leave a Reply

Your email address will not be published. Required fields are marked *