Oracle 参数 DB_UNIQUE_NAME 官方解释，作用，如何配置最优化建议
本站中文解释
:
DB_UNIQUE_NAME是oracle实例唯一名称参数，它表示当前实例的唯一标识符。
要正确设置DB_UNIQUE_NAME参数，应以下步骤操作：
1.确认已经建立实例，生成参数文件；
2.在初始化参数文件中找到DB_UNIQUE_NAME，如果没有它，在文件的最下面添加该参数；
3.在DB_UNIQUE_NAME后面输入一个唯一的实例名，多个单词请使用下划线格式，比如my_instance_name；
4.保存并关闭参数文件，在安装的时候让Oracle加载该参数文件。
官方英文解释
DB_UNIQUE_NAME specifies a globally unique name for the database.
| Property | Description |
|---|---|
|
Parameter type |
String |
|
Syntax |
|
|
Default value |
Database instances: the value of Oracle Automatic Storage Management instances: |
|
Modifiable |
No |
|
Modifiable in a PDB |
No |
|
Basic |
Yes |
|
Oracle RAC |
Multiple instances must have the same value. |
Databases with the same DB_NAME within the same DB_DOMAIN (for example, copies of a database created for reporting or a physical standby) must have a unique DB_UNIQUE_NAME. Every database’s DB_UNIQUE_NAME must be unique within the enterprise.
The value of DB_UNIQUE_NAME can be up to 30 characters and is case insensitive. The following characters are valid in a database name: alphanumeric characters, underscore (_), number sign (#), and dollar sign ($).
Note:
DB_UNIQUE_NAME is used by several components within an Oracle instance to default file names or file paths, such as the default for the DG_BROKER_CONFIG_FILEn initialization parameter. In these cases, on UNIX platforms, the dollar sign ($) character will be removed from the path or file name, because the character is used by Oracle to define the start of an environment variable substitution within a path or file name.
Note:
As part of their operations, some database tools or utilities create a string that uniquely identifies a database. The string may include the DB_UNIQUE_NAME for a database, and other identifying information for the database, such as the database SID. Oracle Database restricts some identifiers to 30 characters, so using a short DB_UNIQUE_NAME can help prevent ORA-00972 “identifier is too long” messages from database tools and utilities that create a string that includes the DB_UNIQUE_NAME.
See Also:
Oracle Data Guard Concepts
and Administration and Oracle Database
Administrator’s Guide for more information on setting this parameter
