ORACLE_RAC_18C_INSTALL_ON_LINUX7.4

VMWARE虚拟机上安装ORACLERAC18CFOROEL7.4_X64部署日期：2018年7月30日本文档旨在记录最新ORACLEDATABASE18CRAC在ORACLELINUX7.4上的安装过程，仅供ORACLE数据库爱好者交流学习，请勿参照该步骤在生产环境中进行搭建。各位在练习及测试过程中，如有任何问题欢迎与作者进行联系、交流作者网名：阳光咖啡QQ:56235032暗号（18CRAC）微信请扫码暗号（18CRAC）作者背景：就职于大型国有集团企业IT部门，资深ORACLEDBA，负责集团企业数据中心的建设及运维工作，为企业核心系统提供基础架构技术支持。10年数据库管理经验，取得ORACLEOCM认证，精通基于oracle数据库的企业级应用。12年企业级数据中心运维经验，精通企业级数据中心基础架构。6年vmware虚拟化环境管理经验。精通企业级数据备份、冗灾结构，具备数据中心双活解决方案设计能力。多年数据中心运维团队管理能力，带领团队进行数据中心运维管理。具备JAVA开发背景，有基于MVC架构的strus、jsp开发经验。熟悉LINUX，熟悉LINUX服务器的部署及维护。、熟悉数据高端存储设备及存储资源池管理，SAN管理，FC交换机管理。熟悉X86架构服务器运维。熟悉IT供应商管理、辅助制定公司IT流程体系。管理公司运维团队，实现年度目标，上下层协调。一、规划Host01Hostname:rac01Eth0:192.168.233.131Eth1:10.0.0.131Host02Hostname:rac02Eth0:192.168.233.132Eth1:10.0.0.132ClusterName:rac-clusterSCANName:rac-scanSCANIP:192.168.233.3二、文本方式安装ORACLE_LINUX7.4安装界面按ESC输入linuxtestMINI安装具体过程略。三、关闭防火墙systemctlstopfirewalldsystemctldisablefirewalld四、关闭SELINUX特性setenforce0五、安装所需要的软件包yuminstalloracle-database-server-12cR2-preinstall六、为ASM配置块设备关于VMWARE添加共享快设备，网络文档很多，请自行百度cat/etc/udev/rules.d/99-oracle-asmdevices.rulesKERNEL==sd*,ENV{DEVTYPE}==disk,SUBSYSTEM==block,PROGRAM==/usr/lib/udev/scsi_id-g-u-d$devnode,RESULT==36000c2982c9448f293a7fd76df42450e,RUN+=/bin/sh-c'mknod/dev/asm-data01b$major$minor;chowngrid:asmadmin/dev/asm-data01;chmod0660/dev/asm-data01'KERNEL==sd*,ENV{DEVTYPE}==disk,SUBSYSTEM==block,PROGRAM==/usr/lib/udev/scsi_id-g-u-d$devnode,RESULT==36000c29547ece3a7d24f85c34465282b,RUN+=/bin/sh-c'mknod/dev/asm-data02b$major$minor;chowngrid:asmadmin/dev/asm-data02;chmod0660/dev/asm-data02'KERNEL==sd*,ENV{DEVTYPE}==disk,SUBSYSTEM==block,PROGRAM==/usr/lib/udev/scsi_id-g-u-d$devnode,RESULT==36000c2907f5e54735d4d9439c7613f84,RUN+=/bin/sh-c'mknod/dev/asm-data03b$major$minor;chowngrid:asmadmin/dev/asm-data03;chmod0660/dev/asm-data03'KERNEL==sd*,ENV{DEVTYPE}==disk,SUBSYSTEM==block,PROGRAM==/usr/lib/udev/scsi_id-g-u-d$devnode,RESULT==36000c2987b131e468e01239cac9d91c0,RUN+=/bin/sh-c'mknod/dev/asm-mgmtb$major$minor;chowngrid:asmadmin/dev/asm-mgmt;chmod0660/dev/asm-mgmt/sbin/udevadmtrigger--type=devices--action=change/sbin/udevadmcontrol--reload七、修改主机名称hostnamerac01hostnamerac02八、配置HOSTS文件[root@localhost~]#cat/etc/hosts127.0.0.1localhostlocalhost.localdomainlocalhost4localhost4.localdomain4::1localhostlocalhost.localdomainlocalhost6localhost6.localdomain6#public192.168.233.131rac01192.168.233.132rac02#private10.0.0.131rac01-priv10.0.0.132rac02-priv#virtual192.168.233.31rac01-vip192.168.233.32rac02-vip#clusternameandscan192.168.233.3rac-clusterrac-scan九、添加必要的组和用户groupadd-g54344asmadmingroupadd-g54345asmdbagroupadd-g54346asmoperuseradd-goinstall-Gasmadmin,asmdba,asmopergridusermod-goinstall-Gdba,asmdbaoracle十、创建DB及GI的安装目录mkdir-p/u01/app/oracle/product/18.0.0/dbhome_1mkdir-p/u01/app/grid/18.0.0/gridchown-Roracle:oinstall/u01/app/oraclechown-Rgrid:oinstall/u01/app/grid十一、设置oracle及grid用户密码[root@rac01~]#passwdoracle[root@rac01~]#passwdgrid十二、准备home目录18C开始，官网已不在发布ISO安装镜像，DB及GI都以home.zip的方式进行提供。请自行到官网进行下载，并解压到相应的home目录即可。本环境中home目录如下ORACLE_HOME=/u01/app/oracle/product/18.0.0/dbhome_1GRID_HOME=p/u01/app/grid/18.0.0/grid十三、安装GridInfrastructure[grid@rac01grid]$./gridSetup.sh十四、安装数据库服务器软件[oracle@rac01dbhome_1]$./runInstaller十五、创建数据磁盘组[grid@rac01~]$asmca十六、创建CDB数据库[oracle@rac01bin]$./dbca[grid@rac01~]$crsctlstatusres-t--------------------------------------------------------------------------------NameTargetStateServerStatedetails--------------------------------------------------------------------------------LocalResources--------------------------------------------------------------------------------ora.ASMNET1LSNR_ASM.lsnrONLINEONLINErac01STABLEONLINEONLINErac02STABLEora.DATA.dgONLINEONLINErac01STABLEONLINEONLINErac02STABLEora.LISTENER.lsnrONLINEONLINErac01STABLEONLINEONLINErac02STABLEora.MGMT.GHCHKPT.advmOFFLINEOFFLINErac01STABLEOFFLINEOFFLINErac02STABLEora.MGMT.dgONLINEONLINErac01STABLEONLINEONLINErac02STABLEora.OCR.dgONLINEONLINErac01STABLEONLINEONLINErac02STABLEora.chadONLINEONLINErac01STABLEONLINEONLINErac02STABLEora.helperOFFLINEOFFLINErac01IDLE,STABLEOFFLINEOFFLINErac02IDLE,STABLEora.mgmt.ghchkpt.acfsOFFLINEOFFLINErac01STABLEOFFLINEOFFLINErac02STABLEora.net1.networkONLINEONLINErac01STABLEONLINEONLINErac02STABLEora.onsONLINEONLINErac01STABLEONLINEONLINErac02STABLEora.proxy_advmONLINEONLINErac01STABLEONLINEONLINErac02STABLE--------------------------------------------------------------------------------ClusterResources--------------------------------------------------------------------------------ora.LISTENER_SCAN1.lsnr1ONLINEONLINErac02STABLEora.MGMTLSNR1ONLINEONLINErac0210.0.0.132,STABLEora.asm1ONLINEONLINErac01Started,STABLE2ONLINEONLINErac02Started,STABLE3OFFLINEOFFLINESTABLEora.cdb.db1ONLINEONLINErac01Open,HOME=/u01/app/oracle/product/18.0.0/dbhome_1,STABLE2ONLINEONLINErac02Open,HOME=/u01/app/oracle/product/18.0.0/dbhome_1,STABLEora.cvu1ONLINEONLINErac02STABLEora.mgmtdb1ONLINEONLINErac02Open,STABLEora.qosmserver1ONLINEONLINErac02STABLEora.rac01.vip1ONLINEONLINErac01STABLEora.rac02.vip1ONLINEONLINErac02STA