veritas cfs for oracle rac安裝過程。

yhj20041128001發表於2012-04-06
Oracle
 

Disk /dev/sdb: 8589 MB, 8589934592 bytes
Disk /dev/sdc: 5368 MB, 5368709120 bytes
Disk /dev/sdd: 214 MB, 214748160 bytes
Disk /dev/sde: 214 MB, 214748160 bytes
Disk /dev/sdf: 214 MB, 214748160 bytes
vxdctl -c mode
vxdctl enable
cfscluster config
vxdisk -f init sdb
vxdisk -f init sdc
vxdisk -f init sdd
vxdisk -f init sde
vxdisk -f init sdf
或者
vxdisksetup -i sdb
 
建立 coordinator disk groups
vxdg -s init vcvxfencoorddg  vcvxfencoorddg01=sdd
vxdg -g vcvxfencoorddg adddisk vcvxfencoorddg02=sde
vxdg -g vcvxfencoorddg adddisk vcvxfencoorddg03=sdf
啟用 vcvxfencoorddg
vxdg -g vcvxfencoorddg set coordinator=on
vxdg deport vcvxfencoorddg
vxdg -t import vcvxfencoorddg
vxdg deport vcvxfencoorddg
分別在兩節點上執行
echo "vcvxfencoorddg" > /etc/vxfendg
hastop -all
分別在兩節點上執行 ( IO fencing不用配置，在虛擬機器上面
 虛擬機器不能實現IO Fencing  /etc/vxfenmode  vxfen_mode=disabled)
/etc/init.d/vxfen stop
cp /etc/vxfen.d/vxfenmode_scsi3_dmp  /etc/vxfenmode
/etc/init.d/vxfen start
vxdisk -o alldgs list
 
建立oracle data diskgroup
vxdg -s init vcoradatadg sdb
vxassist -g vcoradatadg -b make vcoradatavol  6200M alloc=sdb
vxassist -g vcoradatadg -b make vcocrvol01 300M alloc=sdb
vxassist -g vcoradatadg -b make vcorcvol02  300M alloc=sdb
vxassist -g vcoradatadg -b make vcvotevol01 300M alloc=sdb
vxassist -g vcoradatadg -b make vcvotevol02 300M alloc=sdb
vxassist -g vcoradatadg -b make vcvotevol03 300M alloc=sdb
vxedit -g vcoradatadg set group=dba user=oracle mode=660 vcoradatavol
vxedit -g vcoradatadg set group=dba user=oracle mode=660 vcocrvol01
vxedit -g vcoradatadg set group=dba user=oracle mode=660 vcorcvol02
vxedit -g vcoradatadg set group=dba user=oracle mode=660  vcvotevol01
vxedit -g vcoradatadg set group=dba user=oracle mode=660 vcvotevol02
vxedit -g vcoradatadg set group=dba user=oracle mode=660 vcvotevol03
建立arch data diskgroup
vxdg -s init vcarchdg  sdc
vxassist -g  vcarchdg -b make vcarchvol 5000M alloc=sdc
vxedit -g vcarchdg set group=dba user=oracle mode=600  vcarchvol
格式化磁碟
mkfs -t vxfs /dev/vx/rdsk/vcoradatadg/vcoradatavol
mkfs -t vxfs /dev/vx/rdsk/vcarchdg/vcarchvol
掛載磁碟到filesystem
mkdir /oradata
mkdir /archlog
mount -t vxfs -o cluster /dev/vx/dsk/vcoradatadg/vcoradatavol /oradata
mount -t vxfs -o cluster /dev/vx/dsk/vcarchdg/vcarchvol /archlog

