Oracle 10g/11g RAC Service names ---to avoid dead lock

提供service_name : crmsrv 以避免deadlock 情形:

讓orcl1 為active , orcl2為standby instance for Service

srvctl add service -d orcl -s service_test -r orcl1 -a orcl2

srvctl start service -d orcl -s service_test

----------------------------------------------------------

順道一提~ 如果2 node Oracle RAC只要提供一個instance service :

設定方法如下

Oracle RAC (2 nodes) supports active-passive mode enabling 1 node to "do the work"

whilst node 2 remains comparatively idle.

During a failure of the active database instance, users failover to the passive instance.

This feature can be configured by setting the following database initialisation

parameter to 1 on both instances:

active_instance_count = 1