aix to hp-ux oracle migration

[Rommel T. Misa_2]

Hello guys,

Have you tried migrating an oracle DB from AIX to HP-UX? How difficult (or easy) would it be? Are there special steps involved?

Thanks.
Rommel

[Luk Vandenbussche · Accepted solution]

Hi,

I have done this once.
I propose first that you take enough time (twice your estimation) for testing all the applications.

You need to install the DB version on HPUX.
Then you need to create an empty database on HPUX and import the database.

How difficult it is depends on the application, if your are using systemcalls, it can be quite difficult.

Good Luck

[Arunvijai_4]

You have to take Oracle backup and store it in a external media or storage. Then, Install Oracle, Tune and configure it on HP-UX, take a look at these threads on installation,
http://forums1.itrc.hp.com/service/forums/questionanswer.do?threadId=611494
http://forums1.itrc.hp.com/service/forums/questionanswer.do?threadId=749881

Create a empty database, import from your backup media.

-Arun

[Rommel T. Misa_2]

Thanks. BTW, I'm migrating an Oracle 7.3 DB on AIX 3.2.5 to an Oracle 10g on HP-UX11i. Would the steps be the same?

[Arunvijai_4]

http://download-east.oracle.com/docs/cd/B19306_01/server.102/b14238/toc.htm

I think, you can do it..

-Arun

[Jean-Luc Oudart]

Hi,

as you are in a cross platform situation you will have to export and then import on target system.

To learn more about cross platform and version compatibility (export/import) refer to Metalink Note:132904.1 "Compatibility Matrix for Export & Import Between Different Oracle Versions"

Regards
Jean-Luc

[Arunvijai_4]

Can you refer this link,
http://download-east.oracle.com/docs/cd/B19306_01/server.102/b14238/preup.htm#sthref48
If you have oracle 7.3.3 or lower, direct upgrade is not supported.

-Arun