ITPub博客

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

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

原创 Oracle 作者:raysuen 时间:2020-03-21 21:00:49 0 删除 编辑
一 问题描述:
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/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论
擅长oracle,Linux。精通shell,python。

注册时间:2016-08-23

  • 博文量
    138
  • 访问量
    181555