Oracle 19C RAC實施方案詳細說明-常見問題07

Oracle 19C RAC 實施方案詳細說明 - 常見問題 07

[grid@rac1 grid]$ ./runcluvfy.sh stage -pre crsinst -n rac1,rac2 -verbose > /home/grid/pre.log

[grid@rac1 grid]$ vim /home/grid/pre.log

問題一：資料庫伺服器記憶體要求最少8G

由於本人膝上型電腦記憶體只有8G ，每臺虛擬機器只分配了 2.5G 記憶體，在安裝 GI 執行 root.sh 時，速度非常慢，期間出現了各種由於記憶體不足導致的錯誤。解除安裝安裝多次，勉強將 GI 安裝成功了，電腦記憶體已接近 100% ，後面只好重新安裝 11gRAC ，記憶體佔用比 19C 小很多。

問題二：swap 要求至少 2.23G, 安裝 11g 和 19C 都有這個要求，可以直接忽略。但是如果記憶體和 swap 空間同時不足了，可能會導致安裝失敗。

問題三： Verifying Daemon "avahi-daemon" not configured and running ...FAILED

錯誤日誌如下：

Verifying Daemon "avahi-daemon" not configured and running ...FAILED

rac2: PRVG-1359 : Daemon process "avahi-daemon" is configured on node "rac2"

rac2: PRVG-1360 : Daemon process "avahi-daemon" is running on node "rac2"

解決：avahi-daemon服務問題較多，可以直接關閉，安裝GI時錯誤可以先跳過。

[root@rac1 ~]# systemctl stop avahi-daemon.socket

[root@rac2 ~]# systemctl stop avahi-daemon.socket

問題四： Verifying /dev/shm mounted as temporary file system ...FAILED

/dev/shm 提示檢查失敗，值過小，後面啟動例項時可能會失敗

Verifying /dev/shm mounted as temporary file system ...FAILED

rac2: PRVE-0426 : The size of in-memory file system mounted as /dev/shm is

      "871" megabytes which is less than the required size of "2048" megabytes

      on node "rac2"

解決方案：增加操作記憶體，增大shm

[root@rac2 ~]# mount -o remount,size=2100M /dev/shm

問題五：[INS-41208] None of the available network subnets is marked for use by Oracle Automatic Storage Management(ASM)

Cause - At least one of the available network subnets should be configured for use by Oracle Automatic Storage Management (ASM).  

Action - Configure one of the available network subnets for Oracle Automatic Storage Management (ASM) use if you intend to configure Near Oracle ASM or Client Oracle ASM

問題原因：Use for 選擇了 Private ， 12c 開始要選 ASM&Private

選ASM&Private

問題六：執行root.sh 到 Executing installation step 16 of 19: 'InitConfig' 時報錯

