RE: Database Migration and Upgrade across Servers ( from Solaris to HP)

From: Jeremiah Wilton <>
Date: Thu, 31 Jul 2008 15:13:40 -0700
Message-ID: <003c01c8f35a$b133d730$139b8590$@net>

Bala wrote:

> We have a Requirement to migrate all 10 Oracle databases (
> running on Sun Solaris Server ( Solaris 10) to HP-UX Server ( running
> HP-UX 11i).
> We want to upgrade all the databases to the latest Oracle release
> What could the most feasible approach ? -- Each of our Databases size
> is 30 GB.

An upgrade and a platform migration are two different activities. If you do them at the same time, you will not necessarily know which one caused your problems.

I would upgrade to first using a new ORACLE_HOME and catupgrd.sql. Some feel it is better to upgrade by importing into a new database on the higher version, in order to achieve various goals, such as segment reorganization and fresh odor ;-) My feeling is that segment reorganization and database deodorization are also activities that have the potential for causing problems discrete from upgrade and migration, and therefore should also be undertaken separately.

If you are moving from Solaris SPARC 64-bit to HP-UX 64-bit you are in luck. There is no need for exp/imp, data pump or even transportable tablespaces. Migrations between same endian platforms can be achieved with RMAN and convert database.


Jeremiah Wilton
ORA-600 Consulting

Received on Thu Jul 31 2008 - 17:13:40 CDT

Original text of this message