All the information I've seen on this issue is always in regards to running a query via some other utility (e.g. TOAD); however, I am seeing this issue when I simply try to
select * from v$asm_disk; on the
SQLPLUS command line. I am running the query as
SYSDBA and it fails. If I log in to the ASM instance as SYSASM, I am able to run
select * from v$asm_disk;. I have two boxes with identical OS and kernel versions, that were set up in the same manner.
Ultimately the issue comes from not being able to query the underlying fixed view which is used to create this view,
X$KFDSK_STAT. On one server, as SYSDBA I can query that view, and on the other, I cannot.
Has anyone seen this before?