Migration from Oracle 8i to 9i

[quester]

I am new to migration and I am assigned the tasks of -

"Migrating from Oracle 8i to Oracle 9i"

Also, there is a possibility that the O/S might be different (though, am not sure which O/S presently).

Could someone here give me some tips as to what are the things I must do and know before I start with the work?

Kindly help me as this is a critical and emergency assignment.

Many thanks in advance and anticipating a positive feedback from you guys...

Quester

[hrishy]

Hi

most important step....

Take a cold backup of the oracle8i database and store it in safe place and make sure you can restore it and it works..

1)install oracle9i software in a different home follow the OFA guidelines for this
2)either use the import export utility to do the migartion if your database is small or use the oracle migration assistant
3)Test Test Test your database particularly if your application makes use of oracle data dictionary heavily
4)your backup scripts also migh need tweaking in case you use svrmgrl utility in them..

These are from the top of my mind..myabe others could chip in their 2 cents

regards
Hrishy

[quester]

Thanks. Where can I find some documentation on this Migration Assistant? I have been searching for the document in the Oracle site, but unable to find it. Could someone help?

Any other feedback with more details please...


Quester

[hrishy]

Hi

You need to go to tahiti.oracle.com and on the search feild type oracle migration assistant..

regards
Hrishy

[dknight]

I would create the test environment with the same method you will use to do the migration. That is, migration assistant or exp/imp for both migration and creation of the test environment.

The new features handbook claims that there are differences in PL/SQL between 8i and 9i, but i haven´t done a migration to 9i yet though.

Good luck.

[grjohnson]

Depend on the size of your schemas (and DB). YOu may want to look at an EXP/IMP migration path. It may be preferred.

[pando]

http://metalink.oracle.com/metalink/...&p_id=159657.1

if different OS then bad luck, only exp/imp

[quester]

Thank you guys...

[acur8dba]

Here are my notes using the scripting method. Reads better in word.