RE: Oracle9i HP-UX PA-RISC to Oracle10g HP-UX Itanium based server
Date: Mon, 13 Jul 2009 13:25:19 +0000
Hi Hiten, in summary/high-level steps, you would:
review prerequisites - opsys and Oracle patches, etc, install the new Oracle binaries on the Integrity server, copy or move the DB files from the HP9000 to the Integrity server, modify the Oracle config files on the Integrity server, upgrade Oracle to 10gR2 on the Integrity server, recompile any Oracle natively compiled objects on the Integrity server, startup the DB on the Integrity server.
No exp/imp is required, as the Oracle datafiles are compatible between the two platforms. If you are on 126.96.36.199 or later, you can do a hot migration. Otherwise you will have to do a cold migration.
Oracle My Support/Metalink note 266220.1 (Migrating Oracle9iR2 from HP-UX for PA-RISC to HP-UX for IPF) has some detail - please let me know if you need a copy.
HP provide a detailed how-to white-paper here - http://h71019.www7.hp.com/ActiveAnswers/library/GetPage.aspx?pageid=572978&statusid=0&audienceid=0&ccid=0&langid=121.
If your target is (ultimately) 11g and/or ASM, please let me know as I have a newer draft/unposted version of the above that covers those.
I hope this helps! Regards,
Please let me know if you prefer to not receive email from me.
Solutions Architect - Hewlett Packard
Solution Design Services for Oracle
Shared Solutions Architecture
HP Americas Solution Architecture
Email ssa_at_hp.com to reach our Team
From: hitender chugh <chughhk_at_hotmail.com> Subject: Oracle9i HP-UX PA-RISC to Oracle10g HP-UX Itanium based server Date: Fri, 10 Jul 2009 10:58:28 -0400
We have Oracle9i databases on HP-UX PA-RISC server. We want to migrate our Oracle9i database on HP-UX PA-RISC server to Oracle 10g on HP-UX Itanium server. What are the steps for that? Please advise.
http://www.freelists.org/webpage/oracle-l Received on Mon Jul 13 2009 - 08:25:19 CDT