本文链接:
http://www.eygle.com/ha/Install.Oracle9iRac.On.Veritas.EMC.htm
本案例用到的主要软硬件如下:
主机:Sun-Fire-V210
操作系统:SunOS 5.9 Generic_117171-07
光纤卡:Emulex LightPulse FC9002L
阵列:EMC CLARiiON CX500
Cluster软件:VERITAS STORAGE FOUNDATION FOR ORACLE RAC 4.0
Oracle版本:Oracle9.2.0.4
1.安装操作系统
安装基本系统以后,应用到最新的补丁
> # uname -a
> SunOS cluster1 5.9 Generic_117171-07 sun4u sparc SUNW, Sun-Fire-V210
配置hosts文件,设置相应别名,配置一个浮动ip(配置Cluster时需要)
>
>
> >
> # cat /etc/hosts
> #
> # Internet host table
> #
> 127.0.0.1 localhost
> 172.16.33.71 cluster2 cluster2.hurray.com.cn loghost
> 172.16.33.70 cluster1 cluster1.hurray.com.cn
> 172.16.33.74 cluster cluster.hurray.com.cn
>
> >
2.安装光纤卡
本例使用的是Emulex的光线卡,Emulex LightPulse FC9002L光线卡需要到网站上下载最新的驱动安装
使用光盘上的驱动系统会莫名其妙的循环重起,极度郁闷
光线卡安装日志参考:
Emulex_LightPulse_FC9002L_Solaris9_Install
光纤卡安装以后需要配置两个参数文件:
Emulex光纤卡lpfc配置文件的修改
完成这个步骤后重新启动机器,使配置生效,把主机和光纤交换机及EMC阵列相连接
3.安装 EMC Navisphere AGENT(NAVIAGENT)
安装EMC Navisphere AGENT(NAVIAGENT)
安装完成后,重新启动服务器,此时agent会自动启动,自EMC阵列控制器上应该可以看到主机节点
4.分配磁盘组
在EMC阵列端,把划好的磁盘组分配给主机
分配磁盘组(EMC阵列)
分配磁盘组后,重起主机
5.安装VERITAS STORAGE FOUNDATION FOR ORACLE RAC 4.0软件
安装Veritas Storage Fundation For Oracle Rac4.0
6.配置共享磁盘
使用Volume Manager配置共享磁盘
7.修改系统内核参数
为安装Oracle做准备
在/etc/system文件末尾追加以下参数,两台主机都需要修改:
>
> * kernal parameter for Oracle database add by:gqgai
> set shmsys:shminfo_shmmax=4294967295
> set shmsys:shminfo_shmmin=1
> set shmsys:shminfo_shmmni=100
> set shmsys:shminfo_shmseg=10
>
> set semsys:seminfo_semmni=1024
> set semsys:seminfo_semmsl=1510
> set semsys:seminfo_semmns=3010
> set semsys:seminfo_semopm=100
> set semsys:seminfo_semvmx=32767
>
修改后重新启动主机
8.划分裸设备
根据实际需要划分裸设备
>
> vxassist -g oradg -U gen make system 800m
> vxassist -g oradg -U gen make temp 1000m
> vxassist -g oradg -U gen make users 1000m
>
> vxassist -g oradg -U gen make redo101 100m
> vxassist -g oradg -U gen make redo102 100m
> vxassist -g oradg -U gen make redo103 100m
>
> vxassist -g oradg -U gen make redo201 100m
> vxassist -g oradg -U gen make redo202 100m
> vxassist -g oradg -U gen make redo203 100m
>
> vxassist -g oradg -U gen make undo11 1000m
> vxassist -g oradg -U gen make undo21 1000m
>
> vxassist -g oradg -U gen make spfile 100m
>
> vxassist -g oradg -U gen make ctlfile1 100m
> vxassist -g oradg -U gen make ctlfile2 100m
>
> vxassist -g oradg -U gen make srvcfg 500m
>
>
> >
>
修改属主信息:
>
> vxedit -g oradg set user=oracle mode=644 system
> vxedit -g oradg set user=oracle mode=644 temp
> vxedit -g oradg set user=oracle mode=644 users
>
> vxedit -g oradg set user=oracle mode=644 redo101
> vxedit -g oradg set user=oracle mode=644 redo102
> vxedit -g oradg set user=oracle mode=644 redo103
>
> vxedit -g oradg set user=oracle mode=644 redo201
> vxedit -g oradg set user=oracle mode=644 redo202
> vxedit -g oradg set user=oracle mode=644 redo203
>
> vxedit -g oradg set user=oracle mode=644 undo11
> vxedit -g oradg set user=oracle mode=644 undo21
>
> vxedit -g oradg set user=oracle mode=644 spfile
>
> vxedit -g oradg set user=oracle mode=644 ctlfile1
> vxedit -g oradg set user=oracle mode=644 ctlfile2
>
> vxedit -g oradg set user=oracle mode=644 srvcfg
>
> >
>
9.复制相应的库文件
>
> # cd /opt/ORCLcluster/lib
> # ls
> 9iR2
> # cd *
> # ls
> libskgxn2_32.so libskgxn2_32.so.1 libskgxn2_64.so libskgxn2_64.so.1 libskgxp92_32.so libskgxp92_64.so
> # cp libskgxn2_64.so ../libskgxn2.so
> # ls
> libskgxn2_32.so libskgxn2_32.so.1 libskgxn2_64.so libskgxn2_64.so.1 libskgxp92_32.so libskgxp92_64.so
>
> >
>
10.安装Oracle软件
安装Oracle9i软件
11.配置裸设备列表
设置DBCA_RAW_CONFIG环境变量
创建DBCA_RAW_CONFIG.txt配置文件
>
> control1=/dev/vx/rdsk/oradg/ctlfile1
> > control2=/dev/vx/rdsk/oradg/ctlfile2
> > redo1_1=/dev/vx/rdsk/oradg/redo101
> > redo1_2=/dev/vx/rdsk/oradg/redo102
> > redo1_3=/dev/vx/rdsk/oradg/redo103
> > redo2_1=/dev/vx/rdsk/oradg/redo201
> > redo2_2=/dev/vx/rdsk/oradg/redo202
> > redo2_3=/dev/vx/rdsk/oradg/redo203
> > spfile=/dev/vx/rdsk/oradg/spfile
> > system=/dev/vx/rdsk/oradg/system
> > temp=/dev/vx/rdsk/oradg/temp
> > users=/dev/vx/rdsk/oradg/users
> > undotbs1=/dev/vx/rdsk/oradg/undo11
> > undotbs2=/dev/vx/rdsk/oradg/undo21
>
> >
在user profile文件中设置:
>
> DBCA_RAW_CONFIG=/opt/oracle/admin/Rac9i/create/DBCA_RAW_CONFIG.txt
> > export DBCA_RAW_CONFIG
12.开始创建数据库
创建Oracle9i Rac数据库