ORACLE19c--RAC集群安装
第一步：配置/etc/hosts
192.168.1.61 xiaosheng61
192.168.1.62 xiaosheng62
192.168.10.61 xiaosheng61prv
192.168.10.62 xiaosheng62prv
192.168.1.63 xiaosheng61vip
192.168.1.64 xiaosheng62vip
192.168.1.65 xiaoshengscan
第二步：关闭SELINIX、防火墙
echo "SELINUX=disabled" > /etc/selinux/config
echo "#SELINUXTYPE=targeted " >> /etc/selinux/config
setenforce 1
systemctl stop firewalld.service
systemctl disable firewalld.service
禁止NTP
systemctl stop ntpd
systemctl disabled ntpd
systemctl stop chronyd.service
systemctl disable chronyd.service
rm -f /etc/chrony.conf
第三步：配置yum环境
mkdir /mnt/linux
mount /dev/cdrom /mnt/linux
cd /etc/yum.repos.d
mkdir bk
mv *.repo bk/
echo "[EL]" >> /etc/yum.repos.d/itpux.repo
echo "name =Linux 7.x DVD" >> /etc/yum.repos.d/itpux.repo
echo "baseurl=file:///mnt/linux" >> /etc/yum.repos.d/itpux.repo
echo "gpgcheck=0" >> /etc/yum.repos.d/itpux.repo
echo "enabled=1" >> /etc/yum.repos.d/itpux.repo
cat /etc/yum.repos.d/itpux.repo
准备预先安装的包
cd /mnt/hgfs/soft/
rpm -ivh oracle-database-preinstall-19c-1.0-1.el7.x86_64.rpm
根据提示安装所需要的包：
yum -y install ksh libaio-devel
第四步：创建用户与组
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 grid
passwd 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
第五步：环境变量配置
su - grid
vi ~/.bash_profile
umask 022
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
source ~/.bash_profile
env |grep ORACLE
环境变量配置
su - oracle
vi ~/.bash_profile
umask 022
export ORACLE_BASE=/opt/oracle/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/19c/dbhome_1
export ORACLE_UNQNAME=itpuxdb
export ORACLE_SID=itpuxdb1
export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK
export PATH=.:$PATH:$HOME/bin:$ORACLE_HOME/bin
source ~/.bash_profile
env |grep ORACLE
第六步：配置NFS共享存储IP为192.168.1.70
配置ASM目录
NFS Server配置
vi /etc/exports
/asm *(rw,sync,no_wdelay,insecure,no_root_squash)
systemctl restart nfs-server.service
showmount -e
exportfs -v
echo "SELINUX=disabled" > /etc/selinux/config
echo "#SELINUXTYPE=targeted " >> /etc/selinux/config
setenforce 1
cat /etc/selinux/config
systemctl stop firewalld.service
systemctl disable firewalld.service
RAC主机配置
mkdir /asm
vi /etc/fstab
192.168.1.70:/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
ASM共享磁盘创建
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
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
chmod 664 *
第七步：安装GRID集群软件grid用户
解压文件到grid_home目录
su - grid
cd $ORACLE_HOME
unzip /mnt/hgfs/soft/LINUX.X64_193000_grid_home.zip
root（两台机都装）:
rpm -Uvh /opt/oracle/app/19c/grid/cv/rpm/cvuqdisk*
用虚拟机启动安装grid用户
cd $ORACLE_HOME
./gridSetup.sh
第八步：安装DB集群软件oracle用户
解压文件到oracle_home目录
su - oracle
cd $ORACLE_HOME
unzip /mnt/hgfs/soft/LINUX.X64_193000_db_home.zip
用虚拟机启动安装oracle用户
cd $ORACLE_HOME
./runInstaller
数据库创建oracle用户
dbca
集群的启动与关闭用root用户
/opt/oracle/app/19c/grid/bin/crsctl stop crs
/opt/oracle/app/19c/grid/bin/crsctl start crs
/opt/oracle/app/19c/grid/bin/crsctl check crs
第九步：Oracle 表空间创建
sqlplus "/as sysdba";
create tablespace xiaosheng datafile '+DATA' size 10m;
Oracle 用户创建
create user xiaosheng identified by xiaosheng123 default tablespace xiaosheng;
grant dba to xiaosheng;
conn xiaosheng/xiaosheng123;
create table itpuxt1(id number(12) primary key, name varchar(20)) ;
Oracle 数据插入
insert into itpuxt1 values(1,'xiaosheng01');
insert into itpuxt1 values(2,'xiaosheng02');
commit;
Oracle 数据查询
select * from itpuxt1;