How to Configure DB services to start by Automatically on cluster
How to Configure DB services to start by Automatically on cluster (oracle restart and cluster environments )
Services can be start with following Option:
PRIMARY,PHYSICAL_STANDBY,LOGICAL_STANDBY,SNAPSHOT_STANDBY
--If Service role option is "PRIMARY" then the service will not start automatically on a standby DB when clusterware/Oracle Restart start by "crsctl start has/crs" command, it need to be started manually.
--With below option you can check the service configuration:
$ srvctl config service -s <Service_Name> -d <database_name>
--you can see what define on With Service role option, here below as mention Primary so it will auto restart on Primany only.
Service role: PRIMARY
--In order to get a service startup automatically when clusterware:
$ srvctl modify service -d <DB_NAME> -s <service_name> -l 'PRIMARY,PHYSICAL_STANDBY'
--Now will see that Service role cnfigured to startup automaticaly with "PRIMARY,PHYSICAL_STANDBY"
$ srvctl config service -s ORACLDB_GG -d oracldb
Service name: RDXREP_GG
Service is enabled
Cardinality: SINGLETON
Disconnect: false
Service role: PRIMARY,PHYSICAL_STANDBY
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
Edition:
Services can be start with following Option:
PRIMARY,PHYSICAL_STANDBY,LOGICAL_STANDBY,SNAPSHOT_STANDBY
--If Service role option is "PRIMARY" then the service will not start automatically on a standby DB when clusterware/Oracle Restart start by "crsctl start has/crs" command, it need to be started manually.
--With below option you can check the service configuration:
$ srvctl config service -s <Service_Name> -d <database_name>
--you can see what define on With Service role option, here below as mention Primary so it will auto restart on Primany only.
Service role: PRIMARY
--In order to get a service startup automatically when clusterware:
$ srvctl modify service -d <DB_NAME> -s <service_name> -l 'PRIMARY,PHYSICAL_STANDBY'
--Now will see that Service role cnfigured to startup automaticaly with "PRIMARY,PHYSICAL_STANDBY"
$ srvctl config service -s ORACLDB_GG -d oracldb
Service name: RDXREP_GG
Service is enabled
Cardinality: SINGLETON
Disconnect: false
Service role: PRIMARY,PHYSICAL_STANDBY
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
Edition:
Good post. Thanks for sharing.
ReplyDelete