Oracle 参数 DB_DOMAIN 官方解释，作用，如何配置最优化建议
本站中文解释
DB_DOMAIN是一个固定参数，它指定在Oracle数据库中使用的域，即所有实例变量允许存在的域。它是在安装过程中被设定的，它可以有一个或多个名字，分隔符是一个句点（.）。一旦确定，它不能更改，而且不允许更改。
正确设置Oracle参数DB_DOMAIN的方法如下：
1.在安装过程中设置DB_DOMAIN参数。
2.设置DB_DOMAIN参数的格式应该是一串小写字母，比如example.domain.com。
3.设置不应包含任何未授权的特殊字符或空格。
4.只允许每个实例中使用一个DB_DOMAIN参数，可以跨实例使用。提供不同的域名，如果需要使用多个实例，务必要记住另一个实例的DB_DOMAIN参数。
5.DB_DOMAIN参数在每个实例的pfile或spfile中应该保持一致。
官方英文解释
In a distributed database system, DB_DOMAIN specifies the logical location of the database within the network structure.
| Property | Description |
|---|---|
|
Parameter type |
String |
|
Syntax |
|
|
Default value |
There is no default value. |
|
Modifiable |
No |
|
Modifiable in a PDB |
Yes |
|
Range of values |
Any legal string of name components, separated by periods and up to 128 characters long (including the periods). |
|
Basic |
Yes |
|
Oracle RAC |
You must set this parameter for every instance, and multiple instances must have the same value. |
You should set this parameter if this database is or ever will be part of a distributed system. The value consists of the extension components of a global database name, consisting of valid identifiers (any alphanumeric ASCII characters), separated by periods.
Note:
Oracle recommends that you specify DB_DOMAIN as a unique string for all databases in a domain.
This parameter allows one department to create a database without worrying that it might have the same name as a database created by another department. If one sales department’s DB_DOMAIN is JAPAN.EXAMPLE.COM, then their SALES database (SALES.JAPAN.EXAMPLE.COM) is uniquely distinguished from another database with DB_NAME = SALES but with DB_DOMAIN = US.EXAMPLE.COM.
DB_DOMAIN should start with an alphabetic character and exclude these characters:
"!@%^&*()+=\\|`~[{]};:'\",<>/?"See Also:
-
Oracle Database
Administrator’s Guide for more information on setting this parameter -
The data dictionary view “GLOBAL_NAME”
