SI实验指南：Vmware Sphere ESXI5.0 使用虚拟文件共享安装
RHEL5_x64+Oracle11gR2_x64 RAC
Vmware Vsphere ESXI5.0环境下RHEL5.5_x64 搭建oracle 11.2.0.1_x64及升级11.2.0.3.5
RAC文档
2013-01-21
详细安装步骤
1
SI实验指南：Vmware Sphere ESXI5.0 使用虚拟文件共享安装
RHEL5_x64+Oracle11gR2_x64 RAC
目录
一、规划........................................................................................................................................... 3 二、Vmware Vsphere配置两台虚拟主机 ...................................................................................... 3 三、安装准备（两节点操作） ....................................................................................................... 9 四、创建ASK DISK ........................................................................................................................ 13 五、clusterware安装 .................................................................................................................. 15 六、安装Database数据库软件 ................................................................................................... 38 七、使用DBCA建库 ....................................................................................................................... 48 八、 查看集群状态 ..................................................................................................................... 61 九、安装新11.2.0.3的grid frastructure ............................................................................ 64
(一) 备份并停止110201的数据库 ............................................................................... 64 (二) 安装第2套GRID的方法 ....................................................................................... 65 十、安装11.2.0.3 database及建库 ......................................................................................... 68 十一、升级GRID至11.2.0.3.5 .................................................................................................. 69 十二、升级DATABASE PSU11.2.0.3.5 ........................................................................................ 73 十三、使用DBCA建和原库一致的数据库[30分钟] .................................................................. 78 十四、导入原数据库并测试业务 ................................................................................................. 79 十五、退回11.2.0.1版本 ........................................................................................................... 79 十六、再切回11.2.0.3版本 ....................................................................................................... 81 附录：相关脚本 ............................................................................................................................. 82
2
SI实验指南：Vmware Sphere ESXI5.0 使用虚拟文件共享安装
RHEL5_x64+Oracle11gR2_x64 RAC
一、规划
主机名 公共网卡及IP 私有网卡及IP 虚拟网卡及IP SCAN IP 节点1 rac1 eth0/10.228.13.88/rac1 节点2 rac2 eth0/10.228.13.89/rac2 eth1/192.168.123.88/rac1-priv eth1/192.168.123.89/rac2-priv 192.168.1.110/rac1-vip 192.168.1.111/rac2-vip 10.228.13.112/rac-scan 二、Vmware Vsphere配置两台虚拟主机
1. 配置2台RAC虚拟机配置如下：
内存 网卡 硬盘空间 共享磁盘空间
节点1 节点2 4G 4G 2个 2个 20G(存放安装文件) 15G 10G（2个虚拟共享虚拟磁盘分区(/dev/sdb、/dev/sdc） 2. 连接虚拟机服务器(这里为10.228.13.67)，创建共享磁盘：
# cd /vmfs/volumes/datastore1 # mkdir sharelqs
# vmkfstools -d eagerzeroedthick -a lsilogic -c 5G rac01.vmdk # vmkfstools -d eagerzeroedthick -a lsilogic -c 5G rac02.vmdk /vmfs/volumes/4f72f9c7-e902920c-c903-00e081d96b5d/sharelqs # pwd /vmfs/volumes/datastore1/sharelqs
/vmfs/volumes/4f72f9c7-e902920c-c903-00e081d96b5d/sharelqs # ls -l
-rw------- 1 root root 5242880000 Jan 13 07:57 rac01-flat.vmdk -rw------- 1 root root 488 Jan 16 05:30 rac01.vmdk -rw------- 1 root root 5242880000 Jan 13 07:58 rac02-flat.vmdk
3
SI实验指南：Vmware Sphere ESXI5.0 使用虚拟文件共享安装
RHEL5_x64+Oracle11gR2_x64 RAC
-rw------- 1 root root 488 Jan 16 05:34 rac02.vmdk
如果是Vmware Workstation,则命令语法如下：
D:\\Program Files\\Vmware\\vmware-vdiskmanager.exe -a lsilogic -c -s 100MB -t 2 rac01.vmdk 3. 关闭2台虚拟机，并在rac11.vmx和rac12.vmx配置文件分别增加如下虚
拟磁盘配置：
disk.locking=\diskLib.dataCacheMaxSize = \diskLib.dataCacheMaxReadAheadSize = \
diskLib.DataCacheMinReadAheadSize = \diskLib.dataCachePageSize = \diskLib.maxUnsyncedWrites = \scsi1.present = \scsi1:0.present = \scsi1.sharedBus = \scsi1.virtualDev = \scsi1:0.fileName =
\01.vmdk\
scsi1:0.mode = \scsi1:0.deviceType = \scsi2.present = \scsi2:0.present = \scsi2.sharedBus = \scsi2.virtualDev = \scsi2:0.fileName =
\02.vmdk\
scsi2:0.mode = \scsi2:0.deviceType = \numvcpus = \cpuid.coresPerSocket = %unity.wasCapable = \scsi1:0.redo = \
scsi2:0.redo = \scsi1.pciSlotNumber = \scsi2.pciSlotNumber = \
4. 分别登陆2台虚拟机按安装规划设置IP
[root@rac1 ~]# ifconfig -a
eth0 Link encap:Ethernet HWaddr 00:0C:29:BC:EE:3C inet addr:10.228.13.88 Bcast:10.228.13.127 Mask:255.255.255.192
4
SI实验指南：Vmware Sphere ESXI5.0 使用虚拟文件共享安装
RHEL5_x64+Oracle11gR2_x64 RAC
inet6 addr: fe80::20c:29ff:febc:ee3c/64 Scope:Link UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1 RX packets:444 errors:0 dropped:0 overruns:0 frame:0 TX packets:257 errors:0 dropped:0 overruns:0 carrier:0 collisions:0 txqueuelen:1000
RX bytes:40056 (39.1 KiB) TX bytes:32935 (32.1 KiB)
eth1 Link encap:Ethernet HWaddr 00:0C:29:BC:EE:46 inet addr:192.168.123.88 Bcast:192.168.123.255 Mask:255.255.255.0
inet6 addr: fe80::20c:29ff:febc:ee46/64 Scope:Link UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1 RX packets:172 errors:0 dropped:0 overruns:0 frame:0 TX packets:43 errors:0 dropped:0 overruns:0 carrier:0 collisions:0 txqueuelen:1000
RX bytes:15078 (14.7 KiB) TX bytes:6206 (6.0 KiB) 【注意: vip及scan地址是不能配置的，也不能存在此IP，在crs安装后自动绑定到public网卡上！】 5. 确认共享盘能在2边节点看到
[root@rac1 ~]# fdisk -l
Disk /dev/sda: 21.4 GB, 21474836480 bytes 255 heads, 63 sectors/track, 2610 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes
Device Boot Start End Blocks Id System /dev/sda1 * 1 13 104391 83 Linux /dev/sda2 14 2610 20860402+ 8e Linux LVM
Disk /dev/sdb: 5242 MB, 5242880000 bytes 255 heads, 63 sectors/track, 637 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes
Device Boot Start End Blocks Id System
Disk /dev/sdc: 5242 MB, 5242880000 bytes 255 heads, 63 sectors/track, 637 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes
Device Boot Start End Blocks Id System
[root@rac2 ~]# fdisk -l
5