My Oracle Support Banner

CLUSTER_DATABASE_INSTANCES Parameter Mismatch When Manually Adding A New Instance (Doc ID 420780.1)

Last updated on MARCH 07, 2019

Applies to:

Oracle Database - Enterprise Edition - Version 10.1.0.2 to 10.2.0.1 [Release 10.1 to 10.2]
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.

Symptoms

Oracle recommends that the Database Configuration Assistant (DBCA) is used to add additional instances to existing RAC databases.  However, there may be times when an instance will be added manually.  In those cases, it is necessary to take the value for the CLUSTER_DATABASE_INSTANCES parameter into account.  Failing to do so will result in failure to mount the new instance and the occurrence of the following error in that instance's alert.log:

lmon registered with NM - instance id 6 (internal mem no 5)
Warning: cluster_database_instances (5) of node 0 is <= my node id (5)
cluster_database_instances parameter mismatch!
Instance 0 = 5, mine = 6
This instance has not mounted yet. Exiting!

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
 Scalability RAC Community
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.