This content has been marked as final. Show 7 replies
The diskgroup "DG_NSOQACC" is not mounted. Connect to the ASM instance and mount the diskgroup. Then start the database.
export ORACLE_SID=+ASMMount the diskgroup using the below command:
export ORACLE_HOME=<Your Grid Infrastructure Home>
sqlplus / as sysasm
select name,state from v$asm_diskgroup;
alter diskgroup DG_NSOQACC mount;
do you have all the disks available in that diskgroup DG_NSOQACC ?
SQL> alter diskgroup DG_NSOQACC mount; alter diskgroup DG_NSOQACC mount * ERROR at line 1: ORA-15032: not all alterations performed ORA-15040: diskgroup is incomplete ORA-15042: ASM disk "2" is missing from group number "1"
looks like one of disk was offline/missing.
post results of following:
select disk_number, mount_status, header_status, mode_status, state, name, label, path from v$asm_disk where group_number=1 order by disk_number;
I did the commands you sent to me and do not show anything:
[oracle@ilmatar root]$ . oraenv
ORACLE_SID = [+ASM] ? +ASM
The Oracle base remains unchanged with value /opt/oracle
[oracle@ilmatar root]$ sqlplus "/as sysasm"
SQL*Plus: Release 220.127.116.11.0 Production on Wed Nov 14 14:06:22 2012
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Oracle Database 11g Enterprise Edition Release 18.104.22.168.0 - 64bit Production
With the Automatic Storage Management option
SQL> select disk_number, mount_status, header_status, mode_status, state, name, label, path from v$asm_disk where group_number=1 order by disk_number;
no rows selected