상황 : ASM이용하는 DB에서 서버다운 후 ASM이 mount가 되지 않는 현상
액션 : Cluster Manager 를 root로 start해줌
# crsctl start crs
시나리오
1. DB startup시도 (ASM이 mount안되어서 실패)
2. ASM mount 시도 (실패)
3. root로 로그인 후 Cluster Manager 시작
4. ASM mount 시도 (성공)
5. DB startup
1. DB startup시도 (ASM이 mount안되어서 실패)
[oracle@server15 ~]$ sqlplus / as sysdba SQL*Plus: Release 10.2.0.1.0 - Production on Tue Apr 24 12:32:59 2012 Copyright (c) 1982, 2005, Oracle. All rights reserved. Connected to an idle instance. 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 ORA-29701: unable to connect to Cluster Manager SQL> exit Disconnected
2. ASM mount 시도 (실패)
[oracle@server15 ~]$ export ORACLE_SID=+ASM [oracle@server15 ~]$ sqlplus / as sysdba SQL*Plus: Release 10.2.0.1.0 - Production on Tue Apr 24 12:33:18 2012 Copyright (c) 1982, 2005, Oracle. All rights reserved. Connected to an idle instance. SQL> startup ORA-29701: unable to connect to Cluster Manager SQL> exit Disconnected
3. root로 로그인 후 Cluster Manager 시작
[oracle@server15 ~]$ su ?뷀샇: [root@server15 oracle]# crsctl start crs Attempting to start CRS stack The CRS stack will be started shortly
4. ASM mount 시도 (성공)
[root@server15 oracle]# exit exit [oracle@server15 ~]$ echo $ORACLE_SID +ASM [oracle@server15 ~]$ sqlplus / as sysdba SQL*Plus: Release 10.2.0.1.0 - Production on Tue Apr 24 12:34:15 2012 Copyright (c) 1982, 2005, Oracle. All rights reserved. Connected to an idle instance. SQL> startup ASM instance started Total System Global Area 83886080 bytes Fixed Size 1217836 bytes Variable Size 57502420 bytes ASM Cache 25165824 bytes ASM diskgroups mounted SQL> SQL> exit Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production With the Partitioning, OLAP and Data Mining options
5. DB startup
[oracle@server15 ~]$ export ORACLE_SID=testdb [oracle@server15 ~]$ sqlplus / as sysdba SQL*Plus: Release 10.2.0.1.0 - Production on Tue Apr 24 12:37:30 2012 Copyright (c) 1982, 2005, Oracle. All rights reserved. Connected to an idle instance. SQL> startup ORACLE instance started. Total System Global Area 285212672 bytes Fixed Size 1218968 bytes Variable Size 75499112 bytes Database Buffers 201326592 bytes Redo Buffers 7168000 bytes Database mounted. Database opened.