Sunday, February 3, 2013

0 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

image

Instance

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

image

0 comments:

Post a Comment

 

SQL Panda Copyright © 2011 - |- Template created by O Pregador - |- Powered by Blogger Templates