本文为19年12月份搭建的环境并亲自安装的整体过程日志,如有疑问,可留言共同探讨。 ORACLE19c--RAC集群安装
第一步:配置/etc/hosts 192.168.1.61xiaosheng61 192.168.1.62xiaosheng62 192.168.10.61xiaosheng61prv 192.168.10.62xiaosheng62prv 192.168.1.63xiaosheng61vip 192.168.1.64xiaosheng62vip 192.168.1.65xiaoshengscan
第二步:关闭SELINIX、防火墙 echo "SELINUX=disabled" > /etc/selinux/config echo "#SELINUXTYPE=targeted " >> /etc/selinux/config setenforce 1systemctl 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 5001oinstall groupadd -g 5002dba groupadd -g 5003asmdba groupadd -g 5004asmoper groupadd -g 5005asmadmin 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 022export 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 022export 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 1cat /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 0mount -a chown -R grid:asmadmin /asm
ASM共享磁盘创建 mkdir -p /asm/oracleasm/disks dd if=/dev/zero of=/asm/oracleasm/disks/asm1 bs=8192k count=1280dd if=/dev/zero of=/asm/oracleasm/disks/asm2 bs=8192k count=1280dd if=/dev/zero of=/asm/oracleasm/disks/asm3 bs=8192k count=1280dd if=/dev/zero of=/asm/oracleasm/disks/asm4 bs=8192k count=1280dd if=/dev/zero of=/asm/oracleasm/disks/asm5 bs=8192k count=1280dd if=/dev/zero of=/asm/oracleasm/disks/asm6 bs=8192k count=128dd if=/dev/zero of=/asm/oracleasm/disks/asm7 bs=8192k count=128chown 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 checkcrs
第九步:Oracle 表空间创建 sqlplus "/assysdba"; create tablespace xiaosheng datafile '+DATA'size 10m;
Oracle 用户创建 create user xiaosheng identified by xiaosheng123 defaulttablespace xiaosheng; grant dba toxiaosheng; 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;
X ORACLE19c的RAC集群部署-详细完整篇
免责声明:文章转载自《X ORACLE19c的RAC集群部署-详细完整篇》仅用于学习参考。如对内容有疑问,请及时联系本站处理。
上篇prometheus监控多个MySQL实例部署自己的聊天系统 DuckChat(鸭信)下篇
宿迁高防,2C2G15M,22元/月;香港BGP,2C5G5M,25元/月 雨云优惠码:MjYwNzM=