RAC \u542f\u52a8\u62a5\u9519ORA-01078 ORA-01565 ORA-17503 ORA-15077<\/p>\n
[oracle@rac1 ~]$ sqlplus \/nolog
\nSQL*Plus: Release 10.2.0.1.0 - Production on Mon Aug 27 09:38:54 2012<\/p>\n
Copyright (c) 1982, 2005, Oracle. All rights reserved.<\/p>\n
SQL> conn \/as sysdba
\nConnected to an idle instance.
\nSQL> startup
\nORA-01078: failure in processing system parameters
\nORA-01565: error in identifying file '+DATA\/racdb\/spfileracdb.ora'
\nORA-17503: ksfdopn:2 Failed to open file +DATA\/racdb\/spfileracdb.ora
\nORA-15077: could not locate ASM instance serving a required diskgroup<\/p>\n
[oracle@rac1 ~]$ crs_stat -t
\nName Type Target State Host
\n------------------------------------------------------------
\nora....SM1.asm application ONLINE UNKNOWN rac1
\nora....C1.lsnr application ONLINE UNKNOWN rac1
\nora.rac1.gsd application ONLINE UNKNOWN rac1
\nora.rac1.ons application ONLINE UNKNOWN rac1
\nora.rac1.vip application ONLINE ONLINE rac1
\nora....SM2.asm application ONLINE UNKNOWN rac2
\nora....C2.lsnr application ONLINE UNKNOWN rac2
\nora.rac2.gsd application ONLINE UNKNOWN rac2
\nora.rac2.ons application ONLINE UNKNOWN rac2
\nora.rac2.vip application ONLINE ONLINE rac2
\nora.racdb.db application ONLINE UNKNOWN rac2
\nora....b1.inst application ONLINE OFFLINE
\nora....b2.inst application ONLINE OFFLINE<\/p>\n
[oracle@rac1 ~]$ export ORACLE_SID=+ASM1
\n[oracle@rac1 ~]$ sqlplus \/nolog<\/p>\n
SQL*Plus: Release 10.2.0.1.0 - Production on Mon Aug 27 09:48:53 2012<\/p>\n
Copyright (c) 1982, 2005, Oracle. All rights reserved.<\/p>\n
SQL> conn \/as sysdba
\nConnected to an idle instance.
\nSQL> shutdown immediate
\nORA-01034: ORACLE not available
\nORA-27101: shared memory realm does not exist
\nLinux Error: 2: No such file or directory
\nSQL> startup
\nORACLE instance started.<\/p>\n
Total System Global Area 92274688 bytes
\nFixed Size 1217884 bytes
\nVariable Size 65890980 bytes
\nASM Cache 25165824 bytes
\nORA-15000: command disallowed by current instance type<\/p>\n
SQL> select name,state from v$asm_diskgroup;<\/p>\n
NAME STATE
\n------------------------------ -----------
\nDATA DISMOUNTED<\/p>\n
SQL> alter diskgroup data mount;<\/p>\n
Diskgroup altered.<\/p>\n
SQL> exit
\nDisconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
\nWith the Partitioning, Real Application Clusters, OLAP and Data Mining options
\n[oracle@rac1 ~]$ export ORACLE_SID=racdb1
\n[oracle@rac1 ~]$ sqlplus \/nolog<\/p>\n
SQL*Plus: Release 10.2.0.1.0 - Production on Mon Aug 27 09:51:28 2012<\/p>\n
Copyright (c) 1982, 2005, Oracle. All rights reserved.<\/p>\n
SQL> conn \/as sysdba
\nConnected to an idle instance.
\nSQL> startup
\nORACLE instance started.<\/p>\n
Total System Global Area 536870912 bytes
\nFixed Size 1220432 bytes
\nVariable Size 163578032 bytes
\nDatabase Buffers 369098752 bytes
\nRedo Buffers 2973696 bytes
\nDatabase mounted.
\nDatabase opened.<\/p>\n
\u6b64\u4f8b\u5c31\u662f\u56e0\u4e3aASM\u5b9e\u4f8b\u6ca1\u6709\u542f\u52a8\u800c\u76f4\u63a5\u542f\u52a8DBMS\u5b9e\u4f8b\u5bfc\u81f4\u7684\u95ee\u9898\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"
RAC \u542f\u52a8\u62a5\u9519ORA-01078 ORA-01565 ORA-17503 ORA-15077 [oracle […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[35,36],"tags":[],"_links":{"self":[{"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/posts\/291"}],"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=291"}],"version-history":[{"count":9,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/posts\/291\/revisions"}],"predecessor-version":[{"id":650,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/posts\/291\/revisions\/650"}],"wp:attachment":[{"href":"http:\/\/www.yallonking.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=291"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=291"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=291"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}