星期五, 3月 22, 2013

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

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

orcl1 active , orcl2standby 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 

沒有留言:

LinkWithin-相關文件

Related Posts Plugin for WordPress, Blogger...