During the weekend I’ve setup two virtual box standard edition 12c machines to test
Dbvisit Standby. During the setup I had some issues with archive log gap’s, while collecting information for Dbvisit’s excellent support I noticed that v$asm_diskgroup was empty …
However asmcmd returned information I couldn’t understand why and started digging ….
At the same time that @martinberx was suggesting it, I started to use the 10046 trace to see what happens
when I execute
select * from v$asm_diskgroup;
and also the lsdg action in asmcmd
which generates this :
@pfierens @martinberx you could check permission on the block devices, kfod disks=all (might need to set ask_diskstring too)
And that seemed to do it, for some reason the asm_diskstring was not set … after setting the asm_diskstring select from v$asm_diskgroup worked again.
Big Thanks to all who helped me here, twitter is great and having friend out there is even better, thank you guys !!!
BTW after fixing the v$asm_diskgroup dbvisit standby started resolving the archive log gap, it looks like a great product I will be investigating deeper ….