9i/10g TAF loadbalance的实现

 9i/10g TAF loadbalance的实现：

9i 中实现loadbalance需要将数据库的listener设为动态注册，在服务器端的tnsnames 里要加入类似如下，在数据库设置参数：local_listener，remote_listener：
LISTENERS_RAC =
  (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.68.38)(PORT = 1527))
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.68.39)(PORT = 1528))
    )
  )
LISTENER_RAC2 =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.68.39)(PORT = 1528)))

主机RAC1:
listener.ora
LISTENER_RAC1 =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.68.38)(PORT = 1527)))

tnsnames.ora
LISTENERS_RAC =
  (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.68.38)(PORT = 1527))
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.68.39)(PORT = 1528))
    )
  )

LISTENER_RAC1 =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.68.38)(PORT = 1527)))

主机RAC2:
listener.ora:
LISTENER_RAC2 =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.68.39)(PORT = 1528)))

tnsnames.ora:
LISTENERS_RAC =
  (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.68.38)(PORT = 1527))
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.68.39)(PORT = 1528))
    )
  )

LISTENER_RAC2 =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.68.39)(PORT = 1528)))

 

还需要设：
alter system set local_listener='LISTENER_RAC1' sid='RAC1'
alter system set local_listener='LISTENER_RAC2' sid='RAC2'
alter system set remote_listener='LISTENERS_RAC'

RAC1:
SQL> show parameter listen

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
local_listener                       string      LISTENER_RAC1
mts_listener_address                 string
mts_multiple_listeners               boolean     FALSE
remote_listener                      string      LISTENERS_RAC

RAC2:

SQL> show parameter listener

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
local_listener                       string      LISTENER_RAC2
mts_listener_address                 string
mts_multiple_listeners               boolean     FALSE
remote_listener                      string      LISTENERS_RAC

客户端的TNSNAME:
client tnsnames.ora:

##这个将实现loadblance 和failover
RAC =
  (DESCRIPTION =
    (LOAD_BALANCE = ON)
    (FAILOVER = ON)
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.68.38)(PORT = 1527))
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.68.39)(PORT = 1528))
    )
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = CMTR)
      ( FAILOVER_MODE=
         (TYPE=SELECT)
         (METHOD=BASIC)
         (RETRIES=3)
      )
    )
  )

##以下可以连上指定的实例：
RAC1 =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.68.38)(PORT = 1527))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = CMTR)
      (INSTANCE_NAME = RAC1)
    )
  )

RAC2 =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.38.39)(PORT = 1527))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = CMTR)
      (INSTANCE_NAME = RAC2)
    )
  )

 

下为:metalink:

Configuration of Load Balancing and Transparent Application Failover
	Doc ID:	Note:226880.1	Type:	BULLETIN
	Last Revision Date:	19-JUL-2008	Status:	PUBLISHED

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/10834762/viewspace-479765/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/10834762/viewspace-479765/