Oracle 10.2.0.5 + Clusterware RAC

安装流程

ClusterWare Installtion1

下载p7320726_10204_Ser08-x86-64.zip

解压里面的ocfs.sys和orafencedrv.sys，重命名为ocfs.sys.w2k864,orafencedrv.sys.w2k8

根据文档用以下参数启动setupexe:

New_Driver_Loc="<drive>:/foo/bar/" 
oracle.has.cfs:s_newOcfspath="<drive>:/foo/bar/"
oracle.has.crs:b_isWIN2k8="TRUE" 
oracle.has.crs:s_newOcfspath="<drive>:/foo/bar/"
-ignoreSysprereqs

• 在windows中路径必需使用反斜杠”/”，因为斜杠会解释为转义符
• 安装到一半启动OraFenceService会出错，直接retry肯定不行。需要手动将orafencedrv.sys拷到system32\drivers下覆盖同名文件。然后点retry就OK了。

---

#    示例hosts文件
#    默认Localhost将解析到::1，所以建议加上ipv4进hosts
127.0.0.1       localhost

192.168.111.151   ORA01
192.168.111.152   ORA02

192.168.111.101   ORA01-VIP
192.168.111.102   ORA02-vip

192.168.22.151    ORA01-PRIV
192.168.22.152    ORA02-PRIV

---

Vote Disk

Vote Disk必需为奇数个，这意味着要么1要么3.如果只选择一个，会弹出警告:只有一个将无冗余，点确定可继续，但最后一步会出错：

Output generated from configuration assistant "Oracle Clusterware Configuration Assistant":
Command = C:\WINDOWS\system32\cmd /c call E:\oracle\product\10.2.0\crs/install/crssetup.config.bat
PROT-1: Failed to initialize ocrconfig
Step 1: checking status of CRS cluster
Step 2: creating directories (E:\oracle\product\10.2.0\crs)
Step 3: configuring OCR repository
ocr upgrade failed with (-1)

Configuration assistant "Oracle Clusterware Configuration Assistant" was canceled.

也就是说Vote Disk最少要3个。

---

打上10.2.0.5补丁集

onsctl stop
sc stop OracleCRService
sc stop OracleEVMService
sc stop OracleCSService
sc stop "Oracle Object Service"
sc stop OracleClusterVolumeService
C:\oracle\product\10.2.0\crs\install\patch102.bat

注意：必须在一个Node Upgrade完成后才到下一个Node，不然会卡死失败

---

安装Oracle Database

安装时会自动检测到RAC集群，其它与单节点安装无异。安装时不建议创建数据库，因为之后还要Upgrade。

安装后创建数据库

ASM

假如是全新的环境，此时会提示创建LISTENER。自动创建的LISTENER如下格式：

LISTENER_ORA01 =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = TCP)(HOST = ORA01-VIP)(PORT = 1521)(IP = FIRST))
      )
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.111.151)(PORT = 1521)(IP = FIRST))
      )
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
      )
    )
  )

这里会出现点小问题，首先是挂载的时候远程节点会失败。譬如说是在ORA01上面创建ASM，会提示ORA02挂载失败。查看一下LISTENER的status，里面也没有ASM的注册信息。可以通过修改%oracle_base%\admin\&