ASM환경에서 DB가 Open 되지 않을 때

콘솔을 reboot한 이후 DB가 open 되지 않을 때
(ORA-01078, ORA-01565, ORA-17503, ORA-15077 에러)

예제 :
$ sqlplus / as sysdba
SQL> startup
ORA-01078: failure in processing system parameters
ORA-01565: error in identifying file ‘+DATA/testdb/spfiletestdb.ora’
ORA-17503: ksfdopn:2 Failed to open file +DATA/testdb/spfiletestdb.ora
ORA-15077: could not locate ASM instance serving a required diskgroup
SQL> exit

$ export ORACLE_SID=+ASM
$ sqlplus / as sysdba
SQL> startup
ASM instance started

Total System Global Area   83886080 bytes
Fixed Size                  1272120 bytes
Variable Size              57448136 bytes
ASM Cache                  25165824 bytes
ASM diskgroups mounted
SQL> exit

$ export ORACLE_SID=testdb
$ sqlplus / as sysdba
SQL> startup
ORACLE instance started.

Total System Global Area  285212672 bytes
Fixed Size                  1273276 bytes
Variable Size              92275268 bytes
Database Buffers          188743680 bytes
Redo Buffers                2920448 bytes
Database mounted.
Database opened.

참고 사이트  : http://gyh214.tistory.com/136