Oracle Migration from 7.3 to 9i

[Eric Antunes]

Fred,

"Isn't it a bit too heavy to go through migration process from 7 to 8 then from 8 to 9, when, at least, you will have to export/import, as long as you change OS ? I think export 7 and import 9i is simplier."

It depends of the environment: if he runs Oracle E-Business Suite he will need to go via 7.x->8.x->9.x because he will need to apply APPS patches between the RDBMS upgrade.

Richard,

As Fred said, I gave you the wrong link... Here is the right one for HP-UX: http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=99206.1

Best Regards,

Eric Antunes

[Fred Ruffet]

Eric is true. As long as I am not involved in this kind of products, I generally forget them :)

Richard, what kind of application is running on this ?

Regards,

Fred

[Eric Antunes]

Hi again,

Since you are going to Linux read this one: http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=265262.1

Finaly, I STRONGLY recomend you to do this migration process on a Test environment first: this is the only way to practice & test before doing it on Producion environment!

Best Regards,

Eric Antunes

[Yogeeraj_1]

hi Richard!

also investigate about moving to 10g instead of 9i.

i believe it will be much better.

good luck
yogeeraj

[Steven E. Protter]

Fred,

I worked with a very good Oracle DBA for years. If a simple export/import would have handled it, thats what he'd have done.

I failed to migrate from 8.1.5 to 8.1.7 trying that methodology before my friend Arthur was brought aboard.

Thats why I recommend the Oracle doc, which will probably be incomplete and miss steps in combination with a tar openned with metalink to a US call center.

SEP

[Fred Ruffet]

SEP,

As said before, it probably depends on context and apps. I have migrated a client in nov 2003 from 7.3.4 (32 bits) to 9.2.0.3 (64 bits) with this exp/imp process. It still runs today (now 9.2.0.5). Fact is that it was on the same HP-UX machine and no other app than Oracle was invloved.

Regards,

Fred