Empty v$asm_diskgroup with sqlplus
2
votes
3
answers
3384
views
I have an Oracle Database instance installed under an OL7. It is a 12c2.
Oracle GI also installed and my database has 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 the home of my database instance.
When I connect without specifying 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 are no v$asm_diskgroup
rows returned when I use sqlplus without @CONNECTION, that is, the default logon?
Asked by Rodrigo
(109 rep)
Dec 21, 2017, 03:45 PM
Last activity: Oct 29, 2020, 01:20 PM
Last activity: Oct 29, 2020, 01:20 PM