My Oracle Support Banner

11gR2 RAC Service Not Failing Over To Other Node When Instance Is Shut Down (Doc ID 1324574.1)

Last updated on FEBRUARY 13, 2019

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.2 and later
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

'srvctl stop instance' brings the instance down but no service fails over to available instance
In pre-11.2, stopping instance through srvctl/sqlplus triggered service failover to available instance


1) Create service called "<RAC>_test01" on <RAC> DB with <SID1> prefer and <SID2> available.
srvctl add service -d <RAC> -s <RAC>_test01 -r <SID1> -a <SID2>


2) Check service created
srvctl config service -d <RAC> -a
==>
Service name: <RAC>_test01
Service is enabled
Server pool: <RAC>_test01
Cardinality: 1
Disconnect: false
Service role: PRIMARY
Management policy: AUTOMATIC
DTP transaction: false
AQ HA notifications: false
Failover type: NONE
Failover method: NONE
TAF failover retries: 0
TAF failover delay: 0
Connection Load Balancing Goal: LONG
Runtime Load Balancing Goal: NONE
TAF policy specification: NONE
Preferred instances: <SID1>
Available instances: <SID2>
Service name: <RAC>_test01
Service is enabled
Server pool: <RAC>_test01
Cardinality: 1
Disconnect: false
Service role: PRIMARY
Management policy: AUTOMATIC
DTP transaction: false
AQ HA notifications: false
Failover type: NONE
Failover method: NONE
TAF failover retries: 0
TAF failover delay: 0
Connection Load Balancing Goal: LONG
Runtime Load Balancing Goal: NONE
TAF policy specification: NONE
Preferred instances: <SID1>
Available instances:


3) start <RAC>_test01 service
srvctl start service -d <RAC> -s <RAC>_test01

4) confirm the service is srunning on <SID1>
srvctl status service -d <RAC>
==>
Service <RAC>_test01 is running on instance(s) <SID1>

5) Stop instance using srvctl with imemediate(default) or abort
srvctl stop instance -d <RAC> -i <SID1>
OR
srvctl stop instance -d <RAC> -i <SID1> -o abort

srvctl status service -d <RAC>
==>
Service <RAC>_test01 is not running


The service does not failover but stops

Changes

Upgrade to 11.2

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
References


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