topic Oracle export over pipe (between 2 servers) in Operating System - HP-UX

Oracle export over pipe (between 2 servers)

Geert Joosten — Fri, 07 Oct 2005 03:25:31 GMT

Hi,
We want to export a Oracle database over a pipe between 2 servers. Oracle advise to two following procedure:
mknod /tmp/pipe on both machines (mknod file p)
chmod 777
start the process on the target server with
remsh sourceserver dd if=/tmp/pipe > /tmp/pipe &

Start the export on sourceserver with
exp xx/xx full=y volsize=0 FILE=/tmp/pipe

Start the import on targetserver with
imp xx/xx full=y file=/tmp/special_pipe volsize=0

This results in starting the export and import with error. But the import doesn't receive any data to proceed.

This worked on other non-hp machines before, but with rsh instead of remsh.
What's wrong? Any ideas.

Re: Oracle export over pipe (between 2 servers)

Geert Joosten — Fri, 07 Oct 2005 03:54:55 GMT

Hi again,

Made a stupid typing error:
The export and import starts WITHOUT error. But nothing happens on both processes.

Geert.

Re: Oracle export over pipe (between 2 servers)

Alexander M. Ermes — Fri, 07 Oct 2005 04:07:35 GMT

Hi there.
Ever tried mkfifo instead of mknod ?
We are piping exports into zipped files taht way.
Rgds
Alexander M. Ermes

Re: Oracle export over pipe (between 2 servers)

Geert Joosten — Wed, 12 Oct 2005 01:43:06 GMT

Hi,

We received the solution. The correct order in setting up is (after making the pipes):
1. start the import
2. start the remsh
3. start the export

This works fine.

Geert.

Re: Oracle export over pipe (between 2 servers)

Geert Joosten — Wed, 12 Oct 2005 01:45:10 GMT

See previous reply.