ORA Errors

ORA-15001 + ORA-17503


I received below error while starting the database, this is because the database was unable to read the parameter file, In this case my ASM was shutdown.

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


Solution:-
I started the ASM first and then database.

Connected to ASM Instance:-
SQL> startup
ASM instance started

Total System Global Area  283930624 bytes
Fixed Size                  2227664 bytes
Variable Size             256537136 bytes
ASM Cache                  25165824 bytes
ASM diskgroups mounted


SQL> alter diskgroup DATA mount;

Diskgroup altered.

SQL> select name,state from v$asm_diskgroup;


NAME                           STATE
------------------------------ -----------
FRA                            MOUNTED
DATA                           MOUNTED




Connected to DB Instance:-
SQL> startup
ORACLE instance started.

Total System Global Area 6714322944 bytes
Fixed Size                  2241064 bytes
Variable Size            2986347992 bytes
Database Buffers         3707764736 bytes
Redo Buffers               17969152 bytes
Database mounted.
Database opened.