部署 Oracle Grid InfrastructureOracle RAC

部署 Oracle Grid InfrastructureOracle RAC 数据库涉及在无提示或 GUI 模式下配置 Oracle Automatic Storage Management (Oracle ASM) 磁盘、在无提示或 GUI 模式下安装 Oracle Grid Infrastructure 、重新引导 Oracle Clusterware 、安装 Oracle RAC 数据库软件、创建 Oracle RAC 数据库以及验证部署。

以下步骤介绍了如何在私有云一体机系统中部署 Oracle Grid InfrastructureOracle RAC
  1. 使用 asmcmdasmlib 为磁盘添加标签。例如:GI_HOME/bin/asmcmd afd_label diskgroup_name disk_with_full_path --init。有关详细信息,请参阅 Oracle Grid Infrastructure 安装指南
    /u01/app/21.0.0/grid/bin/asmcmd afd_label OCR /dev/sdc ––init
    
  2. 创建响应文件。您可以在 GI_Home/install/response 中使用示例响应文件并添加变量值。
  3. 在无提示模式下安装 Oracle Grid Infrastructure 。例如:GI_HOME/gridSetup.sh -silent -responseFile responsefile_name_with_full_path.
    /u01/app/21.0.0/grid/gridSetup.sh -silent -responseFile /home/oracle/gridsetup.rsp
  4. 设置环境变量 HAIP_UNSUPPORTED=TRUE
    Oracle Private Cloud Appliance X9-2 机架使用 IP 范围 169.254.0.0/16 与引导卷和块存储卷、实例元数据和其他服务的 iSCSI 连接。这会影响专用网络使用的 HAIP 通信,导致 Oracle Grid Infrastructure 安装失败。要成功进行 HAIP 通信,需要设置此环境变量。
    $ export HAIP_UNSUPPORTED=TRUE
  5. 在每个节点上执行 ./root.sh 命令。
    $ ./root.sh
  6. 使用群集验证实用程序 Cluvfy 验证安装后。例如:GI_HOME/bin/cluvfy -post crsinst -n node1, node2
    u01/app/21.0.0/grid/bin/cluvfy -post crsinst -n racvm1,racvm2
  7. 使用 crsctl 命令检查 Oracle Clusterware 资源。
    [oracle@racvm1 ~]$ crsctl stat res -t 
    --------------------------------------------------------------------------------
    Name Target State Server State details 
    --------------------------------------------------------------------------------
    Local Resources
    --------------------------------------------------------------------------------
    ora.LISTENER.lsnr
     ONLINE ONLINE racvm1 STABLE
     ONLINE ONLINE racvm2 STABLE
    ora.chad
     ONLINE ONLINE racvm1 STABLE
     ONLINE ONLINE racvm2 STABLE
    ora.net1.network
     ONLINE ONLINE racvm1 STABLE
     ONLINE ONLINE racvm2 STABLE
    ora.ons
     ONLINE ONLINE racvm1 STABLE
     ONLINE ONLINE racvm2 STABLE
    --------------------------------------------------------------------------------
    Cluster Resources
    --------------------------------------------------------------------------------
    ora.ASMNET1LSNR_ASM.lsnr(ora.asmgroup)
     1 ONLINE ONLINE racvm1 STABLE
     2 ONLINE ONLINE racvm2 STABLE
    ora.DATA.dg(ora.asmgroup)
     1 ONLINE ONLINE racvm1 STABLE
     2 ONLINE ONLINE racvm2 STABLE
    ora.LISTENER_SCAN1.lsnr
     1 ONLINE ONLINE racvm2 STABLE
    ora.LISTENER_SCAN2.lsnr
     1 ONLINE ONLINE racvm2 STABLE
    ora.LISTENER_SCAN3.lsnr
     1 ONLINE ONLINE racvm1 STABLE
    ora.asm(ora.asmgroup)
     1 ONLINE ONLINE racvm1 STABLE
     2 ONLINE ONLINE racvm2 Started,STABLE
    ora.asmnet1.asmnetwork(ora.asmgroup)
     1 ONLINE ONLINE racvm1 STABLE
     2 ONLINE ONLINE racvm2 STABLE
    ora.cdp1.cdp
     1 ONLINE ONLINE racvm2 STABLE
    ora.cdp2.cdp
     1 ONLINE ONLINE racvm2 STABLE
    ora.cdp3.cdp
     1 ONLINE ONLINE racvm1 STABLE
    ora.cvu
     1 ONLINE ONLINE racvm2 STABLE
    ora.qosmserver
     1 ONLINE ONLINE racvm2 STABLE
    ora.racvm1.vip
     1 ONLINE ONLINE racvm1 STABLE
    ora.racvm2.vip
     1 ONLINE ONLINE racvm2 STABLE
    ora.scan1.vip
     1 ONLINE ONLINE racvm2 STABLE
    ora.scan2.vip
     1 ONLINE ONLINE racvm2 STABLE
    ora.scan3.vip
     1 ONLINE ONLINE racvm1 STABLE
    --------------------------------------------------------------------------------
    [oracle@racvm1 ~]$ 
  8. runInstaller 用作 RDBMS 用户,以无提示模式或 GUI 模式安装 Oracle RAC 数据库软件。有关详细信息,请参阅 Oracle Real Application Clusters 安装指南
    无提示模式示例:RDBMS_HOME/runInstaller -silent -responseFile response_file_name_with_full_path.
    /u01/app/oracle/product/21.0.0/dbhome_1/runInstaller -silent -responseFile 
    /u01/app/oracle/product/21.0.0/dbhome_1/install/response/db_install.rsp
  9. 使用 Oracle Database Configuration Assistant (DBCA) 以无提示模式或 GUI 模式创建 Oracle RAC 数据库。无提示模式示例:RDBMS_HOME/bin/dbca -silent -createDatabase -responseFile response_file_name_with_full_path.
    [oracle@racvm1 ~]$ /u01/app/oracle/product/21.0.0/dbhome_1/bin/dbca -silent -
    createDatabase -responseFile 
    /u01/app/oracle/product/21.0.0/dbhome_1/assistants/dbca/dbca.rsp
  10. 验证是否已成功创建 Oracle RAC
    [oracle@racvm1 ~]$ /u01/app/oracle/product/21.0.0/dbhome_1/bin/srvctl status db -d 
    PCARACDB
    Instance PCARACDB1 is running on node racvm1
    Instance PCARACDB2 is running on node racvm2
    oracle@racvm1 ~]$ crsctl stat res -t|grep -i db
    ora.pcaracdb.db
     1 ONLINE ONLINE racvm1 Open,HOME=/u01/app/o
     racle/product/21.0.0
    /dbhome_1,STABLE
     2 ONLINE ONLINE racvm2 Open,HOME=/u01/app/o
     racle/product/21.0.0
    /dbhome_1,STABLE