Database Administration (MOSC)

MOSC Banner

v$asm_disk and v$asm_diskgroup return different results depending on who you connect as

edited May 7, 2014 1:06PM in Database Administration (MOSC) 3 commentsAnswered

Database version 10gR2

Host: OEL 5

Two users: one is Oracle User (oracle), and other one is non-Oracle user in OINSTALL and OSDBA group (delegate).

Database Storage: ASM (orcl)

The ownership of all the related disks is oracle:OSDBA.

If we connect to the database (orcl) as oracle, the query for v$asm_disk and v$asm_diskgroup return the correct results;

If we connect to the same database (orcl) as delegate, the same query returns empty result.

But if we connect to +ASM instance, all users can get the correct results.

And I find that GRID and ORACLE homes are the same on this host, is it a possible reason? Is it common to install the grid infrastructure software and database software together for 10gR2?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center