一、硬件信息及配套軟件

1、硬件設置

RAC集群虛擬機：CPU:2C、內存：9G、操作系統：30G、數據庫安裝目錄：100G

數據存儲：50G （10G*5）

共享存儲：2G （1G*2）

2、IP 劃分

主機名	公有地址	私有地址	VIP	共享存儲（SAN）
rac1	192.168.87.131	10.10.10.131	192.168.87.133	192.168.87.129
rac2	192.168.87.132	10.10.10.132	192.168.87.134	192.168.87.129

3、配套軟件

?操作系統：? ? OracleLinux-R7-U9-Server-x86_64-dvd
?數據庫軟件：oracle-database-preinstall-19c-1.0-1.el7.x86_64.rpm?

數據庫集群軟件：LINUX.X64_193000_grid_home.zip

關注以下這三個rpm包

compat-libstdc++-33-3.2.3-71.el7.x86_64.rpm

libaio-devel-0.3.109-13.el7.x86_64.rpm

ksh-20120801-144.0.1.el7_9.x86_64.rpm

二、環境配置

1、主機名設置

主機：192.168.87.131
[root@rac1 ~]# hostnamectl set-hostname rac1???

主機：192.168.87.132
[root@rac2 ~]# hostnamectl set-hostname rac2

主機：192.168.87.129
[root@san ~]# ?hostnamectl set-hostname san

2、主機名及網絡設置

vi /etc/hosts
192.168.87.131 rac1
192.168.87.132 rac2

10.10.10.131 ? rac1prv
10.10.10.132 ? rac2prv

192.168.87.133 rac1vip
192.168.87.134 rac2vip

192.168.87.129 san

3、防火墻及SELINUX設置

關閉selinux
sed -i ?"s/SELINUX=enforcing/SELINUX=disabled/" ?/etc/selinux/config
setenforce 1

關閉防火墻
systemctl ?stop firewalld
systemctl ?disable firewalld

4、進制NTP時鐘服務禁止NTP
systemctl stop ntpd
systemctl disabled ntpd
systemctl stop chronyd.service
systemctl disable chronyd.service
rm -f /etc/chrony.conf

5、安裝相關rpm包

yum install bc gcc gcc-c++ ?binutils ?make gdb cmake ?glibc ksh \
elfutils-libelf elfutils-libelf-devel fontconfig-devel glibc-devel ?\
libaio libaio-devel libXrender libXrender-devel libX11 libXau sysstat \
libXi libXtst libgcc librdmacm-devel libstdc++ libstdc++-devel libxcb \
net-tools nfs-utils compat-libcap1 compat-libstdc++ ?smartmontools ?targetcli \
python python-configshell python-rtslib python-six ?unixODBC unixODBC-devel

推薦安裝以下命令
yum install -y lrzsz
yum install -y rsync
yum install -y telnet
yum install -y vim
yum install -y curl
yum install -y wget
yum install -y openssh-server
yum install -y openssh-clients
yum install -y lsof

三、部署Oracle--19C --RAC集群

1、rac1/rac2 安裝預裝軟件

[root@rac1 opt]# rpm -ivh oracle-database-preinstall-19c-1.0-1.el7.x86_64.rpm?

安裝完畢后會自動創建用戶和組，不建議使用默認的配置

2、rac1/rac2重新創建oracle相關用戶及組

userdel ?-r oracle
userdel ?-r grid?
groupdel oinstall?
groupdel dba

groupadd -g 5001 oinstall
groupadd -g 5002 dba
groupadd -g 5003 asmdba?
groupadd -g 5004 asmoper
groupadd -g 5005 asmadmin
useradd? ?-u 6001 -g oinstall -G asmadmin,asmdba,asmoper grid?
useradd? ?-u 6002 -g oinstall -G dba,asmadmin oracle

passwd?oracle
passwd?grid?

檢查核實用戶

3、rac1/rac2創建oracle相關目錄并賦權

mkdir /opt/oracle
mkdir -p /opt/oracle/app/grid
mkdir -p /opt/oracle/app/19c/grid
chown -R grid:oinstall /opt/oracle

