- 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 .