本案例用到的主要软硬件如下:

主机: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.检查srvcfg设置

检查/var/opt/oracle下srvConfig.loc文件,确保包含同样的链接:

srvconfig_loc=/dev/vx/rdsk/oradg/srvcfg

两边应该有同样的配置,否则gsd则不能启动.

 

12.配置裸设备列表

设置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

 

13.开始创建数据库

创建Oracle9i Rac数据库