REHL8 oracle 19C RAC安装一（环境准备）

１.三台虚拟机　虚拟机的配置如下

  2./etc/hosts 设定,一般情况下用Vｍware 两张网卡就可以了，不过可以用三张网卡

[root@nymtx asm]# cat /etc/hosts
127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4
::1 localhost localhost.localdomain localhost6 localhost6.localdomain6
192.168.1.80 nymtx.inno.com nymtx
192.168.1.88 hzmtx.inno.com hzmtx
10.10.10.80 nymtx-prv.inno.com nymtx-prv
10.10.10.88 hzmtx-prv.inno.com hzmtx-prv
192.168.1.83 nymtx-vip.inno.com nymtx-vip
192.168.1.84 hzmtx-vip.inno.com hzmtx-vip
192.168.1.85 mtx-scan.inno.com mtx-scan
192.168.1.90 cnmtx.inno.com cnmtx

2.关防火墙,三台主机都做

echo "SELINUX=disabled" > /etc/selinux/config
echo "#SELINUXTYPE=targeted " >> /etc/selinux/config
setenforce 1
systemctl stop firewalld.service
systemctl disable firewalld.service

3.禁止NTP 三台主机都做

systemctl stop ntpd
systemctl disabled ntpd
systemctl stop chronyd.service
systemctl disable chronyd.service
rm -f /etc/chrony.conf

