oracle 12c RAC安裝，例項不能多節點同時啟動

raysuen發表於2020-03-21
Oracle
一 問題描述：
1 安裝例項報錯：
PRCR-1079 : Failed to start resource ora.xxx.db
CRS-5017: The resource action "ora.xxx.db start" encountered thefollowing error:  
ORA-03113: end-of-file on communication channel
Process ID: 43228
Session ID: 1235 Serial number: 3842
. For details refer to "(:CLSN00107:)" in"/oracle/app/grid/diag/crs/rac1 /crs/trace/crsd_oraagent_oracle.trc".
CRS-2674: Start of 'ora.xxx.db' on ‘rac1' failed
CRS-2632: There are no more servers to try to place resource 'ora.xxx.db' onthat would satisfy its placement policy
2 未啟動的節點，手工啟動
[oracle@rac2 ~]$ sqlplus /nolog
SQL*Plus: Release 12.2.0.1.0 Production on Sat Mar 21 10:53:43 2020
Copyright (c) 1982, 2016, Oracle.  All rights reserved.
SQL> conn / as sysdba
Connected to an idle instance.
SQL> startup
ORA-03113: end-of-file on communication channel
SQL> exit
3 alert日誌關鍵內容
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.
二 資料庫版本和安裝平臺
1 資料庫：12.2.0.1
2 OS版本：rhel 7.5
三 問題分析
問題提示為網路問題，因各種原因使用單私有網路卡安裝成功。
再根據楊老師的blog( http://blog.itpub.net/31547066/viewspace-2222482/)提供的解決方案，使用虛擬機器復現問題，確實可以同時啟動其他節點的例項。
解決方法：修改私有網路卡的rp_filter值
vi /etc/sysctl.conf
net.ipv4.conf.enp0s8.rp_filter = 2
net.ipv4.conf.enp0s9.rp_filter = 2
解決方法的出處：

Multiple Private Interconnects and Oracle Linux

Review this information for settings for the  rp_filter  parameter for Oracle RAC systems that use multiple NICs for the private interconnect. 
With Oracle Linux kernel 2.6.31, which also includes Oracle Unbreakable Enterprise Kernel 2.6.32, a bug has been fixed in the Reverse Path Filtering. As a consequence of this correction, Oracle RAC systems that use multiple NICs for the private interconnect now require specific settings for the  rp_filter parameter. This requirement also applies to all Exadata systems that are running Linux kernel 2.6.32 and above. Without these  rp_filter  parameter settings systems, interconnect packets can be blocked or discarded.
The  rp_filter  values set the Reverse Path filter to no filtering (0), to strict filtering (1), or to loose filtering (2). Set the  rp_filter  value for the private interconnects to either 0 or 2. Setting the private interconnect NIC to 1 can cause connection issues on the private interconnect. It is not considered unsafe to disable or relax this filtering, because the private interconnect should be on a private and isolated network.
For example, where  eth1  and  eth2  are the private interconnect NICs, and  eth0  is the public network NIC, set the  rp_filter  of the private address to 2 (loose filtering), the public address to 1 (strict filtering), using the following entries in  /etc/sysctl.conf :
net.ipv4.conf.eth2.rp_filter = 2
net.ipv4.conf.eth1.rp_filter = 2
net.ipv4.conf.eth0.rp_filter = 1

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

相關文章