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

Bala wrote:

> We have a Requirement to migrate all 10 Oracle databases (10.2.0.1)
> 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
> 10.2.0.4.
>
> 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 10.2.0.4 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.

Regards,

Jeremiah Wilton
ORA-600 Consulting
http://www.ora-600.net

--
http://www.freelists.org/webpage/oracle-l