Re: News Group Access

James Taylor (james.taylor@srs.gov)
Wed, 16 Nov 94 10:49:26 EST

>>> James Pitkow writes:
>> I'll try to make this brief.
>>
>> We are converting our Wang system to Oracle running under HP9000.
>> We are procuring a Sun Sparc 20 as our "Web Server" (Currently
>> running Linux). I would like to know what exactly I need to
>> purchase for the Sun that will allow my Mosaic clients access to
>> our Oracle Database on the HP9000 using the Sun as a gateway. I
>> called Oracle and they gave me a $30k quote... but they didn't
>> know what the minimum config requirement is to do this. Perhaps
>> someone can help?

JP> Probably unecessary - if I recall correctly, Oracle 7.0 has
JP> an environment variable called TWO_TASK. When this variable is
JP> set, all requests are sent to this machine for processing. BTW,
JP> a backend to oracle is available via:

JP> URL:ftp://ftp.cc.gatech.edu/pub/gvu/www/pitkow/gsql-oracle

JP> Sooner or later, oracle may decide to support a gateway directly
JP> for their clients.

JP> Jim.

If I understand what you are asking, the Sun will need SQL*net and, in our
case, Pro*C to allow you to write cgi scripts. With Pro*C you will
be able to use embedded SQL or (my favorite) oraperl.

jjt

_/_/_/ _/_/_/_/ _/_/_/
_/ _/ _/ _/ _/ _/ James J. Taylor
_/ _/ _/ _/ Savannah River Site
_/ _/ _/ _/ Building 773-42A
_/_/ _/_/_/ _/_/ Aiken, SC 29808
_/ _/ _/ _/ (803)725-5323
_/ _/ _/ _/ jjt@srs.gov
_/ _/ _/ _/ _/ _/
_/_/_/ _/ _/ _/_/_/