Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ASM (single instance) DG is mounted but query in V$ASM_diskgroup returns no rows.

MadhanKBDec 29 2015 — edited Jan 4 2016

Hi,

I am experimenting with Oracle 12c ASM on RHEL 7.1 GA.  I am able to create a DG and mount it. But when I query v$asm_diskgroup, it returns no rows.  Here is the necessary screenshots:

From alert.log:

NOTE: LGWR opened thread 1 (DUMMY) at fcn 0.11 ABA 5.7 lock domain=1 inc#=0 instnum=1 gx.incarn=2604588052 mntstmp=2015/12/29 03:07:54.245000

Tue Dec 29 03:07:54 2015

NOTE: cache mounting group 1/0x9B3EDC14 (DUMMY) succeeded

NOTE: cache ending mount (success) of group DUMMY number=1 incarn=0x9b3edc14

Tue Dec 29 03:07:54 2015

NOTE: Instance updated compatible.asm to 12.1.0.0.0 for grp 1

Tue Dec 29 03:07:54 2015

SUCCESS: diskgroup DUMMY was mounted

Tue Dec 29 03:07:54 2015

SUCCESS: alter diskgroup dummy mount

Tue Dec 29 03:07:54 2015

NOTE: diskgroup resource ora.DUMMY.dg is online

NOTE: diskgroup resource ora.DUMMY.dg is updated

When I login to the ASM instance:

-bash-4.2$ !sql

sqlplus "/ as sysasm"

SQL*Plus: Release 12.1.0.2.0 Production on Tue Dec 29 03:20:00 2015

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

Connected to:

Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production

With the Automatic Storage Management option

SQL> select name,state from v$asm_diskgroup;

no rows selected

My environment variables for the user:

GRID_HOME=/oracle/grid

ORACLE_HOME=/oracle/grid

Please help!  I suspect that this is preventing the oracle DB installation from recognizing the ASM DG during installation.

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 1 2016
Added on Dec 29 2015
30 comments
10,303 views