My Oracle Support Banner

How to Specify Instance Name for Each Node for Policy-Managed Databases (Doc ID 2248489.1)

Last updated on FEBRUARY 11, 2019

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.2 and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Information in this document applies to any platform.

Goal

When using Policy-Managed databases in RAC, the database instances can be located on different nodes and named in a way which may not be following the node number. This means that on a 4-node cluster we could have the instances located as:

$ srvctl status db -d ORCL
Instance ORCL_1 is running on node node4
Instance ORCL_2 is running on node node2
Instance ORCL_3 is running on node node3
Instance ORCL_4 is running on node node1

Note that instance 1 is not running on node 1, but on node 4, how to specify the instance-node mapping?

Solution

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
Goal
Solution
References


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