{"id":1244,"date":"2014-06-18T21:15:37","date_gmt":"2014-06-18T13:15:37","guid":{"rendered":"http:\/\/www.yallonking.com\/?p=1244"},"modified":"2014-06-18T21:17:23","modified_gmt":"2014-06-18T13:17:23","slug":"dbca%e5%88%9b%e5%bb%barac%e6%95%b0%e6%8d%ae%e5%ba%93%e6%97%b6%ef%bc%8c%e6%8a%a5%e9%94%99ora-03113-end-of-file-on-communication-channel","status":"publish","type":"post","link":"http:\/\/www.yallonking.com\/?p=1244","title":{"rendered":"dbca\u521b\u5efarac\u6570\u636e\u5e93\u65f6\uff0c\u62a5\u9519ORA-03113: end-of-file on communication channel"},"content":{"rendered":"<p>dbca\u521b\u5efarac\u6570\u636e\u5e93\u65f6\uff0c\u62a5\u9519ORA-03113: end-of-file on communication channel<br \/>\n\u5982\u4e0b\u56ferac_dbca_error.png<br \/>\n<a href=\"http:\/\/www.yallonking.com\/wp-content\/uploads\/2014\/06\/rac_dbca_error.png\" class=\"cboxElement\" rel=\"example_group\"1244><img loading=\"lazy\" src=\"http:\/\/www.yallonking.com\/wp-content\/uploads\/2014\/06\/rac_dbca_error.png\" alt=\"rac_dbca_error\" width=\"695\" height=\"571\" class=\"aligncenter size-full wp-image-1245\" \/><\/a><\/p>\n<p>\u6b64\u65f6\u67e5\u770bcrs\u5404\u4e2a\u8d44\u6e90\u5982\u4e0b\uff1a<\/p>\n<pre class=\"wp-code-highlight prettyprint\">\r\n[root@ocm3 bin]# .\/crs_stat -t\r\nName           Type           Target    State     Host        \r\n------------------------------------------------------------\r\nora....SM1.asm application    ONLINE    OFFLINE               \r\nora....M3.lsnr application    ONLINE    OFFLINE               \r\nora.ocm3.gsd   application    ONLINE    ONLINE    ocm3        \r\nora.ocm3.ons   application    ONLINE    ONLINE    ocm3        \r\nora.ocm3.vip   application    ONLINE    ONLINE    ocm4        \r\nora....SM2.asm application    ONLINE    ONLINE    ocm4        \r\nora....M4.lsnr application    ONLINE    ONLINE    ocm4        \r\nora.ocm4.gsd   application    ONLINE    ONLINE    ocm4        \r\nora.ocm4.ons   application    ONLINE    ONLINE    ocm4        \r\nora.ocm4.vip   application    ONLINE    ONLINE    ocm4        \r\nora.racdb.db   application    OFFLINE   OFFLINE               \r\nora....b1.inst application    OFFLINE   OFFLINE               \r\nora....b2.inst application    OFFLINE   OFFLINE  \r\n<\/pre>\n<p>\u53d1\u73b0\u8282\u70b91\u7684asm\u8d44\u6e90\u6389\u4e86\u3002<\/p>\n<p>\u8282\u70b91\u7684asm\u65e5\u5fd7\u5982\u4e0b\uff1a<\/p>\n<pre class=\"wp-code-highlight prettyprint\">\r\nMon Jun 16 17:19:04 2014\r\nShutting down instance (abort)\r\nLicense high water mark = 9\r\nInstance terminated by USER, pid = 14044\r\n<\/pre>\n<p>\u8282\u70b91\u7684db\u7684\u65e5\u5fd7\u5982\u4e0b\uff1a<\/p>\n<pre class=\"wp-code-highlight prettyprint\">\r\nMon Jun 16 17:19:04 2014\r\nErrors in file \/u01\/app\/oracle\/product\/10.2.0\/db_1\/admin\/racdb\/bdump\/racdb1_asmb_12884.trc:\r\nORA-15064: communication failure with ASM instance\r\nORA-03113: end-of-file on communication channel\r\nMon Jun 16 17:19:04 2014\r\nASMB: terminating instance due to error 15064\r\nMon Jun 16 17:19:04 2014\r\nSystem state dump is made for local instance\r\nSystem State dumped to trace file \/u01\/app\/oracle\/product\/10.2.0\/db_1\/admin\/racdb\/bdump\/racdb1_diag_12814.trc\r\nMon Jun 16 17:19:04 2014\r\nTrace dumping is performing id=[cdmp_20140616171904]\r\nMon Jun 16 17:19:09 2014\r\nInstance terminated by ASMB, pid = 12884\r\n<\/pre>\n<p>\u5bf9\u5e94trace\u65e5\u5fd7\u5982\u4e0b\uff1a<\/p>\n<pre class=\"wp-code-highlight prettyprint\">\r\n\/u01\/app\/oracle\/product\/10.2.0\/db_1\/admin\/racdb\/bdump\/racdb1_asmb_12884.trc\r\nOracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production\r\nWith the Partitioning, Real Application Clusters, Oracle Label Security, OLAP\r\nand Data Mining options\r\nORACLE_HOME = \/u01\/app\/oracle\/product\/10.2.0\/db_1\r\nSystem name:    Linux\r\nNode name:      ocm3\r\nRelease:        2.6.18-164.el5\r\nVersion:        #1 SMP Tue Aug 18 15:51:54 EDT 2009\r\nMachine:        i686\r\nInstance name: racdb1\r\nRedo thread mounted by this instance: 1\r\nOracle process number: 19\r\nUnix process pid: 12884, image: oracle@ocm3 (ASMB)\r\n\r\n*** 2014-06-16 17:19:04.756\r\n*** SERVICE NAME:() 2014-06-16 17:19:04.756\r\n*** SESSION ID:(154.1) 2014-06-16 17:19:04.756\r\nerror 15064 detected in background process\r\nORA-15064: communication failure with ASM instance\r\nORA-03113: end-of-file on communication channel\r\nksuitm: waiting for [5] seconds before killing DIAG\r\n<\/pre>\n<p>\u89e3\u51b3\u65b9\u6848\uff1a<br \/>\n<strong>\u4fee\u65392\u4e2a\u8282\u70b9asm\u7684\u53c2\u6570\u6587\u4ef6\u5373\u53ef\u89e3\u51b3\uff01<\/strong><\/p>\n<pre class=\"wp-code-highlight prettyprint\">\r\n[oracle@ocm3 dbs]$ env|grep ORACLE\r\nORACLE_ASM=+ASM1\r\nORACLE_SID=+ASM1\r\nORACLE_HOME=\/u01\/app\/oracle\/product\/10.2.0\/db_1\r\n[oracle@ocm3 dbs]$ sqlplus &quot;\/as sysdba&quot;\r\n\r\nSQL*Plus: Release 10.2.0.1.0 - Production on Mon Jun 16 17:36:03 2014\r\n\r\nCopyright (c) 1982, 2005, Oracle.  All rights reserved.\r\n\r\n\r\nConnected to:\r\nOracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production\r\nWith the Partitioning, Real Application Clusters, Oracle Label Security, OLAP\r\nand Data Mining options\r\n\r\nSQL&gt; startup       \r\nASM instance started\r\n\r\nTotal System Global Area   92274688 bytes\r\nFixed Size                  1217884 bytes\r\nVariable Size              65890980 bytes\r\nASM Cache                  25165824 bytes\r\nASM diskgroups mounted\r\nSQL&gt; show parameter spfile\r\n\r\nNAME                                 TYPE        VALUE\r\n------------------------------------ ----------- ------------------------------\r\nspfile                               string\r\nSQL&gt; show parameter pfile\r\n\r\nNAME                                 TYPE        VALUE\r\n------------------------------------ ----------- ------------------------------\r\nspfile                               string\r\n\r\nSQL&gt; shutdown immediate;\r\nASM diskgroups dismounted\r\nASM instance shutdown\r\nSQL&gt; startup pfile=&#039;\/home\/oracle\/pfile_asm.txt&#039;;\r\nASM instance started\r\n\r\nTotal System Global Area   92274688 bytes\r\nFixed Size                  1217884 bytes\r\nVariable Size              65890980 bytes\r\nASM Cache                  25165824 bytes\r\nASM diskgroups mounted\r\nSQL&gt; create spfile from pfile=&#039;\/home\/oracle\/pfile_asm.txt&#039;;\r\n\r\nFile created.\r\n\r\nSQL&gt; shutdown immediate;\r\nASM diskgroups dismounted\r\nASM instance shutdown\r\n<\/pre>\n<p>\u8282\u70b92\u4e5f\u4e00\u540c\u4fee\u6539<\/p>\n<p>\u7136\u540e\u542f\u52a8crs\u5404\u4e2a\u8d44\u6e90<\/p>\n<pre class=\"wp-code-highlight prettyprint\">\r\n[root@ocm3 bin]# .\/crs_stat -t\r\nName           Type           Target    State     Host        \r\n------------------------------------------------------------\r\nora....SM1.asm application    ONLINE    ONLINE    ocm3        \r\nora....M3.lsnr application    ONLINE    ONLINE    ocm3        \r\nora.ocm3.gsd   application    ONLINE    ONLINE    ocm3        \r\nora.ocm3.ons   application    ONLINE    ONLINE    ocm3        \r\nora.ocm3.vip   application    ONLINE    ONLINE    ocm3        \r\nora....SM2.asm application    ONLINE    ONLINE    ocm4        \r\nora....M4.lsnr application    ONLINE    ONLINE    ocm4        \r\nora.ocm4.gsd   application    ONLINE    ONLINE    ocm4        \r\nora.ocm4.ons   application    ONLINE    ONLINE    ocm4        \r\nora.ocm4.vip   application    ONLINE    ONLINE    ocm4        \r\nora.racdb.db   application    ONLINE    OFFLINE               \r\nora....b1.inst application    ONLINE    OFFLINE               \r\nora....b2.inst application    ONLINE    OFFLINE  \r\n\r\n<\/pre>\n<p>\u4fee\u6539\u540e\u8282\u70b91\u5982\u4e0b\uff1a<\/p>\n<pre class=\"wp-code-highlight prettyprint\">\r\nSQL&gt; show parameter spfile\r\n\r\nNAME                                 TYPE        VALUE\r\n------------------------------------ ----------- ------------------------------\r\nspfile                               string      \/u01\/app\/oracle\/product\/10.2.0\r\n                                                 \/db_1\/dbs\/spfile+ASM1.ora\r\n\r\n\u8282\u70b92\u5982\u4e0b\uff1a\t\t\t\t\t\t\t\t\t\t\t\t \r\nSQL&gt; show parameter spfile\r\n\r\nNAME                                 TYPE        VALUE\r\n------------------------------------ ----------- ------------------------------\r\nspfile                               string      \/u01\/app\/oracle\/product\/10.2.0\r\n                                                 \/db_1\/dbs\/spfile+ASM2.ora\r\n<\/pre>\n<p>\u81f3\u6b64\uff0cdbca\u5efarac\u5e93\u6b63\u5e38\uff01<\/p>\n","protected":false},"excerpt":{"rendered":"<p>dbca\u521b\u5efarac\u6570\u636e\u5e93\u65f6\uff0c\u62a5\u9519ORA-03113: end-of-file on communication [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[36],"tags":[267],"_links":{"self":[{"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/posts\/1244"}],"collection":[{"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1244"}],"version-history":[{"count":4,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/posts\/1244\/revisions"}],"predecessor-version":[{"id":1249,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/posts\/1244\/revisions\/1249"}],"wp:attachment":[{"href":"http:\/\/www.yallonking.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1244"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1244"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1244"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}