My Oracle Support Banner

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

Last updated on AUGUST 23, 2021

Applies to:

Oracle Database - Enterprise Edition - Version 11.1.0.7 and later
Linux x86

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

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.