ora-15077，ASM磁碟組不能掛載

ora....SM1.asm application    ONLINE    ONLINE    rac1
ora....C1.lsnr application    ONLINE    ONLINE    rac1
ora.rac1.gsd   application    ONLINE    ONLINE    rac1
ora.rac1.ons   application    ONLINE    ONLINE    rac1
ora.rac1.vip   application    ONLINE    ONLINE    rac1
ora....SM2.asm application    ONLINE    ONLINE    rac2
ora....C2.lsnr application    ONLINE    ONLINE    rac2
ora.rac2.gsd   application    ONLINE    ONLINE    rac2
ora.rac2.ons   application    ONLINE    ONLINE    rac2
ora.rac2.vip   application    ONLINE    ONLINE    rac2
2、單獨啟動某個應用服務依然啟不起來
3、用sqlplus啟動例項，如下：
[oracle@rac1]$ export ORACLE_SID=devdb1
SQL> startup;
ORA-01078: failure in processing system parameters
ORA-01565: error in identifying file '+DG1/devdb/spfiledevdb.ora'
ORA-17503: ksfdopn:2 Failed to open file +DG1/devdb/spfiledevdb.ora
ORA-15077: could not locate ASM instance serving a required diskgroup
可以看出diskgroup沒有mount,所以先把diskgroup mount

也可做下面的測試，同樣也會報磁碟組沒掛載：
[oracle@rac1 bdump]$ export ORACLE_SID=+ASM1
[oracle@rac1 bdump]$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.1.0 - Production on Sat Mar 22 17:59:39 2008

Copyright (c) 1982, 2005, Oracle. All rights reserved.

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining options

SQL> shutdown immediate;
ORA-15100: invalid or missing diskgroup name

ASM instance shutdown
SQL> startup;
ASM instance started

Total System Global Area   92274688 bytes
Fixed Size                  1217884 bytes
Variable Size              65890980 bytes
ASM Cache                  25165824 bytes
ORA-15110: no diskgroups mounted

二、解決辦法：
1、首先掛載ASM磁碟組
[oracle@rac1 bdump]$ export ORACLE_SID=+ASM1
[oracle@rac1 bdump]$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.1.0 - Production on Sat Mar 22 17:59:39 2008

Copyright (c) 1982, 2005, Oracle. All rights reserved.

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining options
SQL> select name,state from v$asm_diskgroup;

NAME                           STATE
------------------------------ -----------
RECOVERYDEST                   DISMOUNTED
DG1                            DISMOUNTED

SQL> alter diskgroup RECOVERYDEST mount;

Diskgroup altered.

SQL> alter diskgroup DG1 mount;

Diskgroup altered.

SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining options

2、啟動資料庫例項
[oracle@rac1 bdump]$ export ORACLE_SID=devdb1
[oracle@rac1 bdump]$ sqlplus / as sysdba
SQL> startup;
ORACLE instance started.

Total System Global Area 264241152 bytes
Fixed Size                  1218868 bytes
Variable Size             109053644 bytes
Database Buffers          150994944 bytes
Redo Buffers                2973696 bytes
Database mounted.
database open.

三、原因：
發現可能是因為oracle使用者下的.bashrc檔案中$ORACLE_SID環境變數與實際建庫的資料庫名不一致所至,所以在資料庫啟動時會找不到環境變數對應的例項名
.bashrc中是orcl1
[oracle@rac1~]cat .bashrc
.....
export ORACLE_SID=orcl1
.....

而實現的例項名是devdb1
所以修改.bashrc中的ORACLE_SID=devdb1

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/15688952/viewspace-665544/，如需轉載，請註明出處，否則將追究法律責任。