11gr2 RAC DATABASE SERVICE
Database version: 11gR2
OS = Linux 6
RAC = 5 nodes
Questions:
1. when I run srvctl status service -d prod, it shows preferred instances but not failover, how would I find them?
Result: Service racprod_users is running on instance(s) prod1,dsprod2, .
2. how would I make sure that this service remains on these nodes, even after I reboot instances/servers? I just want to make sure that these sevices remains where I intended.
I see an entry in alert log that indicates that SCOPE=MEMORY SID='prod5'
commands:
srvctl add service -d prod -s racprod_users -r prod1,prod2 -a prod3,prod5 -q TRUE -m BASIC -e SELECT -z 180 -w 5
OS = Linux 6
RAC = 5 nodes
Questions:
1. when I run srvctl status service -d prod, it shows preferred instances but not failover, how would I find them?
Result: Service racprod_users is running on instance(s) prod1,dsprod2, .
2. how would I make sure that this service remains on these nodes, even after I reboot instances/servers? I just want to make sure that these sevices remains where I intended.
I see an entry in alert log that indicates that SCOPE=MEMORY SID='prod5'
commands:
srvctl add service -d prod -s racprod_users -r prod1,prod2 -a prod3,prod5 -q TRUE -m BASIC -e SELECT -z 180 -w 5
0