Return to Revisions

2 of 3

Cleanup and add version tag

edit approved Dec 21, 2017 at 20:37

1.1k
1
13
32

Empty v$asm_diskgroup with sqlplus

I have a Oracle Database instance installed under a OL7. It is a 12c2. Oracle GI also installed and my database have some files stored in ASM.

I am using sqlplus to connect to the database instance and query v$asm_diskgroup. My ORACLE_HOME points to home of my database instance.

When I connect without specify a "@CONNECTION" (e.g using: sqlplus user/name), then the view v$asm_diskgroup returns no rows. When I connect specifying a @TNSNAME (e.g: sqlplus user/name@TNSNAME ), then the view v$asm_diskgroup returns data correctly.

Also, when i connect using sql developer, from another machine, the v$asm_diskgroup returns the rows.

Why when I use sqlplus without @CONNECTION, that is, the default logon, no v$asm_diskgroup rows are returned?

asked Dec 21, 2017 at 15:45

Rodrigo