部署 Oracle Grid InfrastructureOracle RAC

部署 Oracle Grid InfrastructureOracle RAC 資料庫涉及設定您的 Oracle Automatic Storage Management (Oracle ASM) 磁碟、以無訊息或 GUI 模式安裝 Oracle Grid Infrastructure 、重新開機 Oracle Clusterware 、安裝 Oracle RAC 資料庫軟體、建立 Oracle RAC 資料庫,以及驗證您的部署。

下列步驟描述如何在您的 Private Cloud Appliance 系統中部署 Oracle Grid InfrastructureOracle RAC
  1. 使用 asmcmdasmlib 為磁碟加上標籤。例如:GI_HOME/bin/asmcmd afd_label diskgroup_name disk_with_full_path --init。請參閱 Oracle Grid Infrastructure Installation Guide ,瞭解詳細資訊。
    /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,連線至開機磁碟區和區塊磁碟區、執行處理描述資料以及其他服務。這會影響專用網路所使用的 HAIP 通訊,讓 Oracle Grid Infrastructure 安裝失敗。必須設定此環境變數,HAIP 通訊才能成功。
    $ export HAIP_UNSUPPORTED=TRUE
  5. 在每個節點上執行 ./root.sh 指令。
    $ ./root.sh
  6. 使用 Cluster Verification 公用程式 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 Installation Guide
    無訊息模式範例: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