刪除邏輯卷
vxassist -g oradg remove volume oralv05  <<<<< 刪除邏輯卷
1建立cvm資源組及信任關係
haconf -makerw
hares -add vcoradata_voldg CVMVolDg cvm
hares -modify vcoradata_voldg CVMDiskGroup vcoradatadg
hares -modify vcoradata_voldg CVMVolume -add vcocrvol01
hares -modify vcoradata_voldg CVMVolume -add vcorcvol02
hares -modify vcoradata_voldg CVMVolume -add vcvotevol01
hares -modify vcoradata_voldg CVMVolume -add vcvotevol02
hares -modify vcoradata_voldg CVMVolume -add vcvotevol03
hares -modify vcoradata_voldg CVMVolume -add vcoradatavol
hares -modify vcoradata_voldg CVMActivation sw
hares -link vcoradata_voldg vxfsckd
hares -modify vcoradata_voldg Enabled 1
haconf -dump -makero
hares -state vcoradata_voldg
hares -online vcoradata_voldg -sys trac1
hares -online vcoradata_voldg -sys trac2
haconf -makerw
hares -add vcarch_voldg CVMVolDg  cvm
hares -modify vcarch_voldg CVMDiskGroup vcarchdg
hares -modify vcarch_voldg CVMVolume -add vcarchvol
hares -modify vcarch_voldg CVMActivation sw
hares -link vcarch_voldg  vxfsckd
hares -modify vcarch_voldg Enabled 1
haconf -dump -makero
hares -state vcarch_voldg
hares -online vcarch_voldg  -sys trac1
hares -online vcarch_voldg   -sys trac2
修改/etc/VRTSvcs/conf/config/main.cf檔案，新增硬碟掛載點
CFSMount archlog (
                Critical = 0
                MountPoint = "/archlog"
                BlockDevice = "/dev/vx/dsk/vcarchdg/vcarchvol"
                )
        CFSMount oradata (
                Critical = 0
                MountPoint = "/oradata"
                BlockDevice = "/dev/vx/dsk/vcoradatadg/vcoradatavol"
                )
最後，關閉vcs服務，重啟Server
hastop -all
 
 

1.      oracle 核心引數.

分別在/etc/rc.d/rc.local 中新增以下能容

 

export SEMMSL=250

export SEMMNS=32000

export SEMOPM=100

export SEMMNI=128

echo $SEMMSL $SEMMNS $SEMOPM $SEMMNI>/proc/sys/kernel/sem

export SHMMAX=51539607552

export SHMMNI=4096

export SHMALL=4194304

echo $SHMMAX>/proc/sys/kernel/shmmax

echo $SHMMNI>/proc/sys/kernel/shmmni

echo $SHMALL>/proc/sys/kernel/shmall

echo 131072 >/proc/sys/fs/file-max

echo 262144 >/proc/sys/net/core/rmem_default

echo 262144 >/proc/sys/net/core/rmem_max

echo 262144 >/proc/sys/net/core/wmem_default

echo 262144 >/proc/sys/net/core/wmem_max

echo 0 >/proc/sys/net/ipv4/tcp_timestamps

echo 0 >/proc/sys/net/ipv4/tcp_sack

echo 1024        65000 > /proc/sys/net/ipv4/ip_local_port_range

 

sysctl -w 使它生效

修改.bash_profile檔案

 

 export PATH

export TMP=/tmp

export ORACLE_BASE=/oracle

export ORACLE_HOME=/oracle/10205/db_1

export ORACLE_SID=vcstest

export ORACLE_TERM=xterm

export TNS_ADMIN=$ORACLE_HOME/network/admin

export ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/data

export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$ORACLE_HOME/srvm/lib:/lib:/usr/lib:/usr/openwin/lib:/usr/local/lib

export CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib:$ORACLE_HOME/network/jlib

export PATH=$ORACLE_HOME/bin:$PATH

export THREADS_FLAG=native

export H=$ORACLE_HOME

export CM=$ORACLE_BASE/10205/crs_1

export TERM=vt100

export AGTCTL_ADMIN=/oracle/10205/network/agent/config

PATH=$PATH:$HOME/bin:$ORACLE_HOME/OPatch:$OCM/bin

umask 022

export PS1=`hostname`'$'

 

 

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/23757700/viewspace-720605/，如需轉載，請註明出處，否則將追究法律責任。

相關文章