Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Find global database name in oracle 11g

Tags:

oracle11g

I wants to find global database name of database say 'myDb'. The database is created by someone else and hence I wants to know it.

I am using Oracle 11g Enterprise Edition.

Any help would be appreciated.

like image 402
Mohammad Ashfaq Avatar asked Jan 15 '14 07:01

Mohammad Ashfaq


People also ask

What is the global database name in Oracle?

The global database name uniquely distinguishes a database from any other database in the same network. You specify the global database name when you create a database during the installation or using the Oracle Database Configuration Assistant. Here: sales.us is the name of the database.

How do I find the Oracle database name?

The view named V$database is used to find out the database details from the oracle. If you are using Oracle SQL developer or Toad to connect with your oracle database you need to use the select query to find out the name of the connected database. There are so many columns in V$Database view.

How do I find the instance name in Oracle 11g?

In addition you need select privilege on v_$session DBA view. Using GLOBAL_NAME also can find the name of instance/database name.


1 Answers

Try the below query to find the GLOBAL NAME,

SELECT * FROM GLOBAL_NAME;
like image 142
Dba Avatar answered Sep 22 '22 10:09

Dba