Hi all, I want create a service that relocate the session to node2 if I shutdown node1 and viceversa.
My configuration is:
Oracle 19 with 1 CDB (CDB1) and 3 PDB (PDBMW,PDBBI2,PDBSC) on Rac 2 nodes ( ora1ng, ora2ng)
When I run a query on node1 and after i shutdown (or kill pmon process) the instance 1 the query fails and not is realocate by default to instance 2.
For this scope I've create this service:
srvctl add service -db CDB1 -service CDB1SRV -preferred CDB11,CDB12 -tafpolicy BASIC -failovertype SELECT -failoverretry 3 -failoverdelay 10 -failovermethod BASIC
srvctl start service -db CDB1 -service CDB1SRV
srvctl config service -db CDB1
Service name: CDB1SRV
Server pool:
Cardinality: 2
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: 3
Failover delay: 10
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
Replay Initiation Time: 300 seconds
Drain timeout:
Stop option:
Session State Consistency: DYNAMIC
GSM Flags: 0
Service is enabled
Preferred instances: CDB11,CDB12
Available instances:
CSS critical: no
Service uses Java: false
Now i'm testing the service but when I run
srvctl stop instance -db CDB1 -i CDB11
PRCD-1131 : Failed to stop database CDB1 and its services on nodes ora1ng
PRCR-1133 : Failed to stop database CDB1 and its running services
PRCR-1132 : Failed to stop resources using a filter
CRS-2974: unable to act on resource 'ora.cdb1.db' on server 'ora1ng' because that would require stopping or relocating resource 'ora.cdb1.cdb1srv.svc' but the appropriate force flag was not specified
If i stop the service CDB1SRV it works correct!
What is wrong?
Do i have to create a single service for each pdbs or can I make only a service for cdb and the pdbs?
In oracle 19 is there another method for relocate session automatically?