Oracle 19c叢集安裝踩坑記錄-多私網

abstractcyj發表於2022-11-22

安裝好19c叢集與資料庫軟體之後,建立資料庫時,嘗試兩次都報錯,嘗試手動啟動也報錯

[FATAL] PRCR-1079 : Failed to start resource ora.hisdb.db

CRS-5017: The resource action "ora. testdb.db start" encountered the following error: 

ORA-03113: end-of-file on communication channel

Process ID: 0

Session ID: 0 Serial number: 0

. For details refer to "(:CLSN00107:)" in "/u01/app/grid/diag/crs/testdb/crs/trace/crsd_oraagent_oracle.trc".

在資料庫例項告警日誌中,有如下文字:

2022-11-22T14:17:03.051481+08:00

No connectivity to other instances in the cluster during startup. Hence, LMON is terminating the instance. Please check the LMON trace file for details. Also, please check the network logs of this instance along with clusterwide network health for problems and then re-start this instance.

LMON (ospid: ): terminating the instance due to ORA error 


最終找到了如下網頁:
oracle 12c RAC安裝,例項不能多節點同時啟動_ITPUB部落格


因為我採用了多私網,/etc/sysctl.conf中應當加入:

net.ipv4.conf.eno7.rp_filter = 2

net.ipv4.conf.eno8.rp_filter = 2


官閘道器於此問題的說明:

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

相關文章