--- Jeffrey Beckstrom <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).