Components form global database name - Administering and Managing an Oracle Database

Q.  Which of these components forms a global database name?
- Published on 13 Aug 15

a. A database name
b. A domain name
c. Both A & B
d. None of the above

ANSWER: Both A & B
 

    Discussion

  • Nirja Shah   -Posted on 28 Aug 15
    -A global database name is formed from two components: a database name and a domain.
    -The database name and the domain name are determined by the following initialization parameters at database creation:

    Component - Parameter
    Database name - DB_NAME
    Domain containing the database - DB_DOMAIN

    -Example
    DB_NAME - DB_DOMAIN - Global Database Name
    sales - au.oracle.com - sales.au.oracle.com
    mktg - us.oracle.com - mktg.us.oracle.com

    -The DB_DOMAIN initialization parameter is only important at database creation time when it is used, together with the DB_NAME parameter, to form the database global name.

    -At this point, the database global name is stored in the data dictionary.

    -You must change the global name using an ALTER DATABASE statement, not by altering the DB_DOMAIN parameter in the initialization parameter file.

    -It is good practice, however, to change the DB_DOMAIN parameter to reflect the change in the domain name before the next database startup.

Post your comment / Share knowledge


Enter the code shown above:
 
(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)