Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Some tunnels work. not others - why??

Some tunnels work. not others - why??

From: Jared <jared_at_hwai.com>
Date: 24 Feb 2004 12:09:57 -0800
Message-ID: <480f610.0402241209.1f75a2fc@posting.google.com>


I am having an interesting ssh problem. I am hoping someone more knowledgeable than I can spot where I'm messing up.

I have Oracle databases on two different machines. I want to transfer the data (Oracle export/import) via piping to an ssh tunnel. I have done this successfully using ssh v1 (search on my address and it will come up, I posted the technique). Now I have to get this working with ssh v2 as that is our SA's dictate. Both machines are running Solaris 8; both Oracle databases are the same major and minor release.

I have established pubkey authentication and can log on directly between the two machines. I can do a simple transfer as follows:

$ ls -l |ssh username_at_targethost 'cat > list.txt'

Now I am trying to set up the Oracle export/import:
########################

On target machine:

mknod /tmp/inpipe p
imp xxx/xxx file=/tmp/inpipe &
########################

On source machine:

mknod /tmp/outpipe p
ssh username_at_targethost '/usr/local/bin/cat > /tmp/inpipe.dmp' < /tmp/outpipe.dmp &
exp xxx/xxx file=/tmp/outpipe.dmp
#########################

(I am using the full path to cat as I need the GNU version, this is Solaris 8 with the broken 'cat') I see the export start, but it acts as if it never gets tunneled to /tmp/inpipe.dmp on the target machine.  Under ssh v1 I could see the export and import working; here the export is working but I never see the import side go. Outpipe.dmp has data in it (i.e., size > 0), but inpipe.dmp does not (i.e., size stays at zero). Is there something special about using this technique with ssh v2 that I am missing from the man page?

TIA - Kind regards,
jh Received on Tue Feb 24 2004 - 14:09:57 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US