Saturday, 4 July 2020

CRS-2974: unable to act on resource 'ora.stgracdb.db' on server 'racnode01' because that would require stopping or relocating resource '

Issue: srvctl stop instance command failed with error in 19c release

[oracle@racnode01 ~]$ srvctl stop instance -d stgracdb -i stgracdb011

PRCD-1131 : Failed to stop database stgracdb and its services on nodes racnode01

PRCR-1133 : Failed to stop database stgracdb and its running services

PRCR-1132 : Failed to stop resources using a filter

CRS-2974: unable to act on resource 'ora.stgracdb.db' on server 'racnode01' because that would require stopping or relocating resource 'ora.stgracdb.stgracdb01_prod .svc' but the appropriate force flag was not specified

Lets check service configuration:
[oracle@racnode01 ~] srvctl config  service -d stgracdb -s stgracdb01_prod
Service name: stgracdb01_prod
Server pool: 
Cardinality: 1
Service role: PRIMARY
Management policy: AUTOMATIC
DTP transaction: false
AQ HA notifications: false
Global: false
Commit Outcome: false
Failover type: SELECT
Failover method: BASIC
Failover retries: 
Failover delay: 
Failover restore: NONE
Connection Load Balancing Goal: LONG
Runtime Load Balancing Goal: NONE
TAF policy specification: BASIC
Edition: 
Pluggable database name: 
Hub service: 
Maximum lag time: ANY
SQL Translation Profile: 
Retention: 86400 seconds
Failback :  true  
Replay Initiation Time: 300 seconds
Drain timeout: 
Stop option: 
Session State Consistency: DYNAMIC
GSM Flags: 0
Service is enabled
Preferred instances: stgracdb011
Available instances: stgracdb012
CSS critical: no
Service uses Java: false

Note:Service created with faillback option true and  preferred , available instance
try with failover option in srvctl stop instance, it will gracefully move service to another node and bringdown instance  

db status:
oracle@racnode01 ~]$ srvctl status database -d stgracdb
Instance stgracdb011 is running on node racnode01
Instance stgracdb012 is running on node racnode02

service status:
[oracle@racnode01 ~]$ srvctl status service -d stgracdb
Service stgracdb01_prod  is running on instance(s) stgracdb011

stop instance:
[oracle@racnode01 ~]srvctl stop instance -d stgracdb -i stgracdb011 -failover
  
service moved to node2:
[oracle@racnode02 ~]$  srvctl status service -d stgracdb
Service stgracdb01_prod  is running on instance(s) stgracdb012




No comments:

Post a Comment