RAC ASM instances crash with ORA-29702 when multiple ASM instances start(ed) [ID 733262.1]

简介: RAC ASM instances crash with ORA-29702 when multiple ASM instances start(ed) [ID 733262.
RAC ASM instances crash with ORA-29702 when multiple ASM instances start(ed) [ID 733262.1]

  修改时间 21-JAN-2011     类型 PROBLEM     状态 PUBLISHED  

In this Document
  Symptoms
  Cause
  Solution


Applies to:

Oracle Server - Enterprise Edition - Version: 10.1.0.2 to 11.1.0.7 - Release: 10.1 to 11.1
Information in this document applies to any platform.
***Checked for relevance on 21-Jan-2011***

Symptoms

On a new RAC installation, 1) cannot startup all 3 ASM instances or 2) if these are started, they
(or some ASM instances) do crash.

1) If attempting to restart an ASM instance:

    From srvctl, it gives
$ ./srvctl start asm -n wlrzd4447
PRKS-1009 : Failed to start ASM instance "+ASM2" on node "wlrzd4447", [PRKS-
1009 : Failed to start ASM instance "+ASM2" on node "wlrzd4447", [CRS-0215:
Could not start resource 'ora.wlrzd4447.ASM2.asm'.]]
[PRKS-1009 : Failed to start ASM instance "+ASM2" on node "wlrzd4447", [CRS-
0215: Could not start resource 'ora.wlrzd4447.ASM2.asm'.]]

    From sqlplus, it gives:
SQL> startup
ORA-03113: end-of-file on communication channel


2) The alert log for any of the ASM instance that crash, shows:
ORA-29702: error occurred in Cluster Group Service operation
LMON: terminating instance due to error 29702

.

Cause

Using not bonded, multiple NICs for the cluster interconnect.

From any of the ASM instance's alert logs, watch for multiple entries like 'Interface type 1 ...
configured from OCR for use as a cluster interconnect':

Mon Aug 18 22:57:28 2008
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Interface type 1 eth2 xxx.xxx.x.x configured from OCR for use as a cluster interconnect
Interface type 1 berth34 xxx.xxx.xxx.x configured from OCR for use as a cluster interconnect
Interface type 1 eth0 xx.xx.xx.x configured from OCR for use as a public interface
Picked latch-free SCN scheme 3
Using LOG_ARCHIVE_DEST_1 parameter default value as /opt/oracle/product/asm/10.2.0/dbs/arch
Autotune of undo retention is turned off.
LICENSE_MAX_USERS = 0
SYS auditing is disabled
ksdpec: called for event 13740 prior to event group initialization
Starting up ORACLE RDBMS Version: 10.2.0.4.0.


Note: IP addresses have been replaced by 'x' characters for privacy.


This is causing peer-to-peer failure between the clustered ASM instances, since the two NICs used
for the cluster interconnect are not bonded.

.

Solution

In this case it was not the intent to use more than one NIC for the Oracle Cluster interconnect, so steps for properly bonding NICs to be used for cluster interconnect will not be discussed.

To implement the solution, please execute the following steps:

1)  Follow the following article to first query all devices configured for the interconnect
     and then to delete the unnecessary device:

     Note 283684.1 (How to Change Interconnect/Public Interface IP Subnet in a 10g Cluster)

     Example:

   1a) Deleted the bert34 interface
          $ cd /opt/oracle/product/crs/10.2.0/bin
          $ ./oifcfg getif
               eth0 xx.xx.xx.x global public
               eth2 xxx.xxx.x.x global cluster_interconnect
               bert34 xxx.xxx.xxx.x global cluster_interconnect
          $ ./oifcfg delif -global berth34
          $ ./oifcfg getif
               eth0 xx.xx.xx.x global public
               eth2 xxx.xxx.x.x global cluster_interconnect

      Note: IP addresses have been replaced by 'x' characters for privacy.

2.) Stop the ASM instances in all nodes.

3.) Start the ASM instance in order (node1, node2 and then node3)
目录
相关文章
创建asm disk 磁盘组出错! ORA-15018 And ORA-15107 (Doc ID 2678808.1)
ORA-15018: diskgroup cannot be created ORA-15107: missing or invalid ASM disk name
255 0
|
容器
How to set the Undo_tablespace in PDB in Physical Standby RAC Database. (Doc ID 2726173.1)
How to set the Undo_tablespace in PDB in Physical Standby RAC Database. (Doc ID 2726173.1)
148 1
|
SQL
How To Resize An ASM Disk? (Doc ID 470209.1)
1) Please backup the database(s) contained inside the associated diskgroup. 2) Then shutdown the databases contained inside the associated diskgroup. 3) Dismount the associated diskgroup to verify no client database connections are accessing this specific diskgroup: SQL> alter diskgroup <diskgro
133 2
|
存储 Oracle 关系型数据库
RAC创建ASM磁盘组时配置多路径和UDEV
RAC创建ASM磁盘组时配置多路径和UDEV
3009 7
RAC 增加4块 asm 磁盘
增加磁盘之前的asm状态
182 0
|
Oracle 关系型数据库 Linux
ASMFD (ASM Filter Driver) Support on OS Platforms (Certification Matrix). (文档 ID 2034681.1)
1) Starting with Oracle Grid Infrastructure 12C Release 1 (12.1.0.2), Oracle ASM Filter Driver (Oracle ASMFD) is installed with an Oracle Grid Infrastructure installation.
2838 0