Oracle Database Discussions

Hello all,

I'm planning to migrate and upgrade a 10g database from HP-UX to Red Hat Linux using the following method..

Goal #1: Migrate database from HP-UX to RHEL
Goal #2: Target database should be 11g

Source Database version : Oracle 10g
Source Host : HP-UX (64 Bit)

Target Database version: Oracle 11g
Target Host: Red Hat Linux (RHEL5) 64 bit


Method

1) Install a Shell 11g database on the target system (Linux).

2) Make all tablespaces in source database (10g on HP-UX) READ ONLY with the exception of SYS/SYSAUX/UNDO/TEMP.

3) Take a transportable tablespace export dump using either old exp utility or datapump.

4) Take an export of all data schemas without tables/indexes.

5) copy all datafiles from source system (HP-UX) to target system (Linux).

6) copy all the export dumps from source to target system.

7) Make all the tablespaces in the source system (HP-UX) READ WRITE.

8) Convert the datafiles in the target system (Linux) from Big-Endian to Little-Endian using RMAN.

9) Import the data schemas.

10) Import all the tablespaces using either old exp utility or datapump.

11) create roles, public database links, public synonyms etc on the Linux system.


Are there any flaws or is there any step that would not work in the above methodology?

PS: The database contains a a bunch of materilaized views..


Thanks for your time...