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
