Summary of basic Oracle database knowledge (1): Basic oracle knowledge

Summary of basic Oracle database knowledge (1): Basic oracle knowledge

Database Name, Instance name, database domain name, global database name, and service name are several confusing concepts for many beginners. I believe that many beginners are confused by these concepts on the title just like me.

Now let's figure them out.

1. What is the database name?

The database name is the ID of a database, just like the ID card number of a person. He uses the DB_NAME parameter to indicate that if multiple full databases are installed on a machine, each database has a database name.

After the database is installed or created, the parameter DB_NAME is written to the parameter file. The format is as follows: DB_NAME = myorcl...

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

2. What is the database instance name?

The database instance name is the identifier used to contact the operating system, that is, the interaction between the database and the operating system uses the database instance name. The instance name is also written to the parameter file. The parameter is instance_name. On the winnt platform, the Instance name is also written to the Registry. The Database Name and Instance name can be the same or different. In general, the database name and Instance name are one-to-one, but in the oracle Parallel Server Architecture (that is, the oracle Real-time application cluster, the Database Name and Instance name are one-to-multiple relationships.

3. What is a database domain name?

In the distributed database system, database servers of different versions can be remotely copied between servers, regardless of whether the operating system is unix or windows, the database domain name is mainly used for replication in the oracle distributed environment.

Example: the distributed database of the National Transportation Administration System, in which: Fujian node: fj. jtyz Fujian Xiamen node: xm. fj. jtyz Jiangxi: jx. jtyz Shangrao, Jiangxi: sr. jx. jtyz: This is the database domain name. The database domain name exists in the parameter file. Its parameter is db_domain.

4. What is the database service name?

A new parameter, that is, the Database Service name, is introduced from oracle9i. The parameter name 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.