Wednesday, September 24, 2008

CLUSTER_INTERCONNECTS

Property

Description

Parameter type

String

Syntax

CLUSTER_INTERCONNECTS = ifn [: ifn ] ...

Default value

There is no default value.

Modifiable

No

Range of values

One or more IP addresses, separated by colons

Basic

No

CLUSTER_INTERCONNECTS provides Oracle with information about additional cluster interconnects available for use in Real Application Clusters environments.

The CLUSTER_INTERCONNECTS parameter can be used to override the default interconnect with a preferred cluster traffic network. This parameter is useful in Data Warehouse systems that have reduced availability requirements and high interconnect bandwidth demands. You can also use CLUSTER_INTERCONNECTS to override the default interconnect chosen by Oracle.

For example, if you are running two instances of Oracle for two databases on the same machine, then you can load balance the interconnect traffic to different physical interconnects. This does not reduce Oracle availability.

Note:

1. This parameter was introduced in Oracle9i.

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) = 'CLUSTER_INTERCONNECTS';

NAME

VALUE

IS

DEFAULT

ISSES_

MODIFIABLE

ISSYS_

MODIFIABLE

ISINSTANCE_

MODIFIABLE

IS

DEPRECATED

DESCRIPTION

cluster_interconnects

TRUE

FALSE

FALSE

FALSE

FALSE

interconnects for RAC use

Oracle initializatoin parameters

No comments:

Post a Comment