一 问题描述：
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博客 ” ，链接：https://blog.itpub.net/28572479/viewspace-2681893/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
