General
cancel
Showing results for 
Search instead for 
Did you mean: 

DB_DOMAIN,GLOBAL_NAME in Oracle Database

malay boy
Trusted Contributor

DB_DOMAIN,GLOBAL_NAME in Oracle Database

Hi,
May I know what is the used of DB_DOMAIN parameter in oracle database ?. and what is the GLOBAL_DBNAME ?.Basically we don't need this(DB_DOMAIN,GLOBAL_NAME) for connection to database as configuring listener.ora in server and tnsnames.ora in client using ORACLE_SID enough to get connected.

regards
arman
There are three person in my team-Me ,myself and I.
2 REPLIES
twang
Honored Contributor

Re: DB_DOMAIN,GLOBAL_NAME in Oracle Database

Hi Arman,

Attached a Reference Note for Init.Ora Parameter "DB_DOMAIN". Hope it can help.
regards tommy
twang
Honored Contributor

Re: DB_DOMAIN,GLOBAL_NAME in Oracle Database

What is a global database name?
The global database name is the unique name of the database. In a distributed
database system (a set of databases stored on multiple computers that typically
appears to applications as a single database) the global database name ensures
that each database is distinct from all other databases in the system. Oracle
forms a database's global database name by prefixing the database's network
domain with the individual database's name. For example: sales.us.oracle.com
and sales.uk.oracle.com.

The global database name defaults to DB_NAME.DB_DOMAIN and this value is marked
at database creation time. If you change the DB_NAME or DB_DOMAIN after the
database has been created, the value for the global database name (GLOBAL_NAME)
will not change.