DB_UNIQUE_NAME

Property	Description
Parameter type	String
Syntax	DB_UNIQUE_NAME = database_unique_name
Default value	Database instances: the value of DB_NAME Automatic Storage Management instances: +ASM
Modifiable	No
Basic	Yes
Real Application Clusters	Multiple instances must have the same value.

DB_UNIQUE_NAME specifies a globally unique name for the database. 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:

1. This parameter was introduced in 10g.

2. Query for the current value of the parameter

select name, value, isdefault, isses_modifiable, issys_modifiable,

isinstance_modifiable, isdeprecated, description

from v$parameter

where upper(name) = ‘DB_UNIQUE_NAME’;

NAME	VALUE	IS DEFAULT	ISSES_ MODIFIABLE	ISSYS_ MODIFIABLE	ISINSTANCE_ MODIFIABLE	IS DEPRECATED	DESCRIPTION
db_unique_name	mydb	TRUE	FALSE	FALSE	FALSE	FALSE	Database Unique Name

Oracle initializatoin parameters