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

Last updated on JANUARY 09, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.2 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 "grb_stest01" on GRB DB with GRB1 prefer and GRB2 available.
srvctl add service -d GRB -s grb_stest01 -r GRB1 -a GRB2


2) Check service created
srvctl config service -d GRB -a
==>
Service name: grb_stest01
Service is enabled
Server pool: GRB_grb_stest01
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: GRB1
Available instances: GRB2
Service name: grb_test01
Service is enabled
Server pool: GRB_grb_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: GRB1
Available instances:


3) start grb_stest01 service
srvctl start service -d GRB -s grb_stest01

4) confirm the service is srunning on GRB1
srvctl status service -d GRB
==>
Service grb_stest01 is running on instance(s) GRB1

5) Stop instance using srvctl with imemediate(default) or abort
srvctl stop instance -d GRB -i GRB1
OR
srvctl stop instance -d GRB -i GRB1 -o abort

srvctl status service -d GRB
==>
Service grb_stest01 is not running


The service does not failover but stops

Changes

Upgrade to 11.2

Cause

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