ASM환경의 DB startup하기(ORA-01078, ORA-01565, ORA-17503, ORA-15077)

ASM으로 DB를 설치한 환경에서

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

CAUSE :
ASM 디스크그룹이 mount되지 않아서 생긴 문제입니다.

ACTION :
SID = +ASM 을 먼저 mount시킨 후 SID=원래DB 에서 open 시키세요

ORACLE_SID=testdb
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

Disconnected

------------------------------------------------------------------------------------------------
 

[oracle@database ~]$ export ORACLE_SID=+ASM

[oracle@database ~]$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.5.0 - Production on Mon Feb 27 23:59:24 2012

Copyright (c) 1982, 2010, Oracle.  All Rights Reserved.

Connected to an idle instance.

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

Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options
 
 ------------------------------------------------------------------------------------------------
 

[oracle@database ~]$ export ORACLE_SID=testdb

[oracle@database ~]$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.5.0 - Production on Tue Feb 28 00:00:59 2012

Copyright (c) 1982, 2010, Oracle.  All Rights Reserved.

Connected to an idle instance.

SQL> startup

ORACLE instance started.

Total System Global Area  285212672 bytes

Fixed Size                  1273252 bytes

Variable Size              88080988 bytes

Database Buffers          188743680 bytes

Redo Buffers                7114752 bytes

Database mounted.

Database opened.

참조사이트 : http://blog.naver.com/PostView.nhn?blogId=ssdagan&logNo=80142513678

** ASM startup자체가 안된다면
$ echo $ORACLE_SID
+ASM
$ su
패스워드입력
# crsctl start all
이후
# exit
이후 ASM startup 시도