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: 

Comments

Post a Comment

Popular posts from this blog

Oracle 2 node RAC primary and standby installation and setup on Oracle Linux