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`'<$PWD>$'

ITPub博客

veritas cfs for oracle rac安裝過程。

最新文章