Database Error Messages

Release
toggle
  • 23ai
Updated
Jun 24, 2024

ORA-59111

instance id(s) string have different set of Oracle RAC Two-Stage Rolling Update than current instance or joined cluster while enable was in progress

Cause

The set of Oracle RAC Two-Stage Rolling Updates were different on instances that were part of this cluster.

Another reason for this error could be that instance id mentioned in error joined the cluster while enable was in progress.

This could 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 new instance joining the cluster while enable was in progress, retry enable command.

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

Check alert log for more detail about error.