i want to upgrade from Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 32 bit to Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 64 bit.
both the new server and old server details are below
OS=Microsoft windows server 2003 32bit.
Oracle Version= Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 32 bit
OS=Microsoft Windows server 2008 64bit
Oracle version= Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 64 bit.
i take cold backup from OLD SERVER and try to restore it in NEW SERVER,
but i come with an issue, and search help for it, and i come to know that i need to upgrade my NEW DATABASE.
how could i do upgrade it?
Pl see the documentation - Postinstallation Database Creation on Windows
Zoltan - 32-bit data files can be copied over and read by 64-bit software - exp/imp is not necessary, but is certainly an option
Edit - the above link is for the same version of the database on source and target - in your case, additional upgrade steps will be necessary as per the 10gR2 Upgrade Guide - how big is the database and how much downtime can you afford ?
Yes I see that both 32 and 64 bit datafiles using the same Little endian but I think upgrade is still required.
As I see using RMAN also a good option.
See this MOS doc for more info