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 |
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:
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