oracle RAC initialization parameter

Parameters that Must Have Identical Settings on All Instances

The following list contains the parameters that must be identical on every instance:

• ACTIVE_INSTANCE_COUNT

• ARCHIVE_LAG_TARGET

• CLUSTER_DATABASE

• CLUSTER_DATABASE_INSTANCES

• COMPATIBLE

• CONTROL_FILES

• DB_BLOCK_SIZE

• DB_DOMAIN

• DB_FILES

• DB_NAME

• DB_RECOVERY_FILE_DEST

• DB_RECOVERY_FILE_DEST_SIZE

• DB_UNIQUE_NAME

• INSTANCE_TYPE (RDBMS or ASM)

• PARALLEL_MAX_SERVERS

• REMOTE_LOGIN_PASSWORD_FILE

• UNDO_MANAGEMENT

The SERVICE_NAMES initialization parameter specifies one or more names by which clients can connect to the instance. The instance registers its service names with the Listener. When a client requests a service, the Listener determines which instances offer the requested service and routes the client to the appropriate instance.