[main] [ 2020-04-27 23:19:12.679 CST ] [UsmcaLogger.logInfo:156]  ORA-39511: Start of CRS resource for instance '215' failed with error:[CRS-2672: Attempting to start 'ora.cluster_interconnect.haip' on 'rac1'

問題現象：

[root@rac1 ~]# /u01/app/19c/grid/root.sh

ASM failed to start. Check /u01/app/grid/cfgtoollogs/asmca/asmca-200427PM111510.log for details.

2020/04/27 23:19:14 CLSRSC-184: Configuration of ASM failed

2020/04/27 23:19:26 CLSRSC-258: Failed to configure and start ASM

Died at /u01/app/19c/grid/crs/install/crsinstall.pm line 2484.

檢視日誌：

[root@rac1 ~]# vim /u01/app/grid/cfgtoollogs/asmca/asmca-200427PM111510.log

......

[main] [ 2020-04-27 23:15:11.923 CST ] [ASMImpl.<init>:292]  Got CRSException: PRCR-1070 : Failed to check if resource ora.asm is registered

CRS-0184 : Cannot communicate with the CRS daemon.

[main] [ 2020-04-27 23:15:11.923 CST ] [Usmca.execute:258]  PRCR-1070 : Failed to check if resource ora.asm is registered

CRS-0184 : Cannot communicate with the CRS daemon.

 

[main] [ 2020-04-27 23:18:57.938 CST ] [USMInstance.configureLocalASM:3413]  ORA-39511: Start of CRS resource for instance '215' failed with error:[CRS-2672: Attempting to start 'ora.cluster_interconnect.haip' on 'rac1'

 

[main] [ 2020-04-27 23:19:12.679 CST ] [UsmcaLogger.logInfo:156]  ORA-39511: Start of CRS resource for instance '215' failed with error:[CRS-2672: Attempting to start 'ora.cluster_interconnect.haip' on 'rac1'

問題原因：

報錯和 ora.cluster_interconnect.haip 有關，之前在作業系統做了網路卡繫結，主備模式，懷疑作業系統級別做的網路卡繫結和oracle haip 衝突，導致 ora.cluster_interconnect.haip 啟動失敗，crs 啟動失敗，最終 root.sh 執行失敗。

解決方案：

作業系統先去掉網路卡繫結。

問題七：執行root.sh 時，  step 17 of 19: 'StartCluster' 報錯。

錯誤日誌如下：

2020/05/01 14:59:34 CLSRSC-594: Executing installation step 17 of 19: 'StartCluster'.

CRS-5014: Agent "ORAROOTAGENT" timed out starting process "/u01/app/19c/grid/bin/acfsload" for action "check": details at "(:CLSN00009:)" in "/u01/app/grid/diag/crs/rac1/crs/trace/ohasd_orarootagent_root.trc"

CRS-5014: Agent "ORAROOTAGENT" timed out starting process "/u01/app/19c/grid/bin/acfsload" for action "check": details at "(:CLSN00009:)" in "/u01/app/grid/diag/crs/rac1/crs/trace/ohasd_orarootagent_root.trc"

CRS-2674: Start of 'ora.asm' on 'rac1' failed

CRS-2672: Attempting to start 'ora.storage' on 'rac1'

ORA-15077: could not locate ASM instance serving a required diskgroup

CRS-5055: unable to connect to an ASM instance because no ASM instance is running in the cluster

CRS-2883: Resource 'ora.storage' failed during Clusterware stack start.

CRS-4406: Oracle High Availability Services synchronous start failed.

問題原因： 膝上型電腦記憶體不足了，使用率接近100% ，導致執行 root.sh 到 step 17 of 19: 'StartCluster'. 時啟動 ORAROOTAGENT 超時，最終導致執行root.sh 失敗。

解決方案： 停掉筆記本上其他應用，釋放記憶體，例如關閉瀏覽器，QQ ， WPS ，微信等，又多次失敗反覆執行 root.sh 後 root.sh 終於執行成功了。

2020/05/01 16:03:45 CLSRSC-594: Executing installation step 17 of 19: 'StartCluster'.

2020/05/01 16:25:17 CLSRSC-343: Successfully started Oracle Clusterware stack

2020/05/01 16:26:24 CLSRSC-594: Executing installation step 18 of 19: 'ConfigNode'.

2020/05/01 16:48:14 CLSRSC-594: Executing installation step 19 of 19: 'PostConfig'.

2020/05/01 16:59:38 CLSRSC-325: Configure Oracle Grid Infrastructure for a Cluster ... succeeded

此時筆記本記憶體幾乎耗盡，不能在繼續安裝資料庫軟體建立例項了。

問題八：VBOX 建立完共享儲存後，兩個節點伺服器不能同時開機，後開機的會報如下錯誤。

不能為虛擬電腦rac1 開啟一個新任務。

問題原因： 新加6 塊磁碟， 5 塊屬性改成可共享，檢查發現第 6 塊磁碟屬性是普通模式，導致不能同時被兩個節點開啟。

解決方案： 修改第6 塊磁碟屬性可共享。

歡迎關注我的微信公眾號"IT小Chen"，共同學習，共同成長！！！

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/29785807/viewspace-2689745/，如需轉載，請註明出處，否則將追究法律責任。