The difference between Oracle database db_name, DBID, db_unique_name, etc.

Directory

• Db_name
• DBID
• Db_unique_name:
• Instance_name:
• Sid:
• Service_Name
• Global_database_name:

Db_name

① is a database name that cannot exceed 8 characters in length, and is recorded in DataFile, Redolog, and control file

② db_name Same and db_unique_name different in Dataguard environment

③ in a RAC environment, the db_name of each node are the same, but instance_name different

④db_name also plays a role in dynamically registering for monitoring, regardless of whether the Service_name,pmon process is defined with db_name dynamic registration monitoring

DBID

①dbid can be seen as a representation of db_name within the database, which is calculated using the db_name-associative algorithm when the database is created.

② it exists in the DataFile and control file to represent the attribution of the data file, so dbid is unique, for different databases, db_name can be the same, but dbid must be unique, for example in Dataguard, the db_ of the master repository Name is the same, but dbid must be different (see a very vivid example, that is, you can have the same name, but the identity card number must be different)

Db_unique_name:

① in Dataguard, the master repository has the same db_name, in order to differentiate, there must be different db_unique_name

②db_unique_name in the DG will affect the dynamic registration of the service_name, that is, if the use of dynamic registration, the registered service_name is db_unique_name, but the instance is instance_name, that is, sid

Instance_name:

① the name of the DB instance, the instance_name default is SID, and the database name (db_name) is generally the same or different

②initsid.ora and Orapwsid files to be consistent with instance_name

③instance_name will affect the name of the process

Sid:

① is an environment variable in the operating system, and the Oracle_home,oracle_base usage is the same

② to get the instance name in the operating system, you must use ORACLE_SID. And the oracle_sid must be consistent with the value of instance_name

Service_Name

① database and Client connection is the service name used

② in Dataguard, if dynamic registration is used, it is recommended to use the same service_names in the master repository

③ in Dataguard, if static registration is used, it is recommended to enter the same service name (SERVICE_NAME) in listener on the master repository.

④ If the monitor is statically registered, then the service_name equals the Global_database_name value in the Listener.ora file.

Global_database_name:

①global_database_name is the listener configured external network connection name, can be any value

② the service_name in the Tnsnames.ora file that the client configuration listens to is consistent with this global_dbname.

③ Configure static Listener registration, you need to enter SIDS and GLOBAL_NAME

This digest is from the address: http://www.itpux.com/thread-236-1-1.html

The difference between Oracle database db_name, DBID, db_unique_name, etc.