oracle 817 hpux to linux

[Jim Humphreys]

We are planning to move from HPUX to LINUX with oracle 817. I need help/ info on howto move the actual database files over to the new platform. thanks! running hpux 11.0 on L1000 currently.

[A. Clay Stephenson · Accepted solution]

I suggest a standard export/import for this.

I assume that you will transfer the export file(s) over the network, in that case, FTP will be the least expensive in terms of overhead for the xfers.

[Jean-Luc Oudart]

Different platforms.
I'm afraid the export/import is the only solution for you.

Regards,
Jean-Luc

[Jim Humphreys]

Thanks Ill give it a try . I appriciate to prompt reply!

[Ingo Duschl]

We try do this too, later this year. we have 3 Hp 9000 boxes D and K classes with oracle 8.1.7 an HP-UX 11i. I guess nearly all maschine at Oracle company are running with LINUX. the opertunity is you get more powerfull hardware at the same price for a RISC box. the question is , is LINUX on an INTEL platform save enough for missioncritical and highavailible things.
the otherthing is will you get the same good maintenance for LINUX as for HP-UX if needed.
a oracle specialist told me that you were able to replace a 12 CPU risc box by a 4 CPU
INTEL box with linux. there could be a lot of money saved by the Hardware costs.

[Jim Humphreys]

I guess we are fixing to find out about performance and costs & support in a few months.

[Paul Berger_2]

Using Oracle's export/import utility is not the only option available to migrate an Oracle database across desperate environments...not at all.

For example you could parrot your basic DB environment on the Linux box, including tablespaces sizes and SGA memory configurations and then use an Oracle DB Link along with "insert into select *..." to populate your tables. Oracle also has a "copy" command that you may use to pull data from one environment to another. Yes it's likely slower but some truly mission critical environments require no down time at all. In such cases, the export/import utility doesn't really fit the bill.

Oracle RAC technology will support mission critical DBs running Linux on HP architected Intel processors. I have an executive newsletter on this. Send me an e-mail if you are intrested...pberger@bergercorp.com...and I'll forward it to you.

PB

[Jim Humphreys]

>For example you could parrot your basic DB >environment on the Linux box, including >tablespaces sizes and SGA memory >configurations and then use an Oracle DB >Link along with "insert into select *..." >to populate your tables. Oracle also has >a "copy" command that you may use to pull >data from one environment to another. Yes >it's likely slower but some truly mission >critical environments require no down time >at all. In such cases, the export/import >utility doesn't really fit the bill.

I am guessing I can find this procedure in the oracle docs?