Moving and upgrading DB at the same time

In order to upgrade a 9i DB (Oracle 9.2.0.5 on Redhat Linux Adv. Server 2.1 32 bit) to version 10g (Oracle 10.2.0.3 on Redhat Linux Ent. Ed. V 4 64 bit) I will move all files of the shut down DB to a new server where the target version of Oracle is istalled and take care that datafile paths on the new server are the same as on the old one (no need to rename anything in the controlfile of the cold copy).

Since on the new server only the new Version of Oracle is installed, the only thing I can do is just upgrade the DB copy without being able to open it in order to check that everything is all right.

May I assume that there won't be any platform related issues? I just don't know if this switch is considered a platform change. After all, both Linux boxes are rather different versions of Redhat (running on Intel hardware).

Even if there is no platform issue, which are going to be the pits and falls?

I would like to avoid exp/imp because for a schemawise transfer I would need to precreate users with all privileges, tablespaces, etc. Full exp/imp is not adequate when going to a different version of Oracle.

Thanks in advance

Rick Denoire Received on Sun Apr 27 2008 - 17:35:54 CDT