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 free space is showing zero

Girish AMay 29 2008 — edited Jul 7 2010

Hi,

We have 2 node RAC on linux with ASM storage.
The total space on ASM is 90 GB.

When i set ORACLE_SID=orcl
select state,total_mb/1024,free_mb/1024 from v$asm_diskgroup;
i got - mount 90 44

But when i set ORACLE_SID=+ASM1
select state,total_mb/1024,free_mb/1024 from v$asm_diskgroup;
i got - connected 90 0

Can anybody tell me why i am getting free space as "0" when i use sid of oracle database and which is actual free size.

Thanks & Regards
GirishA

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 4 2010

Added on May 29 2008

#automatic-storage-management, #performance-availability

10 comments

6,964 views