Name in Oracle

The name explanation in Oracle

Db_name database name

The database name is an identifier for the entire database and cannot be more than 8 characters

There is no default value and cannot be changed. In Oracle RAC, you must set this parameter for each instance, multiple instances

Must have the same value.

Db_domain Database domain name

The database is in the same domain, there is no default value, and the corresponding Db_domain parameter cannot be changed for better management of the distributed database

Determined according to the actual situation. Multiple instances in an Oracle RAC must have the same db_domain

Global_names Global Database name

The full identifier of the database, as determined by the time the database was created, by default the Db_name.db_domain parameter

Any modifications to the db_name and Db_domain parameters in the parameter file later do not affect Global_names's

Value, if you want to modify the value of Global_names, you can only use ALTER DATABASE rename Global_names to

<db_name.db_domain> make changes, then modify the corresponding parameters

Service_names Service Name

The default value is Db_unique_name.db_domain, modified with alter system, not set in Oracle RAC

Service_names. Provides the name that the client uses to connect to the database, which is primarily connected to the database by the service name (JDBC can

Connection via SID). This parameter corresponds to a database, not an instance, and a database can correspond to multiple

Service_names alter system set servces_name= ' Service1,service2 ';

Service_names, whether you are stating that you can have multiple values

instance_name Instance Name

The identifier for the DB instance, which is the same as the default and SID, that corresponds to the instance_name parameter, which

Parameters can be arbitrarily modified, database instance name modification can be done via nid (Nid-help)

Db_unique_name database only one

Used primarily in DG, the default value is db_name,asm in +asm,oracle multiple instances in the RAC should have the same value

This article is from "The girl said" blog, please be sure to keep this source http://sugarlovecxq.blog.51cto.com/6707742/1692803

Name in Oracle