centos 6.5 rac 11.2.0.1 安装
关闭NTPD服务
centos7 以上
/bin/systemctl stop ntpd
systemctl disable ntpd.service
mv /etc/ntp.conf /etc/ntp.conf.original
centos7 以下
chkconfig ntpd off
rm -rf /etc/ntp.conf
关闭其他无用服务
chkconfig autofs off
chkconfig acpid off
chkconfig sendmail off
chkconfig cups-config-daemon off
chkconfig cpus off
chkconfig xfs off
chkconfig lm_sensors off
chkconfig gpm off
chkconfig openibd off
chkconfig pcmcia off
chkconfig cpuspeed off
chkconfig nfslock off
chkconfig ip6tables off
chkconfig iptables off
chkconfig rpcidmapd off
chkconfig apmd off
chkconfig sendmail off
chkconfig arptables_jf off
chkconfig microcode_ctl off
chkconfig rpcgssd off
修改/etc/hosts文件,两节点要保持一致
vim /etc/hosts
#public ip
192.168.213.3 rac1
192.168.213.4 rac2
#priv ip
10.10.10.3 rac1-priv
10.10.10.4 rac2-priv
#vip ip
192.168.213.203 rac1-vip
192.168.213.204 rac2-vip
#scan ip
192.168.213.210 rac-scan
配置yum源(配置库的问题可在我的其他博客查到)
yum install -y binutils* compat-libstdc* elfutils-libelf* gcc* glibc* ksh* libaio* libgcc* libstdc* make* sysstat* unixODBC* libaio-devel* glibc-devel.i686 libaio.i686 libaio-devel.i686 libstdc++-devel.i686 unixODBC-devel.i686 compat-libcap1* compat-libcap1.i686 expat*
系统配置
配置内核参数
vim /etc/sysctl.conf (每行不能有空格)
fs.aio-max-nr = 1048576
fs.file-max = 6815744
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
配置用户限制
vim /etc/security/limits.conforacle soft nproc 2047
oracle hard nproc 16384
oracle soft nofile 1024
oracle hard nofile 65536
oracle soft stack 10240
grid soft nproc 2047
grid hard nproc 16384
grid soft nofile 1024
grid hard nofile 65536
grid soft stack 10240
创建用户并创建数据库目录即授予权限
创建组和用户
groupadd oinstall
groupadd dba
groupadd oper
groupadd asmdba
groupadd asmoper
groupadd asmadmin
useradd -g oinstall -G dba,oper,asmdba oracle
useradd -g oinstall -G asmdba,dba,asmadmin,asmoper gridpasswd grid
passwd oracle
创建目录
mkdir /u01
mkdir /u01/grid
mkdir /u01/oracle
mkdir /u01/gridbase
chown -R grid:oinstall /u01
chown -R oracle:oinstall /u01/oracle
chmod -R g+w /u01
修改用户概要文件
grid 用户
vim /home/grid/.bash_profile
ORACLE_BASE=/u01/gridbase
ORACLE_HOME=/u01/grid
PATH=$ORACLE_HOME/bin:$PATH
LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH
export ORACLE_BASE ORACLE_HOME PATH LD_LIBRARY_PATH DISPLAY
export LANG=en_US
export NLS_DATE_FORMAT="yyyy-mm-dd HH24:MI:SS"
umask 022
oracle用户
vim /home/oracle/.bash_profile
--rac1
ORACLE_BASE=/u01/oracle
ORACLE_HOME=/u01/oracle/db
ORACLE_SID=rac1
PATH=$ORACLE_HOME/bin:$PATH
LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH
export LANG=en_US
export NLS_DATE_FORMAT="yyyy-mm-dd HH24:MI:SS"
umask 022
--rac2
ORACLE_BASE=/u01/oracle
ORACLE_HOME=/u01/oracle/db
ORACLE_SID=rac2
PATH=$ORACLE_HOME/bin:$PATH
LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH
export LANG=en_US
export NLS_DATE_FORMAT="yyyy-mm-dd HH24:MI:SS"
umask 022
使文件生效
export ORACLE_BASE ORACLE_HOME ORACLE_SID PATH LD_LIBRARY_PATH
source /home/oracle/.bash_profile
source /home/grid/.bash_profile
配置用户通信
grid 和 oracle 两个用户都需执行
ssh-****** -t rsa [这里一路回车就可以了]
cat ~/.ssh/id_rsa.pub >> ~/.ssh/authorized_keys
ssh rac2 cat ~/.ssh/id_rsa.pub >> ~/.ssh/authorized_keys 【可能会有提示选择yes/no ,请选择yes】
ssh rac1 cat ~/.ssh/id_rsa.pub >> ~/.ssh/authorized_keys 【可能会有提示选择yes/no ,请选择yes】
配置udev(asm使用)
新增共享磁盘
vmware-vdiskmanager.exe -c -s 30GB -a lsilogic -t 2 "F:\share\sharedisk01.vmdk"
fdisk分区(只需rac1)
配置,两节点都要
vi /etc/udev/rules.d/60-raw.rules
ACTION=="add", KERNEL=="sdb1",RUN+="/bin/raw /dev/raw/raw1 %M %m"
ACTION=="add", KERNEL=="sdb2",RUN+="/bin/raw /dev/raw/raw2 %M %m"
ACTION=="add", KERNEL=="raw*",OWNER="grid", GROUP="dba", MODE="660"
启动并查看是否成功配置
start_udev(rac2 需先 partprobe 再 start_udev)
raw -qa
ll /dev/raw/raw*
安装grid
unzip /u01/linux.x64_11gR2_grid.zip -d /u01
chown -R grid:oinstall /u01/grid
执行预检查及安装
./runcluvfy.sh stage -pre crsinst -n rac1,rac2 -fixup -verbose
问题
1.PRVG-10467 : The default Oracle Inventory group could not be determined 忽略
2.PRVG-10048(rac 12会出现):DNS 在不配置DNS服务器时,可忽略
3.PRVF-4190 :空格问题
4.PRVF-7530:节点“ rac1”上没有足够的物理内存 可忽略
5.linux修改semmni 修改完还是0 可忽略
6.i386和 pdksh-5.2.14 忽略
7.root.sh报错
执行脚本回滚root.sh操作
[[email protected] ~]# /u01/11.2.0/grid/crs/install/roothas.pl -deconfig -force -verbose
开启2个会话,在出现“Adding daemon to inittab”时,同步操作dd命令(直到成功执行为止))
[[email protected] ~]# dd if=/var/tmp/.oracle/npohasd of=/dev/nullbs=1024 count=1
安装
./runInstaller -jreLoc /etc/alternatives/jre_1.8.0
安装结束及查看
安装最后会报错,因为我们忽略了一些检查错误,没有问题
用 crs_stat -t 查看进程
发现 oc4j以及gsd服务都处于offline状态,这是Oracle 11g RAC默认情形,安装成功!