Re: VPN to database?

No, but (and forgive me for asking) why does that matter?

Is sqlnet tunneling important for security reasons, or important for connectivity? I'm able to telnet to the box straight away.

I figured that, once VPN was connected, I'd be able to run whatever applications I wanted locally. After not being able to get any Oracle client to connect, i wondered if VPN had the capability to transmit anything but the "lowest" level of tcp/ip protocols.

boss

>
>
> Are you tunneling sqlnet through ssh?
>
> http://www.akadia.com/services/ssh_install_and_use.html
>
> On Fri, 2003-10-24 at 08:44, Todd Boss wrote:
> > I can tell you right now, i'm VPN'd to a client overseas and have
> > NOT been able to get OCI to work over the protocol. I can telnet/ssh
> > to the machine where the Oracle server runs (its Solaris) and work
> > via a sql*plus window, but nothing runs locally (i.e., Toad or windows
> > version of sql*plus connected to the remote server).
> >
> > If there's some secret to making OCI work over VPN, we were not able
> > to find it.
> >
> > boss
> >
> > >
> > > We are an Application Service Provider--we maintain a set of servers in
> > > a colocation facility and our customers use our application via the
> > > Web. Security is a paramount concern, of course, and only our Web
> > > server has a public IP address, with the application and database
> > > servers completely private.
> > >
> > > We supply a number of standard reports, but most of our customers want
> > > some custom reports as well. We would like to give them access to our
> > > database, possibly over a VPN, but only if security can be maintained.
> > > I'd like to know if anyone has faced such a situation, and what kind of
> > > configuration (network/firewall/VPN/Oracle Net) might make such access
> > > possible.
> > >
> > > TIA,
> > >
> > >
> > >
> > > =====
> > > Paul Baumgartel
> > > Transcentive, Inc.
> > > www.transcentive.com
> > >
> > > __________________________________
> > > Do you Yahoo!?
> > > The New Yahoo! Shopping - with improved product search
> > > http://shopping.yahoo.com
> > > --
> > > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > > --
> > > Author: Paul Baumgartel
> > > INET: treegarden_at_yahoo.com
> > >
> > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> > > San Diego, California -- Mailing list and web hosting services
> > > ---------------------------------------------------------------------
> > > To REMOVE yourself from this mailing list, send an E-Mail message
> > > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > > the message BODY, include a line containing: UNSUB ORACLE-L
> > > (or the name of mailing list you want to be removed from). You may
> > > also send the HELP command for other information (like subscribing).
> > >
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > --
> > Author: Todd Boss
> > INET: boss_at_i-sphere.com
> >
> > Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> > San Diego, California -- Mailing list and web hosting services
> > ---------------------------------------------------------------------
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from). You may
> > also send the HELP command for other information (like subscribing).
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Jared Still
> INET: jkstill_at_cybcon.com
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Todd Boss
  INET: boss_at_i-sphere.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).