DBCA Creates Database Global Name In Different Format Than Is Specified in db_domain Parameter (Doc ID 264547.1)

Last updated on JULY 25, 2023

Applies to:

Symptoms

 When the DB is created using the DBCA and in the step 2 OF 8 the 'GENERAL PURPOSE' option is selected then the global name is of the format DB_NAME.<Domain_Name> though the value for db_domain is EMPTY.

SQL> SELECT * FROM global_name;

GLOBAL_NAME
--------------------------------------------------------------------------------
DB_NAME.<Domain_Name>

SQL> show parameter db_domain;

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_domain string

Cause