Simpler Navigation for Servers and Operating Systems - Please Update Your Bookmarks
Completed: a much simpler Servers and Operating Systems section of the Community. We combined many of the older boards, so you won't have to click through so many levels to get at the information you need. Check the consolidated boards here as many sub-forums are now single boards.
If you have bookmarked forums or discussion boards in Servers and Operating Systems, we suggest you check and update them as needed.
General
cancel
Showing results for 
Search instead for 
Did you mean: 

Migrating oracle db from HP to AIX

ITSD-ACCS
Frequent Advisor

Migrating oracle db from HP to AIX

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 ?
6 REPLIES
Steven E. Protter
Exalted Contributor

Re: Migrating oracle db from HP to AIX

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
Steven E Protter
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
twang
Honored Contributor

Re: Migrating oracle db from HP to AIX

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
Honored Contributor

Re: Migrating oracle db from HP to AIX

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
Honored Contributor

Re: Migrating oracle db from HP to AIX

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
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)
Alexander M. Ermes
Honored Contributor

Re: Migrating oracle db from HP to AIX

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
.. and all these memories are going to vanish like tears in the rain! final words from Rutger Hauer in "Blade Runner"
Volker Borowski
Honored Contributor

Re: Migrating oracle db from HP to AIX

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