Sample Header Ad - 728x90

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