本次为步骤说明,但是也能用,如果需要详细文档的可移步下载链接:
https://download.csdn.net/download/weixin_44167712/12424886
1 准备工作
1.1 软件需求
rpm -q make binutils compat-libcap1 compat-libstdc++ elfutils-libelf elfutils-libelf-devel fontconfig-devel glibc glibc-devel ksh libaio libaio-devel libXll libXi libXau libXtst libXrender libXrender-devel libgcc libstdc++ libstdc++-devel libxcb net-tools nfs-utils smartmontools
配置yum 安装缺失包解决
1.2 网络需求
各节点配置网卡
每个节点至少要有两个网络适配器(网卡)或者是两个网络接口卡(NICs),一个用于公有网络,一个用于私有网络。
在11.2.0.2版本之后,可以使用Redundant Interconnect Usage创建1-4个高可用IP(HAIP),实现节点之间私有网络的高可用和负载均衡。
1.3 划分节点IP(各节点)
[root@racdb1 yum.repos.d]# vi /etc/hosts
127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4
::1 localhost localhost.localdomain localhost6 localhost6.localdomain6
## Public
192.168.0.26 racdb1
192.168.0.27 racdb2
#Virtual IP
192.168.0.28 racdb1vip
192.168.0.29 racdb2vip
#Private IP
10.10.0.202 racdb1pri
10.10.0.203 racdb2pri
#Scan Virtual IP
192.168.0.33 rac-scan
1.4 防火墙和Selinux(各节点)
[root@racdb1 ~]# systemctl stop firewalld.service
[root@racdb1 ~]# systemctl disable firewalld.service
[root@racdb1 ~]# getenforce
[root@racdb1 ~]# vi /etc/selinux/config
[root@racdb1 ~]# vi /etc/selinux/config
SELINUX=disabled
保存重启
1.5 创建组和用户(各节点)
groupadd -g 1022 asmoper
groupadd -g 1020 asmadmin
groupadd -g 1021 asmdba
groupadd -g 1010 oinstall
groupadd -g 1030 dba
groupadd -g 1031 oper
/usr/sbin/useradd -u 1101 -g oinstall -G dba,oper,asmdba,asmoper oracle
echo oracle | passwd --stdin oracle
/usr/sbin/useradd -u 1100 -g oinstall -G asmadmin,asmdba,asmoper,dba grid
echo grid | passwd --stdin grid
1.6 创建安装目录(各节点)
mkdir -p /oracle/app/11.2.0/grid
mkdir -p /oracle/app/grid
mkdir -p /oracle/app/oracle
mkdir -p /oracle/software
chown -R grid:oinstall /oracle
chown oracle:oinstall /oracle/app/oracle
chmod -R 775 /oracle
1.7 配置安装用户的环境变量(各节点)
oracle用户:
racdb1:
export PATH
export ORACLE_BASE=/oracle/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_1
export ORACLE_SID=JYSDB1
export PATH=.:$ORACLE_HOME/bin:$ORACLE_HOME/OPatch:$PATH
[oracle@racdb1 ~]$ . ./.bash_profile
racdb2:
export PATH
export ORACLE_BASE=/oracle/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_1
export ORACLE_SID=JYSDB2
export PATH=.:$ORACLE_HOME/bin:$ORACLE_HOME/OPatch:$PATH
grid用户:
racdb1:
export PATH
export ORACLE_BASE=/oracle/app/grid
export ORACLE_HOME=/oracle/app/11.2.0/grid
export ORACLE_SID=+ASM1
export PATH=.:$ORACLE_HOME/bin:$PATH
racdb2:
export ORACLE_BASE=/oracle/app/grid
export ORACLE_HOME=/oracle/app/11.2.0/grid
export ORACLE_SID=+ASM2
export PATH=.:$ORACLE_HOME/bin:$PATH
~
[root@racdb2 ~]# . ./.bash_profile
1.8 资源限制(各节点)
vi /etc/security/limits.conf
oracle 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
1.9 配置Linux内核参数
vim /etc/sysctl.conf
fs.aio-max-nr = 1048576
fs.file-max = 6815744
kernel.shmall = 131858432
kernel.shmmax = 220200960000
kernel.shmmni = 4096
kernel.sem = 250