mkdir -p /opt/oracle/app/oraInventory
chown -R grid:oinstall /opt/oracle/app/oraInventory
mkdir -p /opt/oracle/app/oracle/product/19c/dbhome_1?
chown -R oracle:oinstall /opt/oracle/app/oracle?
chmod -R 775 /opt/oracle

4、rac1/rac2設置grid用戶環境變量

?vi ~/.bash_profile?
umask 022

#rac1
export ORACLE_SID=+ASM1

#rac2

export ORACLE_SID=+ASM1
export ORACLE_BASE=/opt/oracle/app/grid
export ORACLE_HOME=/opt/oracle/app/19c/grid?
export PATH=.:$PATH:$HOME/bin:$ORACLE_HOME/bin

5、rac1/rac2設置oracle用戶環境變量

[oracle@rac1 ~]$ vi ~/.bash_profile?

umask 022
export ORACLE_BASE=/opt/oracle/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/19c/dbhome_1
export ORACLE_UNQNAME=rac
export ORACLE_SID=rac1
export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK
export PATH=.:$PATH:$HOME/bin:$ORACLE_HOME/bin

6、ASM共享存儲配置

服務端執行

yum -y install nfs-utils rpcbind

[root@san ~]# vi /etc/exports
/asm *(insecure,rw,no_root_squash,no_all_squash,sync)
[root@san ~]# systemctl restart nfs-server.service
[root@san ~]#?
[root@san ~]# showmount -e
Export list for san:
/asm *
[root@san ~]# exportfs -v
/asm ???????????<world>(sync,wdelay,hide,no_subtree_check,sec=sys,rw,insecure,no_root_squash,no_all_squash)

設置開機自啟動

[root@san ~]# systemctl start rpcbind.service
[root@san ~]# systemctl start nfs-server.service
[root@san ~]# systemctl enable rpcbind.service
[root@san ~]# systemctl enable nfs-server.service

客戶端配置
[root@rac1 opt]# yum -y install nfs-utils rpcbind
[root@rac1 opt]# mount -t nfs 192.168.87.129:/asm /asm
[root@rac2?opt]# mount -t nfs 192.168.87.129:/asm /asm

檢查共享存儲權限

[root@san ~]# ls -ld /asm/
drwxrwxrwx 3 777 root 4096 May 19 20:57 /asm/

配置開機啟動

vi /etc/fstab?
192.168.87.129:/asm nfs defaults 0 0

Linux使用nfs設置共享文件夾_linux配置nfs共享-CSDN博客

NFS共享存儲主機執行
mkdir -p /asm/oracleasm/disks
dd if=/dev/zero of=/asm/oracleasm/disks/asm1 bs=8192k count=1280?
dd if=/dev/zero of=/asm/oracleasm/disks/asm2 bs=8192k count=1280?
dd if=/dev/zero of=/asm/oracleasm/disks/asm3 bs=8192k count=1280?
dd if=/dev/zero of=/asm/oracleasm/disks/asm4 bs=8192k count=1280
dd if=/dev/zero of=/asm/oracleasm/disks/asm5 bs=8192k count=1280?
dd if=/dev/zero of=/asm/oracleasm/disks/asm6 bs=8192k count=128
dd if=/dev/zero of=/asm/oracleasm/disks/asm7 bs=8192k count=128

rac1/rac2 主機執行
chown grid:asmadmin /asm/oracleasm/disks/asm1
chown grid:asmadmin /asm/oracleasm/disks/asm2
chown grid:asmadmin /asm/oracleasm/disks/asm3
chown grid:asmadmin /asm/oracleasm/disks/asm4
chown grid:asmadmin /asm/oracleasm/disks/asm5
chown grid:asmadmin /asm/oracleasm/disks/asm6
chown grid:asmadmin /asm/oracleasm/disks/asm7

檢查權限設置

?[root@san ~]# chmod -R 777 /asm/

7、安裝數據庫集群軟件-grid
?rac1主機解壓?LINUX.X64_193000_grid_home.zip

? [grid@rac1 ~]$ cd $ORACLE_HOME
? [grid@rac1 grid]$ pwd
? /opt/oracle/app/19c/grid

?#需要在頁面執行
?[grid@rac1 ~]$ ./gridSetup.sh