梦想有多远

RAC一些常规操作
一、负载均衡配置
(1)ORACLE 9I
首先配置Listener.ora
rac1.local_listener=’(address=(protocol=tcp)(host=dbrac01)(port=1521)’
rac1.remote_listener=’(address=(protocol=tcp)(host=dbrac02)(port=1521)’
rac2.local_listener=’(address=(protocol=tcp)(host=dbrac02)(port=1521)’
rac2.remote_listener=’(address=(protocol=tcp)(host=dbrac01)(port=1521)’
配置tnsname.ora
rac=
 (description=
  (load_balance=on)
   (failover=on)
    (address_list=
     (address=(protocol=tcp)(host=dbrac01)(port=1521))
     (address=(protocol=tcp)(host=dbrac02)(port=1521))
      (connect_data=
         (service_name=rac)
         (failover_mode=(type=select)(method=basic))
 ))

(全文…)