Our current application is written in Oracle Forms 6i and runs on an Oracle 9i database. Our long term goal is to migrate both to 11g. The old server being used is running Windows 2003 (32 bit). The new server was ordered with Windows 2003 (64 bit) O/S. Is there any version of 9i database and 6i forms that will run under the Windows 2003 (64 bit) O/S? If not, what migration steps do you recommend?
Oracle 9i is not certified to run on a 64-bit OS. This does not mean that it will not work, just that if you have problems, you will most likely not be able to receive any help from Oracle Support for your issues. I would recommend installing 10g or 11g on the 64-bit OS and then importing the old 9i database into the newly installed environment.
Have a question for Brian Peasland? Send an e-mail to firstname.lastname@example.org
Dig Deeper on Oracle database export, import and migration
Related Q&A from Brian Peasland
Oracle expert Brian Peasland answers one reader's question about common pitfalls when connecting Oracle to outside programs. Continue Reading
One reader asks expert Brian Peasland a question about datafile sizes with the Oracle RMAN duplicate 10g command. Continue Reading
Managing parent table-child table relations in Oracle SQL environments is key to efficient programming. Continue Reading