Saturday, September 17, 2011

ASM DiskGroup NOT Mounted in 11G R2



I was just going to create a 11G R2 RAC  database on my RHEL 5.4 two node cluster. But dbca exists stating that ASM diskgroup where I am planning to put my database files are not mounted.

When I checked status using GRID_HOME/asmca,it shows the disks as mounted. But still dbca reports the same problem

I wanted to login to ASM instance and query the V$ASM_DISKGROUP.

On Node 1, I saw that ASM instance is up.

n310 oracle [+ASM1]:ps -ef | grep smon               
    oracle 355 30041 0 15:06 pts/2 00:00:00 grep smon          
    oracle 6730 1 0 12:51 ? 00:00:00 asm_smon_+ASM1
    oracle 14649 1 0 14:30 ? 00:00:00 ora_smon_nfr1
    oracle 14968 1 0 14:31 ? 00:00:00 ora_smon_nfr3

I thought I will query the V$ASM_DISKGROUP dynamic view to see the state of my ASM diskgroups.

Check the ORACLE_HOME variable from which ASM instance was started.

From the above grep command , I got the PID 6730 for ASM instance.
Go to /proc/PID/environ and check the environment variables with which the ASM instance was started.


n310 oracle [+ASM1]:cat /proc/6730/environ
Here I can see the ORACLE_HOME as /app/oracle/grid.            

export ORACLE_HOME=app/oracle/grid
Since now I got the ORACLE_HOME, Lets see what V$ASM_DISKGROUP shows
 n310 oracle [+ASM1]:export ORACLE_SID=+ASM1
    n310 oracle [+ASM1]:./bin/sqlplus / as sysasm

    SQL*Plus: Release 11.2.0.1.0 Production on Tue Feb 15 16:12:43 2011
    Copyright (c) 1982, 2009, Oracle. All rights reserved.
    Connected to:
    Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 – 64bit Production
    With the Real Application Clusters and Automatic Storage Management options

    SQL> select NAME,TOTAL_MB,FREE_MB,STATE from v$ASM_DISKgroup;

    NAME TOTAL_MB FREE_MB STATE
    —————————— ———- ———- ———–
    DATA 8610 7684 MOUNTED
    VOL 0 0 DISMOUNTED

    SQL> alter diskgroup VOL mount;

    Diskgroup altered.

    SQL> select NAME,TOTAL_MB,FREE_MB,STATE from v$ASM_DISKgroup;

    NAME TOTAL_MB FREE_MB STATE
    —————————— ———- ———- ———–
    DATA 8610 7684 MOUNTED
    VOL 38170 37980 MOUNTED

Here, When I logged in as sysdba,I got the following error.

    SQL> alter diskgroup VOL mount;
    alter diskgroup VOL mount
    *
    ERROR at line 1:
    ORA-15032: not all alterations performed
    ORA-15260: permission denied on ASM disk group             

So, I used SYSASM to do ASM management operations.

When I quered the DISKGROUP status in the second node, it shows as MOUNTED.

1 comments:

Unknown on December 17, 2016 at 5:37 PM said...

Try after login as "sysasm"

[grid@india india]$ sqlplus / as sysasm

SQL*Plus: Release 11.2.0.4.0 Production on Sat Dec 17 17:35:02 2016

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


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Real Application Clusters and Automatic Storage Management options

SQL> select NAME, STATE from v$asm_diskgroup;

NAME STATE
------------------------------ -----------
OCR_VOTING DISMOUNTED
DATA1 MOUNTED
DATA2 MOUNTED
FRA MOUNTED

SQL> alter diskgroup OCR_VOTING mount;

Diskgroup altered.

Post a Comment

 

ORA-BLOG. Copyright 2008 All Rights Reserved Revolution Two Church theme by Brian Gardner Converted into Blogger Template by Bloganol dot com