[新手教程]ORACLE19c的RAC集群部署-详细完整篇

ronpris
ronpris
ronpris
253
文章
1
评论
2020年3月21日11:47:20 评论 1,552 4346字阅读14分29秒
本文为19年12月份搭建的环境并亲自安装的整体过程日志,如有疑问,可留言共同探讨。

 

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;
继续阅读
[推荐]Linux一键部署Oracle11g安装环境脚本 原创推荐

[推荐]Linux一键部署Oracle11g安装环境脚本

本篇主要介绍oracle环境部署的准备工作,主要包括oracle11g依赖包安装、用户和组创建、内核参数配置、配置资源配置,环境变量配置等,具有一定的参考借鉴价值,需要的朋友可以作为参考,也可进行部署...