INSTANCE_TYPE

Property	Description
Parameter type	String
Syntax	INSTANCE_TYPE = { RDBMS | ASM }
Default value	RDBMS
Modifiable	No
Basic	No
Real Application Clusters	Multiple instances must have the same value.

INSTANCE_TYPE specifies whether the instance is a database instance or an Automatic Storage Management instance.

Values:

· RDBMS

The instance is a database instance.

· ASM

The instance is an Automatic Storage Management instance.

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

NAME	VALUE	IS DEFAULT	ISSES_ MODIFIABLE	ISSYS_ MODIFIABLE	ISINSTANCE_ MODIFIABLE	IS DEPRECATED	DESCRIPTION
instance_type	RDBMS	TRUE	FALSE	FALSE	FALSE	FALSE	type of instance to be executed

Oracle initializatoin parameters