Windows 2003 32bit to 64bit 1

[tekdudedude]

Hello,

Can anyone pass on any lessons learned concerning migrating a 32bit Oracle 10g database from Windows 200n 32bit to Windows 200n 64bit?

One immediate topic comes to mind (Export\Import). Assuming the databases are created the same, are there any special considerations importing data from a 10g R2 32bit version into a 10g R2 64bit database?

Anything else you guys run into?


Thanks for your advice,

TD

 

[SantaMufasa]

One immediate topic comes to mind (Export\Import). Assuming the databases are created the same, are there any special considerations importing data from a 10g R2 32bit version into a 10g R2 64bit database?

No issues...that is how you migrate from one database architecture (e.g., 32-bit) to another (e.g., 64-bit).


Amongst other issues that we "ran into" when migrating from 32-bit to 64-bit architecture was that our previously limited (1.6GB) SGA size, which was not appropriately large enough to process our application, could now increase in size. We bumped our SGA up to 12GB (on the 64-bit system) and we have no longer suffered performance bottlenecks.

Enjoy!

Mufasa
(aka Dave of Sandy, Utah, USA)
[I provide low-cost, remote Database Administration services: www.dasages.com]

 

[tekdudedude]

Thanks Santa.

 

[Thargy]

Point of order,

the OP asked in general about importing from 32 bit to 64 bit db's. As such, across operating systms with a different endianness, exports are incompatible and will NOT work.

For these circumstances, transportable tablespaces seem ideal.

Regards

T

 

[SantaMufasa]

Under such circumstances, you re-read "Endianness Jones and the Kingdom of the Incompatible Character Sets". <stupid grin>

We just flawlessly migrated a 1TB database from a 32-bit Linux platform to a 64-bit platform using Both Oracle Data Pump and standard "exp"/"imp" utilities.

John's (Tharg's) suggestion of using Oracle's transportable tablespaces can be an excellent migration tool, but there are some limitations. I recommend your reading up on transportable tablespaces. Also, Google for topics such as [Oracle migration "endian issues"] for other suggestions on how one can deal with otherwise-incompatible bit configurations.


Mufasa
(aka Dave of Sandy, Utah, USA)
[I provide low-cost, remote Database Administration services: www.dasages.com]