Ask a Question

State the initialization parameters that must have same value for every instance in an Oracle RAC database

306 views
in Storage - ASM by ACE (20,920 points)

1 Answer

by ACE (20,920 points)

Some initialization parameters are critical at the database creation time and must have same values.Their value must be specified in SPFILE or PFILE for every instance.The

list of parameters that must be identical on every instance are given below:
ACTIVE_INSTANCE_COUNT
ARCHIVE_LAG_TARGET
COMPATIBLE
CLUSTER_DATABASE
CLUSTER_DATABASE_INSTANCE
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

Categories

Most popular tags

rac asm 11g 12c tuning goldengate single node rac node eviction rman 11g new features streams tablespace dataguard oracle diagnostic files cloud rac training dba training incremental backups temp tablespace multitenant undo grid flashback xml db change tracking 12c new features dba undo management sybase asmb grid computing ora-19809 free space fan scripts taf clusterware cluster sql sql server oracle training oracle dba jobs dba jobs rules lcr grid installation oracle dba ora-19804 archive logs active dataguard replication nosql sort usage v$temp_space_header instance recovery haip memory tuning stream control files corrupt jobs ora-1555 rollback segment temp physical standby dgmgrl deadlock retention sga 9i backups vip delete components 10g standby upgrade architecture pdb instance trail gg pfile oracle database 19c new features for developers oracle database 19c new features for administrators oracle database 19c new features for dba oracle database 19c database new features ora-00214: control file version inconsistent with file ora-00214 control file inconsistent control file version inconsistent with file ora-00214 control file version inconsistent with file sysbackup privilege sql interface improvements rman enhancements oracle 12c new feature oracle 12c new feature rman enhancements ora-19625 error identifying file rename pdb

Related questions

Snow Theme by Q2A Market
Powered by Question2Answer
...