Re: VPN to database?

We're doing it as I write this for a convention taking place half-way across the country.

The setup is

Client: Browser (IE), Cisco VPN Client, Adobe Acrobat, JInitiator Middle tier: 9iAS rel2 Forms and Reports Server on Win2K Db tier: Oracle 8.1.7 on Win2K

All servers are on our private network. The only problem we're experiencing is from sloppy network setup at the convention center...we're dropping packets and the tunnel won't stay up. =8-(

But when the tunnel is up, the forms and reports work like a charm since the addresses all resolve to hosts on the internal network.

One problem we did run into was printing....they have an IP printer set up on the convenion sub-net and they are not able to print to it while they have the tunnel up (of course). The have to save the .PDF's, shutdown the VPN client and then print.

Cheers

Jeff Herrick

On Fri, 24 Oct 2003, Paul Baumgartel wrote:

> 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: Jeff Herrick
  INET: jherrick_at_igs.net

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).