A-A+

dbca创建rac数据库时,报错ORA-03113: end-of-file on communication channel

2014年06月18日 TroubleShooting 暂无评论 阅读 1,661 次

dbca创建rac数据库时,报错ORA-03113: end-of-file on communication channel
如下图rac_dbca_error.png
rac_dbca_error

此时查看crs各个资源如下:

[root@ocm3 bin]# ./crs_stat -t
Name           Type           Target    State     Host        
------------------------------------------------------------
ora....SM1.asm application    ONLINE    OFFLINE               
ora....M3.lsnr application    ONLINE    OFFLINE               
ora.ocm3.gsd   application    ONLINE    ONLINE    ocm3        
ora.ocm3.ons   application    ONLINE    ONLINE    ocm3        
ora.ocm3.vip   application    ONLINE    ONLINE    ocm4        
ora....SM2.asm application    ONLINE    ONLINE    ocm4        
ora....M4.lsnr application    ONLINE    ONLINE    ocm4        
ora.ocm4.gsd   application    ONLINE    ONLINE    ocm4        
ora.ocm4.ons   application    ONLINE    ONLINE    ocm4        
ora.ocm4.vip   application    ONLINE    ONLINE    ocm4        
ora.racdb.db   application    OFFLINE   OFFLINE               
ora....b1.inst application    OFFLINE   OFFLINE               
ora....b2.inst application    OFFLINE   OFFLINE  

发现节点1的asm资源掉了。

节点1的asm日志如下:

Mon Jun 16 17:19:04 2014
Shutting down instance (abort)
License high water mark = 9
Instance terminated by USER, pid = 14044

节点1的db的日志如下:

Mon Jun 16 17:19:04 2014
Errors in file /u01/app/oracle/product/10.2.0/db_1/admin/racdb/bdump/racdb1_asmb_12884.trc:
ORA-15064: communication failure with ASM instance
ORA-03113: end-of-file on communication channel
Mon Jun 16 17:19:04 2014
ASMB: terminating instance due to error 15064
Mon Jun 16 17:19:04 2014
System state dump is made for local instance
System State dumped to trace file /u01/app/oracle/product/10.2.0/db_1/admin/racdb/bdump/racdb1_diag_12814.trc
Mon Jun 16 17:19:04 2014
Trace dumping is performing id=[cdmp_20140616171904]
Mon Jun 16 17:19:09 2014
Instance terminated by ASMB, pid = 12884

对应trace日志如下:

/u01/app/oracle/product/10.2.0/db_1/admin/racdb/bdump/racdb1_asmb_12884.trc
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, Real Application Clusters, Oracle Label Security, OLAP
and Data Mining options
ORACLE_HOME = /u01/app/oracle/product/10.2.0/db_1
System name:    Linux
Node name:      ocm3
Release:        2.6.18-164.el5
Version:        #1 SMP Tue Aug 18 15:51:54 EDT 2009
Machine:        i686
Instance name: racdb1
Redo thread mounted by this instance: 1
Oracle process number: 19
Unix process pid: 12884, image: oracle@ocm3 (ASMB)

*** 2014-06-16 17:19:04.756
*** SERVICE NAME:() 2014-06-16 17:19:04.756
*** SESSION ID:(154.1) 2014-06-16 17:19:04.756
error 15064 detected in background process
ORA-15064: communication failure with ASM instance
ORA-03113: end-of-file on communication channel
ksuitm: waiting for [5] seconds before killing DIAG

解决方案:
修改2个节点asm的参数文件即可解决!

[oracle@ocm3 dbs]$ env|grep ORACLE
ORACLE_ASM=+ASM1
ORACLE_SID=+ASM1
ORACLE_HOME=/u01/app/oracle/product/10.2.0/db_1
[oracle@ocm3 dbs]$ sqlplus "/as sysdba"

SQL*Plus: Release 10.2.0.1.0 - Production on Mon Jun 16 17:36:03 2014

Copyright (c) 1982, 2005, Oracle.  All rights reserved.


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, Real Application Clusters, Oracle Label Security, OLAP
and Data Mining options

SQL> startup       
ASM instance started

Total System Global Area   92274688 bytes
Fixed Size                  1217884 bytes
Variable Size              65890980 bytes
ASM Cache                  25165824 bytes
ASM diskgroups mounted
SQL> show parameter spfile

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
spfile                               string
SQL> show parameter pfile

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
spfile                               string

SQL> shutdown immediate;
ASM diskgroups dismounted
ASM instance shutdown
SQL> startup pfile='/home/oracle/pfile_asm.txt';
ASM instance started

Total System Global Area   92274688 bytes
Fixed Size                  1217884 bytes
Variable Size              65890980 bytes
ASM Cache                  25165824 bytes
ASM diskgroups mounted
SQL> create spfile from pfile='/home/oracle/pfile_asm.txt';

File created.

SQL> shutdown immediate;
ASM diskgroups dismounted
ASM instance shutdown

节点2也一同修改

然后启动crs各个资源

[root@ocm3 bin]# ./crs_stat -t
Name           Type           Target    State     Host        
------------------------------------------------------------
ora....SM1.asm application    ONLINE    ONLINE    ocm3        
ora....M3.lsnr application    ONLINE    ONLINE    ocm3        
ora.ocm3.gsd   application    ONLINE    ONLINE    ocm3        
ora.ocm3.ons   application    ONLINE    ONLINE    ocm3        
ora.ocm3.vip   application    ONLINE    ONLINE    ocm3        
ora....SM2.asm application    ONLINE    ONLINE    ocm4        
ora....M4.lsnr application    ONLINE    ONLINE    ocm4        
ora.ocm4.gsd   application    ONLINE    ONLINE    ocm4        
ora.ocm4.ons   application    ONLINE    ONLINE    ocm4        
ora.ocm4.vip   application    ONLINE    ONLINE    ocm4        
ora.racdb.db   application    ONLINE    OFFLINE               
ora....b1.inst application    ONLINE    OFFLINE               
ora....b2.inst application    ONLINE    OFFLINE  

修改后节点1如下:

SQL> show parameter spfile

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
spfile                               string      /u01/app/oracle/product/10.2.0
                                                 /db_1/dbs/spfile+ASM1.ora

节点2如下:												 
SQL> show parameter spfile

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
spfile                               string      /u01/app/oracle/product/10.2.0
                                                 /db_1/dbs/spfile+ASM2.ora

至此,dbca建rac库正常!

给我留言

Copyright © YallonKing 保留所有权利.   Theme  Ality

用户登录

分享到: