Common Options

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

Initialization Parameters

Instance Name Value
  aq_tm_processes 1
  background_dump_dest {ORACLE_BASE}/admin/{DB_NAME}/bdump
  cluster_database true
  cluster_database_instances 2
  compatible 9.2.0.0.0
  control_files ("/u01/app/oracle/oradata/{DB_NAME}/control01.ctl", "/u01/app/oracle/oradata/{DB_NAME}/control02.ctl", "/u01/app/oracle/oradata/{DB_NAME}/control03.ctl")
  core_dump_dest {ORACLE_BASE}/admin/{DB_NAME}/cdump
  db_block_size 8KB
  db_cache_size 24MB
  db_domain
  db_file_multiblock_read_count 16
  db_name orcl
  dispatchers (PROTOCOL=TCP) (SERVICE={SID}XDB)
  fast_start_mttr_target 300
  hash_join_enabled TRUE
  java_pool_size 80MB
  job_queue_processes 10
  large_pool_size 8MB
  open_cursors 300
  pga_aggregate_target 24MB
  processes 150
  query_rewrite_enabled FALSE
  remote_listener LISTENERS_ORCL
  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
  undo_tablespace UNDOTBS1
  user_dump_dest {ORACLE_BASE}/admin/{DB_NAME}/udump
orcl1 instance_name orcl1
orcl1 instance_number 1
orcl1 local_listener LISTENER_ORCL1
orcl1 thread 1
orcl1 undo_tablespace UNDOTBS1
orcl2 instance_name orcl2
orcl2 instance_number 2
orcl2 local_listener LISTENER_ORCL2
orcl2 thread 2
orcl2 undo_tablespace UNDOTBS2

Control Files

Control file
/u01/app/oracle/oradata/{DB_NAME}/control01.ctl
/u01/app/oracle/oradata/{DB_NAME}/control02.ctl
/u01/app/oracle/oradata/{DB_NAME}/control03.ctl

Tablespaces

Status Name Type Extent management
ONLINE CWMLITE PERMANENT LOCAL
ONLINE DRSYS PERMANENT LOCAL
ONLINE EXAMPLE PERMANENT LOCAL
ONLINE INDX PERMANENT LOCAL
ONLINE ODM PERMANENT LOCAL
ONLINE SYSTEM PERMANENT LOCAL
ONLINE TEMP TEMPORARY LOCAL
ONLINE TOOLS PERMANENT LOCAL
ONLINE UNDOTBS1 PERMANENT , UNDO LOCAL
ONLINE UNDOTBS2 PERMANENT , UNDO LOCAL
ONLINE USERS PERMANENT LOCAL
ONLINE XDB PERMANENT LOCAL

Data Files

Status Name Tablespace Size(M)
ONLINE /u01/app/oracle/oradata/{DB_NAME}/cwmlite01.dbf CWMLITE 50
ONLINE {ORACLE_BASE}/oradata/{DB_NAME}/cwmlite01.dbf CWMLITE 50
ONLINE {ORACLE_BASE}/oradata/{DB_NAME}/drsys01.dbf DRSYS 20
ONLINE /u01/app/oracle/oradata/{DB_NAME}/example01.dbf EXAMPLE 250
ONLINE {ORACLE_BASE}/oradata/{DB_NAME}/example01.dbf EXAMPLE 250
ONLINE /u01/app/oracle/oradata/{DB_NAME}/indx01.dbf INDX 100
ONLINE {ORACLE_BASE}/oradata/{DB_NAME}/indx01.dbf INDX 100
ONLINE /u01/app/oracle/oradata/{DB_NAME}/odm01.dbf ODM 50
ONLINE {ORACLE_BASE}/oradata/{DB_NAME}/odm01.dbf ODM 50
ONLINE /u01/app/oracle/oradata/{DB_NAME}/system01.dbf SYSTEM 800
ONLINE {ORACLE_BASE}/oradata/{DB_NAME}/system01.dbf SYSTEM 800
ONLINE /u01/app/oracle/oradata/{DB_NAME}/temp01.dbf TEMP 250
ONLINE {ORACLE_BASE}/oradata/{DB_NAME}/temp01.dbf TEMP 250
ONLINE /u01/app/oracle/oradata/{DB_NAME}/tools01.dbf TOOLS 100
ONLINE {ORACLE_BASE}/oradata/{DB_NAME}/tools01.dbf TOOLS 100
ONLINE /u01/app/oracle/oradata/{DB_NAME}/undotbs01.dbf UNDOTBS1 400
ONLINE {ORACLE_BASE}/oradata/{DB_NAME}/undotbs01.dbf UNDOTBS1 400
ONLINE /u01/app/oracle/oradata/{DB_NAME}/undotbs02.dbf UNDOTBS2 400
ONLINE {ORACLE_BASE}/oradata/{DB_NAME}/undotbs02.dbf UNDOTBS2 400
ONLINE /u01/app/oracle/oradata/{DB_NAME}/users01.dbf USERS 100
ONLINE {ORACLE_BASE}/oradata/{DB_NAME}/users01.dbf USERS 100
ONLINE /u01/app/oracle/oradata/{DB_NAME}/xdb01.dbf XDB 150
ONLINE {ORACLE_BASE}/oradata/{DB_NAME}/xdb01.dbf XDB 150

Redo Log Groups

Group Size(K) Thread File Name
1 102400 1 /u01/app/oracle/oradata/{DB_NAME}/redo01.log
2 102400 1 /u01/app/oracle/oradata/{DB_NAME}/redo02.log
3 102400 2 /u01/app/oracle/oradata/{DB_NAME}/redo03.log
4 102400 2 /u01/app/oracle/oradata/{DB_NAME}/orcl_redo2_2.log