INSTANCE_NAME

Property	Description
Parameter type	String
Syntax	INSTANCE_NAME = instance_id
Default value	The instance's SID Note: The SID identifies the instance's shared memory on a host, but may not uniquely distinguish this instance from other instances.
Modifiable	No
Range of values	Any alphanumeric characters
Basic	No

In a Real Application Clusters environment, multiple instances can be associated with a single database service. Clients can override Oracle's connection load balancing by specifying a particular instance by which to connect to the database. INSTANCE_NAME specifies the unique name of this instance.

In a single-instance database system, the instance name is usually the same as the database name.

Note:

1. INSTANCE_NAME should not be confused with the SID, which actually uniquely identifies the instances shared memory on a host.

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) = ‘INSTANCE_NAME’;

NAME	VALUE	IS DEFAULT	ISSES_ MODIFIABLE	ISSYS_ MODIFIABLE	ISINSTANCE_ MODIFIABLE	IS DEPRECATED	DESCRIPTION
instance_name	MYDB	FALSE	FALSE	FALSE	FALSE	FALSE	instance name supported by the instance

Oracle initializatoin parameters