DB_DOMAIN,GLOBAL_NAME in Oracle Database

[malay boy]

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

[twang]

Hi Arman,

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

[twang]

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.