Migrating oracle db from HP to AIX

[ITSD-ACCS]

I have a HP K460 machine running Oracle 8.05 db. The machine will soon be replace by a AIX machine. Is it possible or anything I need to pay attention to ?

[Steven E. Protter]

If the AIX machine is 64 bit database and the HP box is 32 bit, you have a data mirgration procedure to consider. I'm attaching a guide, but you need to get in touch with Oracle support or http://metalink.oracle.com.

SEP

[twang]

If oracle rdbms has been installed on an AIX, to move database from the HP to the AIX, you can just export full database on HP and copy the export file to AIX machine and import.

[twang]

A brief instruction:
(1) Backup the database on HP.
(2) Backup HP's catexp.sql. Run AIX'S catexp.sql on HP machine.
(3) Export the database on HP.
(4) Using scripts, create the database on AIX machine.
(5) Run cat8x.sql, catalog.sql and catproc.sql on the newly-created database.
(6) Import the database from the dump taken on HP machine.
(7) Recompile any invalid objects e.g. views, triggers

[Yogeeraj_1]

Hi,

Not enough information about the database size posted!

anyway,

Lets say
1.if the db is < 15GB
schema level exp/imports OR
sqlplus copy of big objects OR
create table as select over dblink OR
dump and reload

2.if the db is > 15GB
Export and Import will be the tools you use to accomplish this. They are platform independent.

schema level exp/imports -- dropping down to table level on an as needed basis to move really big things. (export N schemas at a time in parallel vs 1 database at a time serially)


Hope this helps!

regards
Yogeeraj

[Alexander M. Ermes]

Hi there.
Why not kill two birds with one stone ?

1. Install Oracle 8.1.7 on AIX

2. Migration to be done with export on HP-UX and import on AIX. So you can get rid of the fragmentation as well.

Rgds
Alexander M. Ermes

[Volker Borowski]

Hi,

watch it, 8.1.7 will be desupported in Oracle standard maintanance by the end of the year!

AIX 4.3 is already desupported, which means you need to start with AIX 5.x now, which is not really capable of running 8.1.7. I just did a couple of Oracle 8.1.7 to 9.2.0 Upgrades on AIX in SAP environment. Worked OK, but is lousy, because 8.1.7 runs only on 4.3 and 9.2.0 run only on 5.x. So if the OS-Upgrade in between fails ....
I'd start on AIX 5.x with 9.2.0.3

I'd go the export/import way. Watch out to install the new database with the same DB_CHARSET (check V$NLS_PARAMETER) otherwise you might experience trouble if your database contains LONG or LONG-RAW fields with char-information (will not be char-converted to new charset if changed!!).
The LONG-RAW stuff might be a problem as well for the db-link-stuff and the sqlplus-copies, because usually sqlplus can not select an entire LONG-RAW field.

Hope this helps
Volker