Database Error Messages

Release
toggle
  • 23ai
Updated
Jun 24, 2024

OCI-59101

Cluster is not homogeneous.

Cause

Either when ALTER SYSTEM ENABLE RAC TWO_STAGE ROLLING UPDATES is being done, or during startup, it is detected that some instances in the cluster have a different set of Oracle RAC Two-Stage Rolling Updates as compared to other nodes. If Oracle RAC Two-Stage Rolling Updates are enabled, all cluster nodes need to have the same set of Oracle RAC Two-Stage Rolling Updates; otherwise, unexpected behavior can happen.

This can also happen if local spfile or pfile are in use and they are not same across cluster.


Action

Ensure that all nodes in the cluster have the same set of Oracle RAC Two-Stage Rolling Updates. Run the 'ORACLE_HOME/bin/rrputil -l' command on all nodes and confirm that all nodes have the same set of Oracle RAC Two-Stage Rolling Updates.

Optionally, query V$RAC_TWO_STAGE_ROLLING_UPDATES to see what updates are enabled on a node and what updates could be enabled. Updates with ENABLED='Y' are enabled and updates with ENABLED='N' could be enabled in the Oracle binary.

All nodes in the cluster should have the same set of rows with the same value for the BUG_NUMBER and the ENABLED column in V$RAC_TWO_STAGE_ROLLING_UPDATES.

If error was due to local spfile or pfile usage, make sure they have same content across cluster.