Oracle 参数 DB_NAME 官方解释,作用,如何配置最优化建议

本站中文解释

DB_NAME是Oracle中的数据库名称参数,用于识别实例及其数据库的名称。如果未指定DB_NAME参数,则默认名称为ORCL。

正确设置DB_NAME参数,首先通过如下SQL语句查询当前参数的值:

SELECT name, value
FROM v$parameter
WHERE name = ‘db_name’;

如果参数当前值为ORCL, 那么可以使用ALTER SYSTEM SET db_name=’用户自定义数据库名’ SCOPE=SPFILE;进行设置,其中用户自定义数据库名可以根据自身情况自行命名。

官方英文解释

DB_NAME specifies a database identifier of up to 8 characters.

Property Description

Parameter type

String

Syntax

DB_NAME = database_name

Default value

There is no default value.

Modifiable

No

Modifiable in a PDB

No

Basic

Yes

Oracle RAC

You must set this parameter for every instance. Multiple instances must have the same value.

This parameter must be specified and must correspond to the name specified in the CREATE DATABASE statement.

If you have multiple databases, the value of this parameter should match the Oracle instance identifier of each one to avoid confusion with other databases running on the system. The value of DB_NAME must be the same in both the standby and production initialization parameter files.

The database name specified in either the STARTUP command or the ALTER DATABASE ... MOUNT statement for each instance of the cluster database must correspond to the DB_NAME initialization parameter setting.

The following characters are valid in a database name: alphanumeric characters, underscore (_), number sign (#), and dollar sign ($). No other characters are valid. The database name must start with an alphabetic character. Oracle removes double quotation marks before processing the database name. Therefore you cannot use double quotation marks to embed other characters in the name. The database name is case insensitive.

See Also:

Oracle Database
Administrator’s Guide
and Oracle Real Application
Clusters Administration and Deployment Guide
for more information on setting this parameter


数据运维技术 » Oracle 参数 DB_NAME 官方解释,作用,如何配置最优化建议