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
[oracle@dtupracdbvnp01 BACKUP]$ srvctl stop instance -d TESTDB -i TESTDB1 -failover
ReplyDeletePRCD-1131 : Failed to stop database TESTDB and its services on nodes dtupracdbvnp01
PRCR-1133 : Failed to stop database TESTDB and its running services
PRCR-1132 : Failed to stop resources using a filter
CRS-2974: unable to act on resource 'ora.testdb.db' on server 'dtupracdbvnp01' because that would require stopping or relocating resource 'ora.testdb.testdb_srvc.svc' but the appropriate force flag was not specified