Skip to main content
Database Administrators

Return to Question

Bumped by Community user
Bumped by Community user
Bumped by Community user
Bumped by Community user
Bumped by Community user
Bumped by Community user
typos
Source Link
miracle173
miracle173
  • 7.8k
  • 26
  • 42

I have aan Oracle Database instance installed under aan OL7. It is a 12c2. Oracle GI also installed and my database havehas 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 specifyspecifying 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 iI 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, no v$asm_diskgroup rows are returned?

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?

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?

Bumped by Community user
Cleanup and add version tag
Source Link
edit approved Dec 21, 2017 at 20:37
Mark Stewart
edit approved Dec 21, 2017 at 20:37
Mark Stewart
  • 1.1k
  • 1
  • 13
  • 32

Can help me understand something?

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

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

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

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

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

Can help me understand something?

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

I 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 @MYTNSNAME (e.g: sqlplus user/name@TNSNAME ), then the view v$asm_diskgroup returns 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 is returned?

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?

Post Migrated Here from serverfault.com (revisions)
Source Link
Rodrigo
Rodrigo
  • 99
  • 1
  • 5

Empty v$asm_diskgroup with sqlplus

Can help me understand something?

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

I 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 @MYTNSNAME (e.g: sqlplus user/name@TNSNAME ), then the view v$asm_diskgroup returns 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 is returned?