Oracle export over pipe (between 2 servers)

[Geert Joosten]

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.

[Geert Joosten]

Hi again,

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

Geert.

[Alexander M. Ermes]

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

[Geert Joosten]

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.

[Geert Joosten]

See previous reply.