initDB01.ora erstellen

Die Parameterdatei der Instance DB01 ist initDB01.ora. Diese Datei lässt sich mit dem cat Befehl erzeugen.

oracle@tux01:~$ cat >product/920/dbs/initDB01.ora <<EOF
########################################################################
#                    Instance DB01                                     #
db_name              = DB01
instance_name        = DB01
service_names        = DB01
db_cache_size        = 100M
pga_aggregate_target = 50M
shared_pool_size     = 50M
aq_tm_processes      = 0
log_archive_start    = FALSE
log_archive_dest     = /oracle/oradata/DB01/archive
log_archive_format   = "T%TS%S.arc"
background_dump_dest = /oracle/admin/DB01/bdump
user_dump_dest       = /oracle/admin/DB01/udump
core_dump_dest       = /oracle/admin/DB01/cdump
control_files        = ("/oracle/oradata/DB01/control1.ctl",
                        "/oracle/oradata/DB01/control2.ctl")
oracle_trace_enable  = FALSE

########################################################################
#                             Resources                                #
db_block_checksum             = FALSE
db_block_size                 = 8192
db_file_multiblock_read_count = 8
db_files                      = 100
dml_locks                     = 1000
fast_start_mttr_target        = 900
java_pool_size                = 0
max_enabled_roles             = 30
open_cursors                  = 500
parallel_automatic_tuning     = FALSE
parallel_max_servers          = 8
processes                     = 100
sga_max_size                  = 100M
undo_management               = auto
undo_tablespace               = undo
undo_retention                = 5400
workarea_size_policy          = auto

########################################################################
#                          Optimizer                                   #
compatible                 = 9.2.0
cursor_sharing             = EXACT
cursor_space_for_time      = FALSE
optimizer_index_caching    = 80
optimizer_index_cost_adj   = 25
optimizer_max_permutations = 1000
optimizer_mode             = CHOOSE
timed_statistics           = TRUE

########################################################################
#                      Logs & Dumps                                    #
log_checkpoint_timeout = 10000
max_dump_file_size     = 10M

########################################################################
#                           Misc                                       #
global_names                = FALSE
os_authent_prefix           = ""
o7_dictionary_accessibility = TRUE
remote_login_passwordfile   = NONE
EOF