export from 8.1.7 and import in 9.2

To migrate, you normaly do that at the installation of the new version and then the process is proposed by the installation assistant. If you want to migrate after the installation, you need to do that on the server with the both engine. I never try your system but it seems to be not valuable probably because of the migration assistant search for special enttries or files (IE: installation file of the previous version).

----- Original Message -----
From: "Kirpal Chana " <oracledba-ezmlmshield-x66989068.[Email address protected]
To: "LazyDBA Discussion" <[Email address protected]
Subject: ORA-01571
Date: Tue, 31 May 2005 11:50:57 +0100

>
> 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.
> **********************************************************************
>
>
>
> --------
> website: http://www.LazyDBA.com
> Please don't reply to RTFM questions
> Oracle documentation is here: http://tahiti.oracle.com
> To unsubscribe: see http://www.lazydba.com/unsubscribe.html
> To subscribe: see http://www.lazydba.com
> By using this list you agree to these terms:http://www.lazydba.com/legal.html



DEGAND XAVIER

DX SPRL

BRUSSELS, BELGIUM


Oracle LazyDBA home page