DB/GI version: 19.21
OS: Oracle Linux 8.9
app_jumbo_2 service mentioned below runs only on once instance at a time.
So, this service is classified as a 'Singleton' service too. Right ? If not, what type of service is this ?
Please have a look at my failed attempt at the bottom too where the only difference is ; I used the flag -cardinality singleton
ps: I couldn't find a dedicated RAC (Real Application clusters) community/forum and hence posted here. And there is no tag like RAC or Real Application Clusters to add. Oracle Corporation has forgotten its roots
$ srvctl add service -db CDB_38P -service app_jumbo_2 -pdb P_SALES_P -preferred db38p2 -available db38p1 -failover_restore AUTO -failoverretry 1 -failoverdelay 3 -commit_outcome TRUE -failovertype AUTO -replay_init_time 600 -retention 86400 -notification TRUE -drain_timeout 300 -stopoption IMMEDIATE -l primary
$
$
$ srvctl config service -db CDB_38P -service app_jumbo_2
Service name: app_jumbo_2
Server pool:
Cardinality: 1
Service role: PRIMARY
Management policy: AUTOMATIC
DTP transaction: false
AQ HA notifications: true
Global: false
Commit Outcome: true
Failover type: AUTO
Failover method:
Failover retries: 1
Failover delay: 3
Failover restore: AUTO
Connection Load Balancing Goal: LONG
Runtime Load Balancing Goal: NONE
TAF policy specification: NONE
Edition:
Pluggable database name: P_SALES_P
Hub service:
Maximum lag time: ANY
SQL Translation Profile:
Retention: 86400 seconds
Replay Initiation Time: 600 seconds
Drain timeout: 300 seconds
Stop option: immediate
Session State Consistency: AUTO
GSM Flags: 0
Service is enabled
Preferred instances: db38p2
Available instances: db38p1
CSS critical: no
$
$
$
$ srvctl add service -db CDB_38P -service app_jumbo_3 -pdb P_SALES_P -preferred db38p2 -available db38p1 -cardinality singleton -failover_restore AUTO -failoverretry 1 -failoverdelay 3 -commit_outcome TRUE -failovertype AUTO -replay_init_time 600 -retention 86400 -notification TRUE -drain_timeout 300 -stopoption IMMEDIATE -l primary
PRKO-2110 : The '-cardinality' option is not supported on a 'add service' request for administrator-managed database CDB_38P.
$