4.安装组件(YUM配置请参考https://www.cnblogs.com/tingxin/p/13137951.html)

yum -y install xdpyinfo
yum -y install libnsl
yum -y install autoconf
yum -y install automake
yum -y install binutils
yum -y install binutils-devel
yum -y install bison
yum -y install cpp
yum -y install dos2unix
yum -y install ftp
yum -y install gcc
yum -y install gcc-c++
yum -y install lrzsz
yum -y install python-devel
yum -y install compat-db*
yum -y install compat-gcc-34
yum -y install compat-gcc-34-c++
yum -y install compat-libcap1
yum -y install compat-libstdc++-33
yum -y install compat-libstdc++-33.i686
yum -y install glibc-*
yum -y install glibc-.i686
yum -y install libXpm-.i686
yum -y install libXp.so.6
yum -y install libXt.so.6
yum -y install libXtst.so.6
yum -y install libXext
yum -y install libXext.i686
yum -y install libXtst
yum -y install libXtst.i686
yum -y install libX11
yum -y install libX11.i686
yum -y install libXau
yum -y install libXau.i686
yum -y install libxcb
yum -y install libxcb.i686
yum -y install libXi
yum -y install libXi.i686
yum -y install libXtst
yum -y install libstdc++-docs
yum -y install libgcc_s.so.1
yum -y install libstdc++.i686
yum -y install libstdc++-devel
yum -y install libstdc++-devel.i686
yum -y install libaio
yum -y install libaio.i686
yum -y install libaio-devel
yum -y install libaio-devel.i686
yum -y install ksh
yum -y install libXp
yum -y install libaio-devel
yum -y install numactl
yum -y install numactl-devel
yum -y install make -y
yum -y install sysstat -y
yum -y install unixODBC
yum -y install unixODBC-devel
yum -y install elfutils-libelf-devel
yum -y install redhat-lsb-core
yum -y install bc binutils elfutils-libelf elfutils-libelf-devel fontconfig-devel glibc glibc-devel ksh libaio libaio-devel libXrender libX11 libXau libXi libXtst libgcc libnsl librdmacm libstdc++ libstdc++-devel libxcb libibverbs make smartmontools sysstat

5. 创建用户,在RAC主机上(nymtx,hzmtx)

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,asmdba oracle
echo "oracle" |passwd --stdin grid
echo "oracle" |passwd --stdin oracle

注意gird 和oracle的ID和group信息保持一致，如果共享磁盘用asmdba, 请确保oracle也在asmadm 组中

# id grid
uid=6001(grid) gid=5001(oinstall) 组=5001(oinstall),5003(asmdba),5004(asmoper),5005(asmadmin)
# id oracle
uid=6002(oracle) gid=5001(oinstall) 组=5001(oinstall),5002(dba),5003(asmdba),5005(asmadmin)

如果grid和oracle group不一致用以下命令修正，再用id group 查看

usermod -g oinstall -G dba,asmadmin,asmdba oracle

6.创建目录 在RAC主机上(nymtx,hzmtx)

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

7.设置grid 和oracle 用户环境 在RAC主机上(nymtx,hzmtx)

注意

1. 不同主机grid 用户上的ASM实例ORACE_SID要不一样， 一般用+ASM1， +ASM2,+ASM3, 以此类推

2. 不同主机的oracle用户，ORACLE_SID　可以不一样，但是ORACLE_UNQNAME要保持一致

３.为方便操作，各个主机机上grid和oracle 的ORACLE＿ＨＯＭＥ和ORACLE_BASE路经要保持一致。

主机 nymtx:

su - grid
vi ~/.bash_profile
umask 022
export CV_ASSUME_DISTID=RHEL7.6;export CV_ASSUME_DISTID
export NLS_DATE_FORMAT="YYYY-MM-DD HH24:MI:SS"; export NLS_DATE_FORMAT
export ORACLE_SID=+ASM1
export ORACLE_BASE=/oracle/app/grid
export ORACLE_HOME=/oracle/app/19c/grid
export TNS_ADMIN=$ORACLE_HOME/network/admin;export TNS_ADMIN
export PATH=.:$PATH:$HOME/bin:$ORACLE_HOME/bin

su - oracle
vi ~/.bash_profile
umask 022
export CV_ASSUME_DISTID=RHEL7.6;export CV_ASSUME_DISTID
export NLS_DATE_FORMAT="YYYY-MM-DD HH24:MI:SS"; export NLS_DATE_FORMAT
export ORACLE_BASE=/oracle/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/19c/dbhome_1
export ORACLE_UNQNAME=mtxdb
export ORACLE_SID=mtxdb1
export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK
export TNS_ADMIN=$ORACLE_HOME/network/admin;export TNS_ADMIN
export PATH=.:$PATH:$HOME/bin:$ORACLE_HOME/bin

主机 hzmtx:

su - grid
vi ~/.bash_profile
umask 022
export CV_ASSUME_DISTID=RHEL7.6;export CV_ASSUME_DISTID
export NLS_DATE_FORMAT="YYYY-MM-DD HH24:MI:SS"; export NLS_DATE_FORMAT
export ORACLE_SID=+ASM2
export ORACLE_BASE=/oracle/app/grid
export ORACLE_HOME=/oracle/app/19c/grid
export TNS_ADMIN=$ORACLE_HOME/network/admin;export TNS_ADMIN
export PATH=.:$PATH:$HOME/bin:$ORACLE_HOME/bin

su - oracle
vi ~/.bash_profile
umask 022
export CV_ASSUME_DISTID=RHEL7.6;export CV_ASSUME_DISTID
export NLS_DATE_FORMAT="YYYY-MM-DD HH24:MI:SS"; export NLS_DATE_FORMAT
export ORACLE_BASE=/oracle/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/19c/dbhome_1
export ORACLE_UNQNAME=mtxdb
export ORACLE_SID=mtxdb2
export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK
export TNS_ADMIN=$ORACLE_HOME/network/admin;export TNS_ADMIN
export PATH=.:$PATH:$HOME/bin:$ORACLE_HOME/bin

8.NFS Server 配置 主机 cnmtx

也可用UDEV来设定，详情参考https://www.cnblogs.com/tingxin/p/13177268.html

vi /etc/exports
/asm *(rw,sync,no_wdelay,insecure,no_root_squash)
systemctl restart nfs-server.service
showmount -e
exportfs -v
创建 共享磁盘
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

9.RAC挂载共享磁盘,并设置权限 在RAC主机上(nymtx,hzmtx)

mkdir /asm
vi /etc/fstab
192.168.1.90:/asm /asm nfs rw,bg,hard,nointr,tcp,vers=3,timeo=600,rsize=32768,wsize=32768,actimeo=0 0 0
mount -a
chown -R grid:asmadmin /asm/*
chmod g+s /asm/*