oracle 11gR2 RAC Client 配置

RAC環境：

1. Cent OS (基於vmware workstation)：

第一台主機：rac01.smartoffice.com:    （充當DNS）

public IP:  192.168.226.146        

private IP:  192.168.1.109

VIP :           192.168.226.150

public Name:  rac01.smartoffice.com

private Name: rac01-priv.smartoffice.com

VIP Name:       rac01-vip.smartoffice.com

第二台主機：rac02.smartoffice.com

public IP:  192.168.226.149     

private IP:  192.168.1.110

VIP :           192.168.226.151

public Name:  rac02.smartoffice.com

private Name: rac02-priv.smartoffice.com

VIP Name:       rac02-vip.smartoffice.com

SCAN Name & IP address: 

 SCANRAC.smartoffice.com    192.168.226.201

SCANRAC.smartoffice.com      192.168.226.202

SCANRAC.smartoffice.com      192.168.226.203

2. Oracle 11gR2  ( grid infrastructure $ database )

3.  openfiler共用儲存伺服器

4. 使用主機windows server 2003來訪問虛擬機器中的RAC，需要配置c:/windows/system32/drivers/etc/hosts和$ORACLE_HOME/network/admin/tnsnames.ora

tnsnames.ora:

ORCL11G =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.226.151)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orcl.smartoffice.com)
    )
  )

ORCL =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.226.150)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orcl.smartoffice.com)
    )
  )

SCANRAC=
    (DESCRIPTION =
           (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.226.201)(PORT = 1521))
       (CONNECT_DATA =
       (SERVER = DEDICATED)
       (SERVICE_NAME = orcl.smartoffice.com)
    )
  )

hosts檔案：

127.0.0.1       localhost
#   public rac nodes IP addresses

192.168.226.146    rac01.smartoffice.com rac01
192.168.226.149    rac02.smartoffice.com rac02

#   private rac nodes IP addresses

192.168.1.109           rac01-priv.smartoffice.com rac01-priv
192.168.1.110           rac02-priv.smartoffice.com rac02-priv

#   Scanrac nodes

192.168.226.201     scanrac.smartoffice.com    scanrac
192.168.226.202     scanrac.smartoffice.com    scanrac
192.168.226.203    scanrac.smartoffice.com    scanrac

#   VIP addresses

192.168.226.150     rac01-vip.smartoffice.com  rac01-vip
192.168.226.151    rac02-vip.smartoffice.com rac02-vip