Parameters for an Oracle RAC Database
Parameters that Must Have Identical Settings on All Instances
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
PARALLEL_MAX_SERVERS
REMOTE_LOGIN_PASSWORD_FILE
UNDO_MANAGEMENT
Parameters that Should Have Identical Settings on All Instances
LOG_ARCHIVE_FORMAT
UNDO_RETENTION
ARCHIVE_LAG_TARGET
LICENSE_MAX_USERS
Parameters that Must Have Unique Settings on All Instances
SQL> show parameter INSTANCE_NUMBER
instance_number integer 1
SQL> Show parameter INSTANCE_NUMBER
instance_number integer 2
SQL> show parameter THREAD
thread integer 1
SQL> show parameter THREAD
thread integer 2
SQL> show parameter UNDO_TABLESPACE
undo_tablespace string UNDOTBS1
SQL> show parameter UNDO_TABLESPACE
undo_tablespace string UNDOTBS2
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/16348200/viewspace-614728/ ，如需转载，请注明出处，否则将追究法律责任。
