The global database name consists of the user-specified local database name and the location of the database within a network structure.
- Set the
DB_NAMEandDB_DOMAINinitialization parameters.
The DB_NAME initialization parameter determines the local name component of the database name, and the DB_DOMAIN parameter, which is optional, indicates the domain (logical location) within a network structure. The combination of the settings for these two parameters must form a database name that is unique within a network.
red hat certification malaysia
For example, to create a database with a global database name of test.us.example.com, edit the parameters of the new parameter file as follows:
DB_NAME = test
DB_DOMAIN = us.example.com
You can rename the GLOBAL_NAME of your database using the ALTER DATABASE RENAME GLOBAL_NAME statement. However, you must also shut down and restart the database after first changing the DB_NAME and DB_DOMAIN initialization parameters and recreating the control files. Recreating the control files is easily accomplished with the command ALTER DATABASE BACKUP CONTROLFILE TO TRACE. See Oracle Database Backup and Recovery User’s Guide for more information.
- DB_NAME Initialization Parameter
TheDB_NAMEinitialization parameter specifies a database identifier. - DB_DOMAIN Initialization Parameter
In a distributed database system, theDB_DOMAINinitialization parameter specifies the logical location of the database within the network structure.
Leave a Reply