ORA-01078 ORA-01565 ORA-17503 ORA-15077

[root@rac10g2 bin]# su - oracle  
[oracle@rac10g2 ~]$ sqlplus / as sysdba  
  
  
SQL*Plus: Release 10.2.0.1.0 - Production on Thu May 23 13:03:45 2013  
  
  
Copyright (c) 1982, 2005, Oracle.  All rights reserved.  
  
  
Connected to an idle instance.  
  
  
SQL>   
SQL>   
SQL> startup  
ORA-01078: failure in processing system parameters  
ORA-01565: error in identifying file '+DATA1/rac10g/spfilerac10g.ora'  
ORA-17503: ksfdopn:2 Failed to open file +DATA1/rac10g/spfilerac10g.ora  
ORA-15077: could not locate ASM instance serving a required diskgroup  
SQL> exit  
  
  
  
  
[oracle@rac10g2 ~]$ export ORACLE_SID=+ASM2    
[oracle@rac10g2 ~]$ sqlplus / as sysdba  
  
  
SQL*Plus: Release 10.2.0.1.0 - Production on Thu May 23 13:21:56 2013  
  
  
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, OLAP and Data Mining options  
  
  
SQL> select name,state from v$asm_diskgroup;  
  
  
NAME                 STATE  
-------------------- ----------------------  
DATA1                DISMOUNTED  
FRA1                 DISMOUNTED  
  
  
SQL>   
SQL>   
SQL> alter diskgroup DATA1 mount;  
  
  
Diskgroup altered.  
  
  
SQL> alter diskgroup FRA1 mount;  
  
  
Diskgroup altered.  
  
  
SQL> select name,state from v$asm_diskgroup;  
  
  
NAME                 STATE  
-------------------- ----------------------  
DATA1                MOUNTED  
FRA1                 MOUNTED  
  
  
SQL> exit  
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production  
With the Partitioning, Real Application Clusters, OLAP and Data Mining options  
[oracle@rac10g2 ~]$   
[oracle@rac10g2 ~]$ export ORACLE_SID=rac10g2  
[oracle@rac10g2 ~]$ sqlplus / as sysdba  
  
  
SQL*Plus: Release 10.2.0.1.0 - Production on Thu May 23 13:25:06 2013  
  
  
Copyright (c) 1982, 2005, Oracle.  All rights reserved.  
  
  
Connected to an idle instance.  
  
  
SQL> startup  
ORACLE instance started.  
  
  
Total System Global Area  411041792 bytes  
Fixed Size                  1219712 bytes  
Variable Size             117441408 bytes  
Database Buffers          289406976 bytes  
Redo Buffers                2973696 bytes  
Database mounted.  
Database opened.  
SQL>   
SQL> exit  
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production  
With the Partitioning, Real Application Clusters, OLAP and Data Mining options  
[oracle@rac10g2 ~]$ crs_stat -t -v  
Name           Type           R/RA   F/FT   Target    State     Host          
----------------------------------------------------------------------  
ora.rac10g.db  application    0/1    0/1    ONLINE    ONLINE    rac10g2       
ora....g1.inst application    0/5    0/0    ONLINE    ONLINE    rac10g1       
ora....g2.inst application    0/5    0/0    ONLINE    ONLINE    rac10g2       
ora....SM1.asm application    0/5    0/0    ONLINE    ONLINE    rac10g1       
ora....G1.lsnr application    0/5    0/0    ONLINE    ONLINE    rac10g1       
ora....0g1.gsd application    0/5    0/0    ONLINE    ONLINE    rac10g1       
ora....0g1.ons application    0/3    0/0    ONLINE    ONLINE    rac10g1       
ora....0g1.vip application    0/0    0/0    ONLINE    ONLINE    rac10g1       
ora....SM2.asm application    0/5    0/0    ONLINE    ONLINE    rac10g2       
ora....G2.lsnr application    0/5    0/0    ONLINE    ONLINE    rac10g2       
ora....0g2.gsd application    0/5    0/0    ONLINE    ONLINE    rac10g2       
ora....0g2.ons application    0/3    0/0    ONLINE    ONLINE    rac10g2       
ora....0g2.vip application    0/0    0/0    ONLINE    ONLINE    rac10g2

转载于:https://www.cnblogs.com/Tomason/archive/2013/06/16/3138737.html