一:准备工作
环境
1. 虚拟机vm server 2.0
2. Red Hat Enterprise Linux 6.0 oracle 11.2.0.4
Ip 配置
192.168.16.131 Demodb
192.168.16.135 Demodb-vip
192.168.16.158 Demodb-cluster-scan
磁盘规划(用udev 代替ASMLIB做asm)
/dev/sdb1 2G
/dev/sdc1 2G
/dev/sdd1 8G
安装RPM包
binutils-2.20.51.0.2-5.20.el6.i686
binutils-devel-2.20.51.0.2-5.20.el6.i686
compat-libstdc++-33-3.2.3-69.el6.i686
compat-libcap1-1.10-1.i686 必须的没有会报错
elfutils-libelf-0.152-1.el6.i686
elfutils-libelf-devel-0.152-1.el6.i686
glibc-headers-2.12-1.25.el6.i686
glibc-devel-2.12-1.25.el6.i686
glibc-2.12-1.25.el6.i686
glibc-common-2.12-1.25.el6.i686
ibgcc-4.4.5-6.el6.i686
libstdc++-4.4.5-6.el6.i686
libstdc++-docs-4.4.5-6.el6.i686
libstdc++-devel-4.4.5-6.el6.i686
sysstat-9.0.4-18.el6.i686
unixODBC-devel-2.2.14-11.el6.i686
unixODBC-2.2.14-11.el6.i686
pdksh-5.2.14-1.i386 必须的
ksh-20100621-2.el6.i686. 和 pdksh-5.2.14-1.i386 冲突 用rpm -e ksh删除
cvuqdisk-1.0.9-1.rpm 这个包在grid 安装目录就有
需要创建oinstall才可以安装
二:参数设置
修改系统参数:
在root下
vi /etc/security/limits.conf
grid soft nproc 2047
grid hard nproc 16384
grid soft nofile 1024
grid hard nofile 65536
vi /etc/pam.d/login
session required pam_limits.so
vi /etc/sysctl.conf
fs.aio-max-nr = 1048576
fs.file-max = 6815744
kernel.shmall = 2097152
kernel.shmmax = 536870912
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
net.ipv4.ip_local_port_range = 9000 65500
net.core.rmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048586
gird时间同步所需要的设置(11gR2新增检查项)
service ntpd stop
chkconfig ntpd off
rm /etc/ntp.conf
mv /etc/ntp.conf to /etc/ntp.conf.org
/dev/shm 共享内存不足的处理
修改/etc/fstab的这行:默认的
none /dev/shm tmpfs defaults 0 0
改成:
none /dev/shm tmpfs defaults,size=2048m 0 0
size参数也可以用G作单位:size=2G。
重新mount /dev/shm使之生效:
# mount -o remount /dev/shm
或者:
# umount /dev/shm
# mount -a
三:用户和数组
groupadd oinstall
groupadd dba
groupadd oper
groupadd asmadmin
groupadd asmoper
groupadd asmdba
useradd -g oinstall -G asmadmin,asmdba,asmoper,oper,dba grid
设置密码passwd grid
设置环境变量
Vi .bash_profile
ORACLE_SID=+ASM1; export ORACLE_SID
ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE
ORACLE_HOME=/u01/app/grid/product/11.2.0; export ORACLE_HOME
NLS_DATE_FORMAT="yyyy-mm-dd HH24:MI:SS"; export NLS_DATE_FORMAT
THREADS_FLAG=native; export THREADS_FLAG
PATH=$ORACLE_HOME/bin:$PATH; export PATH
THREADS_FLAG=native; export THREADS_FLAG
PATH=$ORACLE_HOME/bin:$PATH; export PATH
if [ $USER = "oracle" ] || [ $USER = "grid" ]; then
if [ $SHELL = "/bin/ksh" ]; then
ulimit -p 16384
ulimit -n 65536
else
ulimit -u 16384 -n 65536
fi
umask 022
fi
建目录
mkdir –p /u01/app/oracle
chown –R grid:oinstall /u01/app/oracle
mkdir –p /u01/app/ oraInventory
chown –R grid:oinstall /u01/app/ oraInventory
mkdir –p /u01/app/grid
chown –R grid:oinstall /u01/app/ grid
四:使用 udev 配置 asm磁盘组
udevadm命令获取分区的信息
前提是用fdisk /dev/s* 分区
/etc/udev/rules.d
在此文件下添加
more 99-oracle-asmdevices.rules
KERNEL=="sdb1", SUBSYSTEM=="block",ATTR{size}=="4192902", ATTR{start}=="63", NAME="asmdisk1-crs", OWNER="grid", GROUP="asmadmin", MOD
E="0660"
KERNEL=="sdc1", SUBSYSTEM=="block",ATTR{size}=="4192902", ATTR{start}=="63", NAME="asmdisk2-data", OWNER="grid", GROUP="asmadmin", MO
DE="0660"
KERNEL=="sdd1", SUBSYSTEM=="block",ATTR{size}=="16771797", ATTR{start}=="63", NAME="asmdisk2-fra", OWNER="grid", GROUP="asmadmin", MO
DE="0660"
udevadm info -a -p /sys/block/sdb/sdb1 启动start_udev start
五:安装grid
检查
./runcluvfy.sh stage -pre crsinst -n Demodb –verbose
安装./runInstaller
注意:oracle_base 和oracle_home 不要在同一个目录下,否则会报错。
-- 没安装asmlib,使用的udev绑定,可以忽略
task resolv.confintegrity -- 这个是因为无法访问设置的DNSip,对安装没影响
执行/root/app/grid/product/11.2.0/root.sh报
compat-libcap1-1.10-1.i686.rpm
ailed to create keys in the OLR, rc = 127, Message:
/u01/app/grid/product/11.2.0/bin/clscfg.bin: error while loading shared libraries: libcap.so.1: cannot open shared object file: No such file or directory
/u01/app/grid/product/11.2.0/crs/install/rootcrs.pl -delete -force -verbose
在重新执行 root。Sh
最后会报[INS-20802] Oracle Cluster Verification Utility failed. 可以忽略。
