Database Instance Resources Sequence in "crsctl stat res -t" Output Mismatches With Output of "olsnodes -n" (Doc ID 1580894.1)

Last updated on APRIL 09, 2023

Applies to:

Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Information in this document applies to any platform.

Symptoms

A four node RAC having database created with 4 instances. The DB instance resources are not listed in sequential order. Node number and host name is not matching in CRSCTL output.

$crsctl stat res -t

..
ora.RACDB.db
  1 ONLINE ONLINE RACNode1 Open
  2 ONLINE ONLINE RACNode4 Open
  3 ONLINE ONLINE RACNode2 Open
  4 ONLINE ONLINE RACNode3 Open
...

Output from Metadata:

SQL> select inst_id,instance_number,Instance_name,host_name from gv$instance;

  INST_ID INSTANCE_NUMBER INSTANCE_NAME HOST_NAME
---------- --------------- --------------------------------------------------
  1 1 RACDB1 RACNode1
  4 4 RACDB4 RACNode4
  3 3 RACDB3 RACNode3
  2 2 RACDB2 RACNode2

olsnodes -n -t

RACNode1 1       Unpinned
RACNode2   2       Unpinned
RACNode3   3       Unpinned
RACNode4   4       Unpinned

DBCA Trace:

[AWT-EventQueue-0] [ 2013-06-10 20:13:15.057 EDT ] [ClusterInfo.getClusterNodeMap:992] Number of nodes=4
[AWT-EventQueue-0] [ 2013-06-10 20:13:15.058 EDT ] [ClusterInfo.getClusterNodeMap:1004] i=0 nodeName=RACNode1 nodeNum=1
[AWT-EventQueue-0] [ 2013-06-10 20:13:15.059 EDT ] [ClusterInfo.getClusterNodeMap:1004] i=1 nodeName=RACNode2 nodeNum=2
[AWT-EventQueue-0] [ 2013-06-10 20:13:15.059 EDT ] [ClusterInfo.getClusterNodeMap:1004] i=2 nodeName=RACNode3 nodeNum=3
[AWT-EventQueue-0] [ 2013-06-10 20:13:15.060 EDT ] [ClusterInfo.getClusterNodeMap:1004] i=3 nodeName=RACNode4 nodeNum=4
[AWT-EventQueue-0] [ 2013-06-10 20:13:15.061 EDT ] [StepContext.getInstanceNumbers:3213] firstNodeNum=1
[AWT-EventQueue-0] [ 2013-06-10 20:13:15.061 EDT ] [StepContext.getInstanceNumbers:3236] node=RACNode1 nodeNum=1
[AWT-EventQueue-0] [ 2013-06-10 20:13:15.062 EDT ] [StepContext.getInstanceNumbers:3251] nodeNames[0]=RACNode1 instance number=1
[AWT-EventQueue-0] [ 2013-06-10 20:13:15.062 EDT ] [StepContext.getInstanceNumbers:3236] node=RACNode4 nodeNum=4
[AWT-EventQueue-0] [ 2013-06-10 20:13:15.063 EDT ] [StepContext.getInstanceNumbers:3251] nodeNames[1]=RACNode4 instance number=4
[AWT-EventQueue-0] [ 2013-06-10 20:13:15.063 EDT ] [StepContext.getInstanceNumbers:3236] node=RACNode2 nodeNum=2
[AWT-EventQueue-0] [ 2013-06-10 20:13:15.064 EDT ] [StepContext.getInstanceNumbers:3251] nodeNames[2]=RACNode2 instance number=2
[AWT-EventQueue-0] [ 2013-06-10 20:13:15.064 EDT ] [StepContext.getInstanceNumbers:3236] node=RACNode3 nodeNum=3
[AWT-EventQueue-0] [ 2013-06-10 20:13:15.065 EDT ] [StepContext.getInstanceNumbers:3251] nodeNames[3]=RACNode3 instance number=3
[AWT-EventQueue-0] [ 2013-06-10 20:13:15.065 EDT ] [Host.createOPSConfiguration:1070] Node[0]=RACNode1 ==> got instance with SID = RACDB1
[AWT-EventQueue-0] [ 2013-06-10 20:13:15.066 EDT ] [Host.createOPSConfiguration:1070] Node[1]=RACNode4 ==> got instance with SID = RACDB4
[AWT-EventQueue-0] [ 2013-06-10 20:13:15.066 EDT ] [Host.createOPSConfiguration:1070] Node[2]=RACNode2 ==> got instance with SID = RACDB2
[AWT-EventQueue-0] [ 2013-06-10 20:13:15.067 EDT ] [Host.createOPSConfiguration:1070] Node[3]=RACNode3 ==> got instance with SID = RACDB3
[AWT-EventQueue-0] [ 2013-06-10 20:13:15.067 EDT ] [ClusterDatabaseUtils.<init>:263] RACHA = true

Changes

RAC database created using DBCA.

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

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

Database Instance Resources Sequence in "crsctl stat res -t" Output Mismatches With Output of "olsnodes -n" (Doc ID 1580894.1)

Applies to:

Symptoms

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!