Identical parameters in RAC

Parameters that must have identical in RAC database:

In a RAC database there may contain several instances and the initialization parameters of all of the instances should not have identical setting. In fact the initialization parameters that are critical for database creation and affect certain database operations must have the same value for every instance in an Oracle RAC database.

Below is the list of initialization parameters that must have identical settings for all instances in a RAC database.

1)ACTIVE_INSTANCE_COUNT


2)ARCHIVE_LAG_TARGET


3)CLUSTER_DATABASE


4)CLUSTER_DATABASE_INSTANCES


5)COMPATIBLE


6)CONTROL_FILES


7)DB_BLOCK_SIZE


8)DB_DOMAIN


9)DB_FILES


10)DB_NAME


11)DB_RECOVERY_FILE_DEST


12)DB_RECOVERY_FILE_DEST_SIZE


13)DB_UNIQUE_NAME


14)DML_LOCKS (Only if set to zero).


15)INSTANCE_TYPE (RDBMS or ASM)


16)PARALLEL_MAX_SERVERS


17)REMOTE_LOGIN_PASSWORD_FILE


18)UNDO_MANAGEMENT

  • December 22, 2016 | 10 views
  • Comments