Oracle Databases Migration...

maumercado

Hello everyone...

I was just wondering if anyone here has experience migrating Oracle databases that are in a Windows XP 32 bit environment to a CentOS 64 Bit linux, can anyone give me some good pointers, what must be done, what should I check to see if its possible? any good manuals or guides on how to do that..

Thank you..

cablegod

maumercado wrote: »

Hello everyone...

I was just wondering if anyone here has experience migrating Oracle databases that are in a Windows XP 32 bit environment to a CentOS 64 Bit linux, can anyone give me some good pointers, what must be done, what should I check to see if its possible? any good manuals or guides on how to do that..

Thank you..

I'd follow this guide for setting up the CentOS box first: ORACLE-BASE - Oracle Database 10g Release 2 (10.2.0.1) Installation On Red Hat Enterprise Linux 5 (RHEL5)

Then tweak the kernel settings and HugePages settings appropriately since you are going 64bit (does this box have >4gb of RAM?).

Then build a basic DB using DBCA, use NETCA to create a listener and setup Naming (TNSNames). Use DBConsole to setup the tablespaces & datafiles (be sure to tuen on Autoextend) to reflect what you have on your Windows box. Then datapump (expdp) the schema to an export file and copy it to the new CentOS box, create the schema (create user xxxx identified by xxxx default tablespace xxxx temporary tablespace xxxx;) and then datapump import (impdp) the schema and set the same grants and privileges. Finally gather statistics and you should be done, if I haven't overlooked anything. It's not too hard. The first time may take quite a bit of time to do it, and keep your Windows box running as a safety net.