Relocate service in RAC / find alternative service instance name
ORACLE: 11gR2RAC: 6 nodes
OS: Linux 6
SERVERS: prodrac01,prodrac02,prodrac03,prodrac04,prodrac05,prodrac06
Instances: prodrac1, prodrac2, prodrac3, prodrac4, prodrac5, prodrac6
1. when I run srvctl status service -d prodrac, I get all services and instance name but it does not show alternative service/fail over instances for each. how would I find this info.
2. how to find out the alternative service (fail over) instances?
3. is there a way to safely relocate services without interfering with existing user connections. For Example, If I using the server pharm_prod that existing on instance2 and I am running a huge query meanwhile a DBA change this service from instance2 to instance3, will my connection/query break or will it complete but next login, the user with pharm_prod service will now got to instance3.
OS: Linux 6
SERVERS: prodrac01,prodrac02,prodrac03,prodrac04,prodrac05,prodrac06
Instances: prodrac1, prodrac2, prodrac3, prodrac4, prodrac5, prodrac6
1. when I run srvctl status service -d prodrac, I get all services and instance name but it does not show alternative service/fail over instances for each. how would I find this info.
2. how to find out the alternative service (fail over) instances?
3. is there a way to safely relocate services without interfering with existing user connections. For Example, If I using the server pharm_prod that existing on instance2 and I am running a huge query meanwhile a DBA change this service from instance2 to instance3, will my connection/query break or will it complete but next login, the user with pharm_prod service will now got to instance3.
0