This is a set of posts about migrating a database from one endian platform to another.
The long-term intention is to move a large (10Tb) 184.108.40.206 database on HP-UX to an OEL Linux server with minimum outage so that will include a database upgrade as well.
This first post is about migrating a self-contained set of schemas using transportable tablespace.
The HP-UX 220.127.116.11 database is called HPUXDB and it was created through dbca with the sample schemas created.. The target database is 18.104.22.168 on OEL 5.8
I already have an 22.214.171.124 installation on the OEL 5.8 server and the target database is called L18
Let’s check the endian versions
SELECT PLATFORM_ID, PLATFORM_NAME, ENDIAN_FORMAT FROM V$TRANSPORTABLE_PLATFORM; PLATFORM_ID PLATFORM_NAME ENDIAN_FORMAT 4 HP-UX IA (64-bit) 13 Linux x86 64-bit Little