Hi,

We are upgrading from oracle 734 to 817 on a test box and wanted to know if someone could post their ora.init file from an Oracle 8.1.7 environment for me. Our DBA said it would save her much time converting our init file from 734 to 817 if she had one as a refference.

Thanks in advance for the help.

Mark Philpott

#### Oorzaak : Migratie naar Oracle 8.1.7
#### Aanpassing :

db_name = baan

remote_login_passwordfile = exclusive
control_files = $ORACLE_HOME/dbs/ctrl1baan.dbf, /oradata/baan/ctrl2baan.dbf
#rollback_segments = (r30)
rollback_segments = (r01,r02,r03,r04,r05,r06,r07,r08,r09,r10,r11,r12,r13,r14,r15,r16,r17,r18,r19,r20,r21,r22,r23,r24
,r25,r26,r27,r28,r29,r30)
#rollback_segments = (r01,r02,r03,r04,r05,r06,r07,r08,r09,r10)
max_rollback_segments = 31
transactions_per_rollback_segment = 25

# Obsolete V7 parameters
# obs. db_file_simultaneous_writes = 16
# obs. db_block_checkpoint_batch = 16
# obs. db_writers = 1
# obs. log_simultaneous_copies = 6
# obs. log_small_entry_max_size = 80
# obs. sequence_cache_entries = 10
# obs. sequence_cache_hash_buckets = 10
# obs. checkpoint_process = TRUE
# obs. row_cache_cursors = 128
# obs. sort_write_buffers = 4
# obs. temporary_table_locks = 2205


# tuning parameters

db_block_size = 8192
db_files = 50
# db_block_buffers = 57344
db_block_buffers = 51200
db_block_lru_latches = 3
parallel_min_servers = 3
parallel_max_servers = 15
shared_pool_size = 367001600
pre_page_sga = TRUE
#lock_shared_memory = TRUE
log_checkpoint_interval = 1024001
log_checkpoints_to_alert = TRUE
#processes = 500
processes = 900
sessions = 970
dml_locks = 2848
log_buffer = 1048576
enqueue_resources = 8192
cursor_space_for_time = TRUE
open_cursors = 5120
session_cached_cursors = 512
sort_area_retained_size = 65536
sort_area_size = 2097152
always_anti_join = HASH

max_dump_file_size = 10240
# ivm caretronic database link global_names op false
global_names = FALSE

event = "10181 trace name context forever, level 1500"

# Tuning parameter voor Asynchrone IO
# obs. use_async_io = TRUE

# TIMED_STATISTICS = TRUE

# Dump parameter
background_dump_dest = /oracle/app/oracle/admin/baan/bdump
core_dump_dest = /oracle/app/oracle/admin/baan/cdump
user_dump_dest = /oracle/app/oracle/admin/baan/udump

# Uncommenting the line below will cause automatic archiving if archiving has
# been enabled using ALTER DATABASE ARCHIVELOG.
log_archive_start = TRUE
log_archive_dest = /archive/
log_archive_format = log_%s_t%t.arch

Greetz Peter.