一 问题描述:
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
解决方法的出处:
https://docs.oracle.com/en/database/oracle/oracle-database/12.2/cwlin/multiple-private-interconnects-and-oracle-linux.html#GUID-B9508AD5-AFD6-4D34-9DA9-773D44FD43A0
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
编辑推荐:
下一篇:
相关推荐
-
雷神推出 MIX PRO II 迷你主机:基于 Ultra 200H,玻璃上盖 + ARGB 灯效
2 月 9 日消息,雷神 (THUNDEROBOT) 现已宣布推出基于英
-
制造商 Musnap 推出彩色墨水屏电纸书 Ocean C:支持手写笔、第三方安卓应用
2 月 10 日消息,制造商 Musnap 现已在海外推出一款 Oce
热文推荐
- 2套RAC环境修改scanip后客户端连接异常
2套RAC环境修改scanip后客户端连接异常
26-03-03 - 外键上有无索引的影响
外键上有无索引的影响
26-03-03 - Oracle 12c数据库安装
Oracle 12c数据库安装
26-03-03 - 28_bbed实战(1)_delete操作恢复
28_bbed实战(1)_delete操作恢复
26-03-03 - ORA-07445: 出现异常错误: 核心转储 [kupfuDecompress()+2279]
- ORA-00119: invalid specification for system parameter LOCAL_LISTENER
- 小程序客服消息接入微信教程
小程序客服消息接入微信教程
26-03-03 - 18C RAC DBCA建库找不到ASM磁盘组
18C RAC DBCA建库找不到ASM磁盘组
26-03-03 - 19c(19.3) 单机数据库安装
19c(19.3) 单机数据库安装
26-03-03 - 公益直播|DBA职业发展之路
公益直播|DBA职业发展之路
26-03-03
