首页 > 数据库 > Oracle > oracle 12c RAC安装,实例不能多节点同时启动

oracle 12c RAC安装,实例不能多节点同时启动

原创 Oracle 作者:raysuen 时间:2020-03-21 21:00:49 0 删除 编辑
一 问题描述:
1 安装实例报错:
PRCR-1079 : Failed to start resource
CRS-5017: The resource action " 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 '' on ‘rac1' failed
CRS-2632: There are no more servers to try to place resource '' onthat would satisfy its placement policy
2 未启动的节点,手工启动
[oracle@rac2 ~]$ sqlplus /nolog
SQL*Plus: Release 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 数据库:
2 OS版本:rhel 7.5
三 问题分析
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博客 ” ,链接:,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录


  • 博文量
  • 访问量