Re: oracle client on PC's

From: Paul Drake <discgolfdba_at_yahoo.com>
Date: Tue, 06 Jan 2004 11:54:26 -0800
Message-ID: <F001.005DBDE7.20040106115426@fatcity.com>

• Jeffrey Beckstrom <JBECKSTROM_at_gcrta.org> wrote:
  > Rather than installing the Oracle client on every
  > client PC, we have been:
  > - installing client on 1 PC
  > - copying directory to a network server
  > - extract the registry for "oracle" key
  > - fix registry that was extracted to reference the
  > network drive
  > - load registry on client PCs
  > - add the network pc as a search drive to the client
  > pc.
  >
  > We are now experiencing problems over the WAN and
  > looking at ways to eliminate the Oracle dll
  > overhead. Short of installing Oracle on every
  > client PC, what are our options?
  >
  > Jeffrey Beckstrom
  > Database Administrator
  > Greater Cleveland Regional Transit Authority
  > 1240 W. 6th Street
  > Cleveland, Ohio 44113
  

Jeffrey,

Does each WAN user reside in a location that has some sort of file server? By each office location having its own oracle client installation on a local file server, the .dll traffic would be minimized.

You might still decide to keep the Oracle Client configuration files centralized at the main office (via the use of the TNS_ADMIN environment variable).

We took the route of providing all the developer desktops with a full fat client, but used a response file (for OUI) to specify only the minimum files required for our environment. I'd be happy to pass along the response file.

We do use centralized [tnsnames,sqlnet].ora files, but also use ONAMES as a backup names resolution method. Haven't tackled that OID thingy yet.

hth.

Paul

---

Do you Yahoo!?
Yahoo! Hotjobs: Enter the "Signing Bonus" Sweepstakes http://hotjobs.sweepstakes.yahoo.com/signingbonus

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Paul Drake
  INET: discgolfdba_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).

Received on Tue Jan 06 2004 - 13:54:26 CST