Summary of Oracle Database Basics (i)

Database name, instance name, database domain name, global database name, service name, which are some of the concepts that make many beginners easy to confuse. I believe many beginners are as confused as I am in the title of these concepts.

Let's get them all figured out right now.

First, database name what is the database name?

The database name is the identity of a database, just like a person's ID number. He uses parameter db_name to indicate that if a machine is loaded with multiple databases, then each database has a database name.

After the database installation or creation is complete, the parameter db_name is written to the parameter file. The format is as follows: DB_NAME=MYORCL ...

Database name the database name is used when you install the database, create a new database, create a database control file, modify the data structure, and back up and restore the database.

Second, database instance name what is the DB instance name?

The database instance name is the identity used to contact the operating system, meaning the database instance name is used for interaction between the database and the operating system. The instance name is also written to the parameter file, which is instance_name, and the instance name is also written to the registry in the Winnt platform. The database name and instance name can be the same or different. In general, database names and instance names are a one-to-many relationship, but if you are in an Oracle Parallel server architecture (that is, Oracle Real-time application clusters), the database name and instance name are a one-to-numerous relationship.

Third, database domain name what is the database domain name?

In the distributed database system, between different versions of the database server, regardless of whether the operating system is UNIX or Windows, each server can be remotely replicated through the database link, the database domain name is mainly used for Oracle replication in a distributed environment.

Examples include: distributed database of national transportation system, of which: Fujian node: fj.jtyz Fujian xiamen node: xm.fj.jtyz Jiangxi: jx.jtyz Jiangxi Shangrao:Sr.jx.jtyz This is the database domain name. The database domain name exists in the parameter file, and his parameter is db_domain.

Iv. database service Name what is the database service name?

Starting with the oracle9i version, a new parameter, the database service name, was introduced. The name of the parameter is service_name. If the database has a domain name, the database service name is the global database name; otherwise, the database service name is the same as the database name.

Summary of Oracle Database Basics (i)