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

Last updated on APRIL 18, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.2 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

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms