1 SID, GDBNAME,DB_NAME and DB_DOMAIN

• SID: Oracle System identify . It is used to identify the Oracle Instance.
• GDBNAME: It is parameter being set during the DBCA. If no specify, usually set as same as SID.
• DB_NAME: It is the Database name and specify in the create database  sql statement . When use DBCA to create the database, it is being set from the “SID”. However. the DB_NAME only allow 8 charts. Therefore, if my SID is oracledb1, the DB_NAME would be oracledb. It is one of the parameter in the spifle/pfile.
• DB_DOMAIN: It is part of the parameter.  If the DB_DOMAIN set for localdomain and DB_NAME is oradb1, the global name would be oradb1.localdomain.  When configure with Oracle Stream, we need to set up the DB_DOMAIN and enable the Global_name.

Below is the sample of the DBCA responds file and the result of the database .

Responds file:

• GDBNAME=oradb1.panda1.localdomain
• DBNAME=oradb1

Instance

• ORACLE_SID=oradb1
• DB_NAME=oradb1
• DB_DOMAIN=panda1.localdomain