CentOS 7.8 Oracle 19C RAC安装部署

CentOS 7.8 Oracle 19C RAC 安装部署

一、 操作系统参数设置

规划

IP 地址 主机名 用途 备注

200.144.4.6 noarac1 public ip

200.144.4.7 noarac2

200.144.4.8 noarac1-vip virtual ip

200.144.4.9 noarac2-vip

#public ip

200.144.4.6 noarac1

200.144.4.7 noarac2

#virtual ip

200.144.4.8 noarac1-vip

200.144.4.9 noarac2-vip

#scan ip

200.144.4.10 noarac-scan

#private ip

10.0.0.1 noarac1-priv

200.144.4.8 noarac1-vip

200.144.4.9 noarac2-vip

#scan ip

200.144.4.10 noarac-scan

#private ip

10.0.0.1 noarac1-priv

10.0.0.2 noarac2-priv

2. 关闭防火墙（分别在两台主机的 root 用户下操作）

systemctl stop !rewalld

systemctl disable !rewalld

systemctl stop avahi-daemon.service

systemctl disable avahi-daemon.service

4. 创建用户并设置环境变量（分别在两台主机的 root 用户下操作）

## 创建 oracle 用户及组并修改用户密码：

groupadd -g 54321 oinstall

groupadd -g 54322 dba

groupadd -g 54323 oper

groupadd -g 54324 backupdba

groupadd -g 54325 dgdba

groupadd -g 54326 kmdba

dba,asmdba,backupdba,dgdba,kmdba,racdba,oper oracle

useradd -u 54322 -g oinstall -G asmadmin,asmdba,asmoper,dba grid

echo 123456 | passwd --stdin oracle

echo 123456 | passwd --stdin grid

## oracle 用户密码设置为 123456

各节点创建安装目录并赋权(root 用户)：

mkdir -p /u01/app/19.3.0/grid

mkdir -p /u01/app/grid

mkdir -p /u01/app/oracle

chown -R grid:oinstall /u01

vi /etc/sysctl.conf

vm.dirty_writeback_centisecs = 100

kernel.shmall = 1073741824

kernel.shmmax = 4398046511104

kernel.panic_on_oops = 1

net.core.rmem_default = 262144

net.core.rmem_max = 4194304

net.core.wmem_default = 262144

net.core.wmem_max = 1048576

net.ipv4.conf.all.rp_!lter = 2

net.ipv4.conf.default.rp_!lter = 2

fs.aio-max-nr = 1048576

net.ipv4.ip_local_port_range = 9000 65500

oracle hard stack 32768

oracle hard memlock 237214580

oracle soft memlock 237214580

oracle soft data unlimited

oracle hard data unlimited

grid soft no!le 1024

grid hard no!le 65536

grid soft nproc 16384

grid hard nproc 16384

grid soft stack 10240

grid hard stack 32768

grid hard memlock 237214580

grid hard data unlimited

vi /etc/pro!le.d/oracle-grid.sh

if [ $USER = "oracle" ]; then

ulimit -u 16384 -n 65536

if [ $SHELL = "/bin/ksh" ]; then

ulimit -u 16384

ulimit -n 65536

else

ulimit -u 16384 -n 65536

!

!

6. 操作系统依赖包安装

yum install -y libstdc binutils compat-libstdc++ elfutils-libelf elfutils-libelf-

devel glibc glibc-common glibc-devel gcc gcc-c++ libaio libaio-devel libgcc

libstdc++ libstdc++-devel make sysstat unixODBC unixODBC-devel libXp

su – oracle

vi /home/oracle/.bash_pro!le

export ORACLE_BASE=/u01/app/oracle

export ORACLE_HOME=/u01/app/oracle/product/19.3.0/dbhome_1

export ORACLE_SID=noadb1

export TNS_ADMIN=$ORACLE_HOME/network/admin

export ORACLE_TERM=xterm

export NLS_LANG=AMERICAN_AMERICA.AL32UTF8

export PATH=/usr/sbin:$PATH

export PATH=$ORACLE_HOME/bin:$PATH

export

export CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:

export TMP=/tmp

export TMPDIR=/tmp

export ORACLE_SID=+ASM1

export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib

su – oracle

vi /home/oracle/.bash_pro!le

export ORACLE_BASE=/u01/app/oracle

export ORACLE_HOME=/u01/app/oracle/product/19.3.0/dbhome_1

export ORACLE_SID=noadb2

export TNS_ADMIN=$ORACLE_HOME/network/admin

export ORACLE_TERM=xterm

export NLS_LANG=AMERICAN_AMERICA.AL32UTF8

export PATH=/usr/sbin:$PATH

export TMP=/tmp

export TMPDIR=/tmp

su - grid

vi /home/grid/.bash_pro!le

export ORACLE_SID=+ASM2

export ORACLE_BASE=/u01/app/grid

export ORACLE_HOME=/u01/app/19.3.0/grid

export PATH=$ORACLE_HOME/bin:$PATH

export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib