REAL APPLICATION CLUSTER : spfile

• Parameters That Must Have Unique Settings on All Instances

# INSTANCE_NUMBER
You must set a unique value for INSTANCE_NUMBER for each instance and you cannot use a default value
# UNDO_TABLESPACE
When you specify UNDO_TABLESPACE with automatic undo management enabled,
then set this parameter to a unique undo tablespace name for each instance

To simplify administration, use the same number for both the THREAD and INSTANCE_NUMBER parameters

• Parameters that Must Have Identical Settings on All Instances

# ACTIVE_INSTANCE_COUNT

# ARCHIVE_LAG_TARGET

# CLUSTER_DATABASE

# CLUSTER_DATABASE_INSTANCES

# CONTROL_FILES

# DB_BLOCK_SIZE

# DB_DOMAIN

# DB_FILES

# DB_NAME

# DB_RECOVERY_FILE_DEST

# DB_RECOVERY_FILE_DEST_SIZE

# DB_UNIQUE_NAME

# UNDO_MANAGEMENT

• Parameters that Should Have Identical Settings on All Instances

# ARCHIVE_LAG_TARGET

# LOG_ARCHIVE_FORMAT

# SPFILE

# TRACE_ENABLED

# UNDO_RETENTION

• Specific parameter for RAC

# CLUSTER_DATABASE

Enables a database to be started in cluster mode. Set this parameter to TRUE.

# CLUSTER_DATABASE_INSTANCES

Sets the number of instances in your Oracle RAC environments

# CLUSTER_INTERCONNECTS

Specifies the cluster interconnect when there is more than one interconnect

alter system set SGA_TARGET = 2G scope=memory sid='MADB1';

alter system set SGA_TARGET = 2G scope=memory sid='*'

alter system reset open_cursors scope=spfile sid='prod1';