REHL8 oracle 19C RAC安装一（环境准备）（更新前）
１.三台虚拟机 虚拟机的配置如下
[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
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)
主机 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
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/*
