The source 9i is on RHEL 4 (32-bit) and target 10g is on RHEL 5 (64-bit) Regards, Ashwin On Thu, Oct 30, 2008 at 2:27 PM, Paul Drake <bdbafh@xxxxxxxxx> wrote: > please repost listing the operating system. > Also, check the metalink doc on changing the database word size. > you will need to run /rdbms/admin/utlirp.sql prior to upgrading the word > size. > > hth. > > Pd > > > On Thu, Oct 30, 2008 at 5:15 PM, Ashwin <ashdbablog@xxxxxxxxx> wrote: > >> Hi, >> >> I took a cold backup of 9i datafiles and copied them to the new 10g 64-bit >> server >> I installed the 10g 64-bit Oracle Home >> >> On the new 10g server, >> >> I recreated the controlfile to point to the new location of the datafiles >> and ran >> SQL> startup upgrade >> >> It failed saying that database should be open in resetlogs or no resetlogs >> mode >> >> I shutdown the db and did a startup mount and >> SQL>alter database open resetlogs; >> >> This time it failed saying that database should be opened in upgrade >> option. >> >> I am unable to proceed with the upgrade. Anyone ever faced this issue? >> >> Regards, >> Ashwin >> > > > > -- > http://www.completestreets.org/faq.html > http://safety.fhwa.dot.gov/ped_bike/docs/pamanual.pdf > >