Move big file from HP-UX to Linux.

[Gulam Mohiuddin]

We have one Oracle export dump file of 50GB size on HP-UX Server.

FTP, RCP, RSH is disabled on Linux Server.
SFTP, SRCP, SSH is disabled on HP-UX Server.

In this case how I would move this file from HP-UX to Red Hat Linux Server.

Thanks,

Gulam.

[Steven Schweda]

> [...] is disabled on [...].

Why?

> In this case how I would move this file [...]

Tape? If you don't have any common network
protocol enabled, perhaps you should consider
enabling one.

"HP-UX Server" does not describe your
environment in enough detail to determine
whether SSH is installed on your HP-UX
system, but it could be.

Similarly, "Linux Server" is not a good
description of the other system, but I'd bet
that there's an FTP client and/or server
available there.

[Patrick Wallek]

Seems to me you have 2 choices:

1) Enable FTP on the Linux server

2) Install and set up SSH to enable sftp and scp on the HP-UX server.

Your only other choice might be a high capacity tape and using tar to write to the tape.

[A. Clay Stephenson]

... except that tar (even patches) maxes out at 8GiB. So if tar is your answer then you will need to use split the break the file into smaller chunks and cat them back together after the untar.

[Vladimir Fabecic]

>>In this case how I would move this file from HP-UX to Red Hat Linux Server?
What about NFS?
Export file system in HP-UX and mount it on Linux.

[Volker Borowski]

Hi,

if this is stable LAN (not WAN) and you need the export on the target for import purposes (not backup or so), you can directly import from source to target via LAN, if the Oracle release is identical.

Set all environment to work correctly on source. Setup (temporary) tnsames.ora on source to reach the target database.

If sqlnet.ora on the targethost has set
tcp.valid_node_checking=yes
tcp.invited_nodes=....
permit the source host (temporary) in addition and restart the listener on the target host.

$tnsping target
must work.

Adjust environment
ORACLE_SID=target
NLS_LANG=...whatever is valid for target...

check if

sqlplus system/password@target

from source can connect successfully to target database.

Do the import

imp system/password@target ....

Try a small dump of a single table first, and ensure that the testtable has all datatypes in it's fields an fill esp. the char-fields with your local common used special characters (i.e. umlauts are always troublemakers here in Germany).
Ensure that you have FLOATS and DECIMALS in the table to verify the correct resolution of the numeric delimiters like dot and comma.
If your database includes LOBS,BLOBs,CLOBS I'd prefer to have one of these in the testtable too.

NLS_NUMERIC in Environment may cause confusion with these two numbers.
1.000.000.000,00
1,000,000,000.00

Unfortunately you can not use compression in this method without RSH enabled.

Hope this helps.
Volker

[Wim Rombauts]

Even if there is no SSH-server on HP-UX, if SSH is installed, then you can SSH/SFTP/SCP to the Linux server from the HP-UX client.

The reverse is also possible : You can rsh from the linux box to the HP-UX server.

[dirk dierickx]

1. use the ssh/scp client on HPUX, the server _is_ running on linux.

2. use nfs, and if you can do that, i don't see why you couldn't just use the above instead.

[Steven E. Protter]

Shalom,

If I had the network band width, I'd change the rules of the game.

I'd temporarily ENABLE ssh on the HP-UX box or install secure shell from http://software.hp.com and then disable and swremove after the install.

Breaking up the file is a great idea that I'd probably get wrong.

SEP

[Gulam Mohiuddin]

Thanks everybody for your great responses.

Finally I ended up using NFS.

Regards,

Gulam.