can any one provide what is the best method upgrade from oracle 10.2.0.1.0 32bit to 18.104.22.168.0 64bit
I have 2 option:
1. upgrade the source version to at list 10.2.0.2.0
and then upgrade the new 10.2.0.2.0 to 22.214.171.124.0
2. upgrade the source version to 11.1.x,x on the new 64 bit server
and then upgrade to 126.96.36.199.0
I prefer not to change the production server.
is there any know issue choosing step 2.
what is the best option?
How big is the database and how much downtime can you afford ? One simple option is to export from 10.2.0.1 and import into 188.8.131.52.
The other option is to apply the 10.2.0.2 patch on the existing database, then follow the steps in MOS Doc 403522.1 (replace 10.2.0.5 with your 184.108.40.206 version)