ORA-01565: error in identifying file

Problem

SQL> startup
 ORA-01078: failure in processing system parameters
 ORA-01565: error in identifying file '+DATA/ORCL/PARAMETERFILE/spfileORCL.ora'
 ORA-17503: ksfdopn:2 Failed to open file +DATA/ORCL/PARAMETERFILE/spfileORCL.ora
 ORA-15056: additional error message
 ORA-17503: ksfdopn:2 Failed to open file +DATA/ORCL/PARAMETERFILE/spfileORCL.ora
 ORA-15001: diskgroup "DATA" does not exist or is not mounted ORA-06512: at line 4

Analyze

[oracle@dbserver ~]$ asmcmd
 ASMCMD> lsdg State Type Rebal Sector Block AU Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disksles Name
 QUIESCING NORMAL N 512 4096 1048576 16588800 13289794 307200 6491297 0 N DATA/
 QUIESCING NORMAL N 512 4096 1048576 614400 614 102400 -50893 0 N FRA/
 QUIESCING NORMAL N 512 4096 1048576 6011 5388 2048 730 0 Y GRID/

Solution

[oracle@dbserver ~]$ sqlplus / as sysasm
 SQL*Plus: Release 12.1.0.2.0 Production on Tue Aug 14 12:06:13 2018
 Copyright (c) 1982, 2014, Oracle. All rights reserved.
 Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production With the Real Application Clusters and Automatic Storage Management options

SQL> shutdown abort
 ASM instance shutdown
 SQL> startup
 ASM instance started Total System Global Area 2147483648 bytes
 Fixed Size 2926472 bytes
 Variable Size 2111002744 bytes ASM
 Cache 33554432 bytes ASM diskgroups mounted ASM diskgroups volume enabled

 

Komentáře