Hi all
I am trying to upgrade oracle 8.1.7 database to 9.2.0.6 to a new server.
I have installed all oracle products onto new server and it works.
Also created the same file structure for databases.
I have copied all database, log and control files to new server.
Problem is when I try to migrate this database to 9.2.0 through "startup migrate" command, following error occurs
I tried changing some parameters in the intP.ora file, but cannot get past this error. Please Help

*******************
SQL> startup migrate
ORACLE instance started.

Total System Global Area 622417620 bytes
Fixed Size 456404 bytes
Variable Size 352321536 bytes
Database Buffers 268435456 bytes
Redo Buffers 1204224 bytes
Database mounted.
ORA-01571: redo version 9.2.0.0.0 incompatible with ORACLE version 8.1.7.0.0
************************
initP.ora file looks like this ( i have taken out some standard lines)

db_file_multiblock_read_count = 16
log_buffer = 1048576

timed_statistics = true
_trace_files_public = true

global_names = false

optimizer_mode = choose
optimizer_index_cost_adj = 25
optimizer_index_caching = 90

remote_os_authent = true
compatible = 8.1.7.0.0
open_cursors = 2048

enqueue_resources = 1024
dml_locks = 1024

# added for summit 9.4
partition_view_enabled = TRUE
workarea_size_policy = AUTO
pga_aggregate_target = 256M
java_pool_size = 40M
sql_trace = FALSE
undo_management = AUTO

# tmp for 9i upgrade
job_queue_processes = 0
aq_tm_processes = 0
_system_trig_enabled = FALSE

*****************************
> Kirpal
>
>
>
>


**********************************************************************
This e-mail and any attachment is confidential and intended
soley for use of the individual or entity to whom it is addressed.
If you have received this e-mail in error please notify the sender
and delete the mail from your system.

The Lambeth Building Society is authorised and regulated by the
Financial Services Authority.
**********************************************************************


Oracle LazyDBA home page