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 |
|
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