Linux 系统部署 oracle RAC 集群一以NFS做数据库共享存储，环境配置，grid部署 20200522

太过爱你忘了你带给我的痛 2023-02-11 10:13 4阅读 0赞

\#硬件

NFS共享服务器

oracle节点 两台，单网卡（要求双网卡，我这里只有单网卡，虚拟一个网卡用于oracle集群心跳私有网卡）

\#环境：

Linux redhat6.9  64位系统

oracle 11.2.1.0   64位包（64位系统装32位会各种问题，建议和系统相同）

oracle grid 11.2.1.0  64位包

\#建议用oracle linux系统，问题会少很多

\#redhat6.9更换oracle  UEK内核

见文章

[https://blog.csdn.net/zhangbaoxiang/article/details/106353943][https_blog.csdn.net_zhangbaoxiang_article_details_106353943]

\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#IP规划\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#

\#public ip  
10.242.175.5   rac1  
10.242.175.17  rac2

\#priv ip  
10.10.10.11   rac1-priv  
10.10.10.12   rac2-priv

\#vip  
10.242.175.28   rac1-vip  
10.242.175.29   rac2-vip

\#scan  
10.242.175.30  rac-scan

\#nfs  
10.242.175.24  nfs1

\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#搭建NFS文件共享\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#

\#创建共享目录  
mkdir  /oracleRAC/shared\_config               
mkdir /oracleRAC/shared\_grid                   
mkdir /oracleRAC/shared\_home               
mkdir /oracleRAC/shared\_data

\#NFS划分共享权限  
vim /etc/exports

\#oracle RAC data

/oracleRAC/shared\_config               \*(rw,sync,no\_wdelay,insecure\_locks,no\_root\_squash)  
/oracleRAC/shared\_grid                 \*(rw,sync,no\_wdelay,insecure\_locks,no\_root\_squash)  
/oracleRAC/shared\_home                 \*(rw,sync,no\_wdelay,insecure\_locks,no\_root\_squash)  
/oracleRAC/shared\_data                 \*(rw,sync,no\_wdelay,insecure\_locks,no\_root\_squash)

\#生效  
exportfs -rv

\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#部署oracle  grid\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#

\#环境设置\#\#\#\#\#\#\#\#\#\#\#\#

\#修改语言环境  
\#root用户下  
DISPLAY=:1.0  
xhost +  
su - oracle  
\#切换语言  
export LANG=en\_US.UTF-8

\#或更新系统字体  
mkdir -p /usr/share/fonts/zh\_CN/TrueTypecp  
cp  zysong.ttf /usr/share/fonts/zh\_CN/TrueType/

字体包：

[https://download.csdn.net/download/zhangbaoxiang/12431816][https_download.csdn.net_download_zhangbaoxiang_12431816]

\#安装依赖包（后续整理上传）  
安装package里包  
安装pkg  pkg2  pkg3里包  
安装rpm -ivh cvuqdisk-1.0.7-1.rpm

yum install oracleasm-support oracleasmlib oracleasm-\`uname -r\`

\#创建用户

groupadd -g 1000 oinstall  
groupadd -g 1200 dba  
useradd -u 1100 -g oinstall -G dba oracle  
passwd oracle

\#内核参数  
vim /etc/sysctl.conf

fs.aio-max-nr = 1048576  
fs.file-max = 6815744  
kernel.shmall = 2097152  
kernel.shmmax = 1054504960  
kernel.shmmni = 4096  
\# semaphores: semmsl, semmns, semopm, semmni  
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

\#使能  
/sbin/sysctl -p

\#限制调整  
vim  /etc/security/limits.conf

oracle               soft    nproc   2047  
oracle               hard    nproc   16384  
oracle               soft    nofile  1024  
oracle               hard    nofile  65536

\#登录设置（这里谨慎操作，搭建telnet避免远程服务器无法登录）  
vim /etc/pam.d/login

session    required     pam\_limits.so

\#创建安装目录调整权限  
mkdir -p /u01/app/11.2.0/grid  
mkdir -p /u01/app/oracle/product/11.2.0/db\_1  
mkdir -p /u01/oradata  
mkdir -p /u01/shared\_config  
chown -R oracle:oinstall /u01  
chmod -R 775 /u01/

\#修改分区表  
cp /etc/fstab /etc/fstab.bak

nfs1:/oracleRAC/shared\_config /u01/shared\_config  nfs  rw,bg,hard,nointr,tcp,vers=3,timeo=600,rsize=32768,wsize=32768,actimeo=0,nolock 0 0  
nfs1:/oracleRAC/shared\_grid   /u01/app/11.2.0/grid  nfs  rw,bg,hard,nointr,tcp,vers=3,timeo=600,rsize=32768,wsize=32768,actimeo=0,nolock 0 0  
nfs1:/oracleRAC/shared\_home   /u01/app/oracle/product/11.2.0/db\_1  nfs  rw,bg,hard,nointr,tcp,vers=3,timeo=600,rsize=32768,wsize=32768,actimeo=0,nolock 0 0  
nfs1:/oracleRAC/shared\_data   /u01/oradata  nfs  rw,bg,hard,nointr,tcp,vers=3,timeo=600,rsize=32768,wsize=32768,actimeo=0,nolock 0 0

\#挂载NFS分区  
mount /u01/shared\_config  
mount /u01/app/11.2.0/grid  
mount /u01/app/oracle/product/11.2.0/db\_1  
mount /u01/oradata

\#修改目录权限,挂载后再次确认权限，这里常出问题导致集群安装失败  
chown -R oracle:oinstall /u01/shared\_config  
chown -R oracle:oinstall /u01/app/11.2.0/grid  
chown -R oracle:oinstall /u01/app/oracle/product/11.2.0/db\_1  
chown -R oracle:oinstall /u01/oradata

\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#环境变量\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#  
\#oracle环境变量，登录oracle  
vim  /home/oracle/.bash\_profile

\# Oracle Settings  
TMP=/tmp; export TMP  
TMPDIR=$TMP; export TMPDIR

ORACLE\_HOSTNAME=rac1; export ORACLE\_HOSTNAME  
ORACLE\_UNQNAME=orcl; export ORACLE\_UNQNAME  
ORACLE\_BASE=/u01/app/oracle; export ORACLE\_BASE  
GRID\_HOME=/u01/app/11.2.0/grid; export GRID\_HOME  
DB\_HOME=$ORACLE\_BASE/product/11.2.0/db\_1; export DB\_HOME  
ORACLE\_HOME=$DB\_HOME; export ORACLE\_HOME  
ORACLE\_SID=orcl1; export ORACLE\_SID  
ORACLE\_TERM=xterm; export ORACLE\_TERM  
BASE\_PATH=/usr/sbin:$PATH; export BASE\_PATH  
PATH=$ORACLE\_HOME/bin:$BASE\_PATH; export PATH

LD\_LIBRARY\_PATH=$ORACLE\_HOME/lib:/lib:/usr/lib; export LD\_LIBRARY\_PATH  
CLASSPATH=$ORACLE\_HOME/JRE:$ORACLE\_HOME/jlib:$ORACLE\_HOME/rdbms/jlib; export CLASSPATH

alias grid\_env='. /home/oracle/grid\_env'  
alias db\_env='. /home/oracle/db\_env'

\#创建文件  
vim /home/oracle/grid\_env

ORACLE\_HOME=$GRID\_HOME; export ORACLE\_HOME  
PATH=$ORACLE\_HOME/bin:$BASE\_PATH; export PATH

LD\_LIBRARY\_PATH=$ORACLE\_HOME/lib:/lib:/usr/lib; export LD\_LIBRARY\_PATH  
CLASSPATH=$ORACLE\_HOME/JRE:$ORACLE\_HOME/jlib:$ORACLE\_HOME/rdbms/jlib; export CLASSPATH

\#创建文件2

vim  /home/oracle/db\_env

ORACLE\_SID=orcl1; export ORACLE\_SID  
ORACLE\_HOME=$DB\_HOME; export ORACLE\_HOME  
PATH=$ORACLE\_HOME/bin:$BASE\_PATH; export PATH

LD\_LIBRARY\_PATH=$ORACLE\_HOME/lib:/lib:/usr/lib; export LD\_LIBRARY\_PATH  
CLASSPATH=$ORACLE\_HOME/JRE:$ORACLE\_HOME/jlib:$ORACLE\_HOME/rdbms/jlib; export CLASSPATH

\#验证环境变量  
cd /home/oracle  
chown oracle:oinstall db\_env grid\_env  
source  /home/oracle/.bash\_profile   
grid\_env  
echo $ORACLE\_HOME  
db\_env  
echo $ORACLE\_HOME  
\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#  
shutdown -r now 重启  
\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#

\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#安装\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#  
\#以oracle用户身份登录rac1并启动Oracle installe

图呢？我这3000块的电脑一点坑，没钱换，后面有时间重装上图

。

\#\#最后完成脚本  
/u01/app/oraInventory/orainstRoot.sh

/u01/app/11.2.0/grid/root.sh

\#\#验证  
/u01/app/11.2.0/grid/bin/crsctl check cluster -all

三项都正常

\#\#交换分区  没调整

\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#

\#常见问题

\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#  
\#oracle BUG  
CRS-4124: Oracle High Availability Services startup failed  
\#解决：  
\#删除配置，重新执行root.sh  
/u01/app/11.2.0/grid/crs/install/roothas.pl -deconfig -force -verbose

\#\#这里要等oracle生成了相应文件执行会成功，不成功再继续执行  
/bin/dd if=/var/tmp/.oracle/npohasd of=/dev/null bs=1024 count=1  
或者  
chown root:oinstall /var/tmp/.oracle/npohasd

\#\#\#\#\#问题处理参考  
http://blog.sina.com.cn/s/blog\_563c17780102ux53.html  
http://blog.itpub.net/25133597/viewspace-1058569/  
\#\#\#\#\#

\#执行脚本很长时间后，报错Timed out waiting for the CRS stack to start.  
原因和防火墙，时间，SELINUX，网卡类型有关，网卡名称也要一样  
iptables -nL  
getenforce  
setenforce 0  
service ntpd status  
ip a

\#解决

检查两网卡是否正常，只有一个网卡安装也不报错，会无法启动服务，用于oracle私有网卡必须有

\#安装完成最后报错一项，和提示安装失败

验证的三项都正常即可

\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#

后面网络正常再传依赖包，是6.9系统的oracle依赖包

\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#

下一篇：Linux 系统部署 oracle RAC 集群 二 安装oracle 20200526

[https_blog.csdn.net_zhangbaoxiang_article_details_106353943]: https://blog.csdn.net/zhangbaoxiang/article/details/106353943
[https_download.csdn.net_download_zhangbaoxiang_12431816]: https://download.csdn.net/download/zhangbaoxiang/12431816