Oracle JDBC thin client does not work over SSH tunelling

From: George Kontoravdis (georgek_at_fortigo.com)
Date: 06/23/04

  • Next message: Darren Dunham: "Re: OpenSSH: force password authentication" 
    Date: Wed, 23 Jun 2004 19:23:26 GMT

    I'm trying to get a Java app to talk to an Oracle 8.1.7 server
    using the JDBC thin client over SSH tunelling. Here is my setup:

      Oracle 8.1.7 running on RH Linux 7.3
      Database SID: testdb
      IP: 192.168.1.10
      Server is behind firewall with public ip 1.2.3.4 (obviously
      not the real ip, just for clarifing the setup)

      Workstation running Java app
      IP: 192.168.1.50
      Win2K
      jdbc lib: classes12.zip
      jdk 1.3.1
      Workstation is behind firewall with public ip 5.6.7.8 (obviously
      not the real ip, just for clarifing the setup)
      Forward local port 1602 to 1512 of the db server by running
       ssh -n -f -l myaccount -L 1602:192.168.1.10:1521 1.2.3.4 sleep 7200

    Now from my workstation I can get to the server via sqlplus by
    using: sqlplus dbuser/dbuser@testdb
    This tells my that the tunneling is setup correctly.

    BUT when I use jdbc:oracle:thin:@localhost:1602:testdb to
    connect the java app to the db server I keep getting an
    ORA-17002 (Io exception: The Network Adapter could not establish
    the connection)

    Any suggestions?

  • Next message: Darren Dunham: "Re: OpenSSH: force password authentication"

    Relevant Pages

    • Re: How to configure for Two different IP subnets
      ... Active Directory will go haywire in a setup like that. ... AD integrates with the local DNS, so you cannot use the DNS at your ISP ... With Server 2003 Standard ... for its internal interface (ie the VPN endpoint). ...
      (microsoft.public.windows.server.networking)
    • RE: To Setup Exchange or not to Setup Exchange...That is the Question.
      ... enough rescources to handle the load that Exchange will put on it. ... into your server in no time, so you will either have to have a very fast RAID ... You can also setup RPC over HTTP for your sales people to reteive e-mail ... phones can download a simple POP client to the phone to get E-mail. ...
      (microsoft.public.exchange.setup)
    • Oracle JDBC thin client does not work over SSH tunelling
      ... I'm trying to get a Java app to talk to an Oracle 8.1.7 server ... using the JDBC thin client over SSH tunelling. ... Here is my setup: ...
      (comp.lang.java.databases)
    • trouble with shared fax service
      ... I setup the shared fax service for the first time on a machine that has SBS ... Our server has one network card connected to a wireless ... Client problem: After setting up shared fax service on the server, ...
      (microsoft.public.windows.server.sbs)
    • Re: Specified network name is no longer available
      ... ISP says nothing wrong with the connection.. ... Also it works just fine if the guys make a dial up VPN connection to ... On it's own the SBS2003 server worked well, ... So Site B was setup. ...
      (microsoft.public.windows.server.sbs)