Database – Converting an Oracle 11g Database from 32bits to 64bits

databaseoracle-11g

I have moved a database from a 32bit version of Oracle 11g under Linux to a 64 bit environment. However, i have experienced problems in the new Environment (also Linux).

Is there any method of upgrading the database to 64bits

One thing i forgot to mention the databse was upgraded from an earlier version, the original and the upgraded version were 32bit.

Best Answer

If you have enough disk space, the easiest thing to do is install a fresh instance of Oracle 11g 64 bit, export your 32 bit data, then import into 64 bit Oracle. This will also allow you to have both running side by side for a little to verify that both instances are identical and working as expected.