RAC
Cluster Configuration

Common Options

Option Name Selected
Example Schemas false
Oracle Data Mining false
Oracle Intermedia false
Oracle JVM false
Oracle Label Security false
Oracle OLAP false
Oracle Spatial false
Oracle Text false
Oracle Ultra Search false
Oracle XML DB false

Initialization Parameters

Instance Name Value
  background_dump_dest {ORACLE_BASE}/admin/{DB_NAME}/bdump
  cluster_database true
  cluster_database true
  cluster_database_instances 2
  compatible 9.2.0.0.0
  control_files ("/dev/raw/raw10", "/dev/raw/raw11")
  core_dump_dest {ORACLE_BASE}/admin/{DB_NAME}/cdump
  db_block_size 8KB
  db_cache_size 50MB
  db_domain
  db_file_multiblock_read_count 16
  db_name RAC
  fast_start_mttr_target 300
  hash_join_enabled TRUE
  java_pool_size 50MB
  large_pool_size 8MB
  open_cursors 300
  pga_aggregate_target 24MB
  processes 150
  query_rewrite_enabled FALSE
  remote_listener LISTENERS_RAC
  remote_listener LISTENERS_RAC
  remote_login_passwordfile exclusive
  shared_pool_size 80MB
  sort_area_size 524288
  star_transformation_enabled FALSE
  timed_statistics TRUE
  undo_management AUTO
  undo_retention 10800
  user_dump_dest {ORACLE_BASE}/admin/{DB_NAME}/udump
RAC1 instance_name RAC1
RAC1 instance_number 1
RAC1 local_listener LISTENER_RAC1
RAC1 thread 1
RAC1 undo_tablespace UNDOTBS1
RAC2 instance_name RAC2
RAC2 instance_number 2
RAC2 local_listener LISTENER_RAC2
RAC2 thread 2
RAC2 undo_tablespace UNDOTBS2

Control Files

Control file
/dev/raw/raw10
/dev/raw/raw11

Tablespaces

Status Name Type Extent management
ONLINE SYSTEM PERMANENT LOCAL
ONLINE TEMP TEMPORARY LOCAL
ONLINE TOOLS PERMANENT LOCAL
ONLINE UNDOTBS1 PERMANENT , UNDO LOCAL
ONLINE UNDOTBS2 PERMANENT , UNDO LOCAL
ONLINE USER_DATA PERMANENT LOCAL
ONLINE USER_NDX PERMANENT LOCAL

Data Files

Status Name Tablespace Size(M)
ONLINE /dev/raw/raw5 SYSTEM 400
ONLINE /dev/raw/raw9 TEMP 100
ONLINE /dev/raw/raw8 TOOLS 10
ONLINE /dev/raw/raw16 UNDOTBS1 450
ONLINE /dev/raw/raw17 UNDOTBS2 450
ONLINE /dev/raw/raw6 USER_DATA 50
ONLINE /dev/raw/raw7 USER_NDX 20

Redo Log Groups

Group Size(K) Thread File Name
1 50 1 /dev/raw/raw18
2 50 1 /dev/raw/raw19
3 50 2 /dev/raw/raw20
4 50 2 /dev/raw/raw21