A-A+
dbca创建rac数据库时,报错ORA-03113: end-of-file on communication channel
dbca创建rac数据库时,报错ORA-03113: end-of-file on communication channel
如下图rac_dbca_error.png
此时查看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库正常!