RAC 10g with RAW over SLVM 手记

kk_op

1.install OS:
HP-UX gsyxdb01 B.11.31 U ia64 2607827282 unlimited-user license

2.install patch:
PHKL_39747
HWEnable11i
FEATURE11i
QPK1131

3.kernel

4.install SGeRAC
  SG-NMAPI       A.11.18.00     SG-NMAPI Serviceguard Extension for RAC SD product
  SG-RAC-Tool     A.11.18.00     Serviceguard Extension for RAC Toolkit SD Product

5.MC/SG
网络配置：
        gsyxdb01        gsyxdb02        备注
lan2        至cisco4503交换机        至cisco4503交换机        10.212.9.155/157
lan6        至cisco4503交换机        至cisco4503交换机        failover lan
lan0        交叉连接        交叉连接        心跳
存储配置：
        Gsyxdb01        Gsyxdb02        备注
HSV300/1G        disk11        disk16        vglock
HSV300/10G        disk12        disk17        vgdata

vi /etc/hosts
127.0.0.1       localhost       loopback
10.212.9.155    gsyxdb01
10.212.9.157    gsyxdb02
192.168.0.155   gsyxdb01-priv
192.168.0.157   gsyxdb02-priv
10.212.9.156    gsyxdb01-vip
10.212.9.158    gsyxdb02-vip

vi /.rhosts
gsyxdb01 root
gsyxdb02 root

mkdir /oracle
groupadd oinstall
usermod -d /oracle -g oinstall -G dba oracle
chown oracleinstall /oracle
chmod 755 /oracle
mkdir -p /oracle/product/CRS
mkdir -p /oracle/product/RAC10g
chown -R oracleinstall /oracle
su - oracle
  cp /etc/skel/.profile /oracle
chmod 755 /oracle/.profile
vi .profile
# Oracle Environment
export ORACLE_BASE=/oracle/product
export ORACLE_HOME=$ORACLE_BASE/RAC10g
export ORA_CRS_HOME=/oracle/product/CRS
export ORACLE_SID=ddtest
export ORACLE_TERM=xterm
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/libORACLE_HOME/rdbms/lib
export PATH=$PATHORACLE_HOME/binORA_CRS_HOME/bin
export CLASSPATH=$ORACLE_HOME/JREORACLE_HOME/jlibORACLE_HOME/rdbms/jlib/
$CLASSPATHORACLE_HOME/network/jlib
print \' \'
print \'$ORACLE_SID: \'$ORACLE_SID
print \'$ORACLE_HOME: \'$ORACLE_HOME
print \'$ORA_CRS_HOME: \'$ORA_CRS_HOME
print \' \'

export PS1=`hostname`:[\'$PWD\']$
export HISTFILE=~/.sh_history



vi /oracle/.rhosts
gsyxdb01       oracle
gsyxdb02       oracle
gsyxdb01-priv  oracle
gsyxdb02-priv  oracle
gsyxdb01-vip   oracle
gsyxdb02-vip   oracle

su - root
mkdir /dev/vgdata
mkdir /dev/vglock
mknod /dev/vgdata/group c 64 0x010000
mknod /dev/vglock/group c 64 0x020000
pvcreate -f /dev/rdisk/disk16
pvcreate -f /dev/rdisk/disk11
vgcreate -s 16 vgdata /dev/disk/disk11
vgcreate -s 16 vglock /dev/disk/disk16

lvcreate -L 2048 -n Controlfile1_128m vgdata
lvcreate -L 2048 -n Controlfile2_128m vgdata
lvcreate -L 2048 -n Controlfile3_128m vgdata
lvcreate -L 2048 -n Log1_a_256m       vgdata
lvcreate -L 2048 -n Log1_b_256m       vgdata
lvcreate -L 2048 -n Log1_c_256m       vgdata
lvcreate -L 2048 -n Log1_d_256m       vgdata
lvcreate -L 2048 -n Log2_a_256m       vgdata
lvcreate -L 2048 -n Log2_b_256m       vgdata
lvcreate -L 2048 -n Log2_c_256m       vgdata
lvcreate -L 2048 -n Log2_d_256m       vgdata
lvcreate -L 2048 -n Share_1g          vgdata
lvcreate -L 2048 -n Spfile_128m       vgdata
lvcreate -L 2048 -n System_1g         vgdata
lvcreate -L 2048 -n Tools_1g          vgdata
lvcreate -L 2048 -n indx_1g           vgdata
lvcreate -L 2048 -n ocr1_128m         vgdata
lvcreate -L 2048 -n ocr2_128m         vgdata
lvcreate -L 2048 -n sysaux_128m       vgdata
lvcreate -L 2048 -n temp_1g           vgdata
lvcreate -L 2048 -n undotbs01_128m    vgdata
lvcreate -L 2048 -n undotbs02_128m    vgdata
lvcreate -L 2048 -n users_1g          vgdata
lvcreate -L 2048 -n vot1_128m         vgdata
lvcreate -L 2048 -n vot2_128m         vgdata
lvcreate -L 2048 -n vot3_128m         vgdata
lvcreate -L 2048 -n data1_128m        vgdata
lvcreate -L 2048 -n data2_128m        vgdata
lvcreate -L 2048 -n data3_128m        vgdata

chown oracleinstall /dev/vgdata/rControlfile1_128m
chown oracleinstall /dev/vgdata/rControlfile2_128m
chown oracleinstall /dev/vgdata/rControlfile3_128m
chown oracleinstall /dev/vgdata/rLog1_a_256m      
chown oracleinstall /dev/vgdata/rLog1_b_256m      
chown oracleinstall /dev/vgdata/rLog1_c_256m      
chown oracleinstall /dev/vgdata/rLog1_d_256m      
chown oracleinstall /dev/vgdata/rLog2_a_256m      
chown oracle:oinstall /dev/vgdata/rLog2_b_256m      
chown oracle:oinstall /dev/vgdata/rLog2_c_256m      
chown oracle:oinstall /dev/vgdata/rLog2_d_256m      
chown oracle:oinstall /dev/vgdata/rShare_1g         
chown oracle:oinstall /dev/vgdata/rSpfile_128m      
chown oracle:oinstall /dev/vgdata/rSystem_1g        
chown oracle:oinstall /dev/vgdata/rTools_1g         
chown oracle:oinstall /dev/vgdata/rindx_1g         
chown oracle:oinstall /dev/vgdata/rocr1_128m        
chown oracle:oinstall /dev/vgdata/rocr2_128m        
chown oracle:oinstall /dev/vgdata/rsysaux_128m      
chown oracle:oinstall /dev/vgdata/rtemp_1g         
chown oracle:oinstall /dev/vgdata/rundotbs01_128m   
chown oracle:oinstall /dev/vgdata/rundotbs02_128m   
chown oracle:oinstall /dev/vgdata/rusers_1g         
chown oracle:oinstall /dev/vgdata/rvot1_128m        
chown oracle:oinstall /dev/vgdata/rvot2_128m        
chown oracle:oinstall /dev/vgdata/rvot3_128m        
chown oracle:oinstall /dev/vgdata/rdata1_128m      
chown oracle:oinstall /dev/vgdata/rdata2_128m      
chown oracle:oinstall /dev/vgdata/rdata3_128m      

vgchange -a n vgdata
vgchange -a n vglock
vgexport -s -p -m /tmp/hptools/vgdata.map vgdata
vgexport -s -p -m /tmp/hptools/vglock.map vglock
rcp /tmp/hptools/*map gsyxdb02:/tmp/hptools/
vgimport -s -N -m /tmp/hptools/vgdata.map vgdata
vgimport -s -N -m /tmp/hptools/vglock.map vglock
cmquerycl -v -C /etc/cmcluster/clusterconf.ascii -n gsyxdb01 -n gsyxdb02
vi /etc/cmcluster/clusterconf.ascii
vgchange -a y vglock
cmcheckconf -v -C /etc/cmcluster/clusterconf.ascii
cmapplyconf -v -C /etc/cmcluster/clusterconf.ascii
cmruncl -v
vi /etc/lvmrc
gsyxdb01:
mkdir /etc/cmcluster/SGeRAC1
cmmakepkg -v -p /etc/cmcluster/SGeRAC1/SGeRAC1.conf
vi /etc/cmcluster/SGeRAC1/SGeRAC1.conf
  “/etc/cmcluster/SGeRAC1/control1.sh”
cmmakepkg -v -s /etc/cmcluster/SGeRAC1/control1.sh
vi /etc/cmcluster/SGeRAC1/control1.sh
cmcheckconf -v -P /etc/cmcluster/SGeRAC1/SGeRAC1.conf
cmapplyconf -v -P /etc/cmcluster/SGeRAC1/SGeRAC1.conf
gsyxdb02:
mkdir /etc/cmcluster/SGeRAC2
cmmakepkg -v -p /etc/cmcluster/SGeRAC2/SGeRAC2.conf
vi /etc/cmcluster/SGeRAC2/SGeRAC2.conf
  “/etc/cmcluster/SGeRAC2/control2.sh”
cmmakepkg -v -s /etc/cmcluster/SGeRAC2/control2.sh
vi /etc/cmcluster/SGeRAC2/control2.sh
cmcheckconf -v -P /etc/cmcluster/SGeRAC2/SGeRAC2.conf
cmapplyconf -v -P /etc/cmcluster/SGeRAC2/SGeRAC2.conf

6.install Oracle software
echo dba MLOCK RTSCHED RTPRIO >/etc/privgroup
setprivgrp -f /etc/privgroup

chmod 755 *
./unzip *.zip
./runInstaller -ignoresysprereqs
su
vipca

olsnodes -n
crs_stat -t

安装rac10g r2
./runInstaller -ignoresysprereqs

vi .dtprofile

netca 配置监听

crs_stat -t检查下

sqlplus /nolog

hiders

贴出你的ioscan -fnC disk,看看io路径是否合拼了。另外内核参数是否调整好了。