RE: VPN to database?

Todd

   I like your "magical way". Isn't that the goal with all technology including databases? To the users it just magically works, but we elves down in the boiler room have to make the magic. If you do a great job they never know you're there.

   Well with a last name like yours -- hey! Where I used to work a senior manager was Spanish and his first name was Jesus (pronounced He-sus), and you never thought about it till you came back from lunch to find a note on your desk:

      Dennis
          Come see me.
              Jesus

Dennis Williams
DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com

-----Original Message-----
Sent: Friday, October 24, 2003 5:09 PM
To: Multiple recipients of list ORACLE-L

I don't know. After hearing the explanation, it very well may be.

Our network guy is out (honeymoon). And my experience w/ VPN is slim. For some reason I never considered it to be "just another protocol" but rather to be a magical way that I could just appear to be on the local net to all these machines.

I'll suggest the ssh tunnelling option.

Todd Boss (sorry, I sometimes get colloquial and just sign my last name)

>
> Boss
> Is this a firewall issue?
>
> Dennis Williams
> DBA
> Lifetouch, Inc.
> dwilliams_at_lifetouch.com
>
> -----Original Message-----
> Sent: Friday, October 24, 2003 10:45 AM
> To: Multiple recipients of list ORACLE-L
>
>
> 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: DENNIS WILLIAMS
> INET: DWILLIAMS_at_LIFETOUCH.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: DENNIS WILLIAMS
  INET: DWILLIAMS_at_LIFETOUCH.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).