RE: oracle client on PC's
Jeffrey, I've probably missed something, but if the application uses Merant's ODBC driver - which I believe is a wire-protocol driver, how come you need to install the client at all? Bruce Reardon NOTICE: This e-mail and any attachments are private and confidential and may contain legally privileged information. If you are not an authorised recipient, the copying or distribution of this e-mail and any attachments is prohibited and you must not read, print or act in reliance on this e-mail or attachments. This notice should not be removed. -Original Message- Sent: Wednesday, 7 January 2004 7:14 AM The application is a third-party application using Merant's ODBC driver. How do people normally install the client. Do you do an install to every workstation??? [EMAIL PROTECTED] 1/6/04 2:54:34 PM At 11:39 AM 1/6/2004, Jeffrey Beckstrom 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? There is a reason that Oracle doesn't support configurations like this. There is a fair amount of chatter between an application and the Oracle client DLL's. When this chatter starts flying over the network rather than merely going to a local DLL, you start to get performance problems. How are your application(s) designed? It's probably possible to tweak an OCI application to make fewer OCI calls. If you're using ODBC, and have the budget, you could purchase one of the wire-protocol ODBC drivers. Justin Cave Distributed Database Consulting -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Reardon, Bruce (CALBBAY) 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).
Re: oracle client on PC's
I guess Merant ODBC driver depends on OCI library which is only available after installed Oracle client. We use DataAnalyst from AgileInfoSoftware, we use Microsoft ODBC Driver for Oracle and Oracle ODBC Driver, both need Oracle client library be installed. Eric. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, January 13, 2004 21:24 Jeffrey, I've probably missed something, but if the application uses Merant's ODBC driver - which I believe is a wire-protocol driver, how come you need to install the client at all? Bruce Reardon NOTICE: This e-mail and any attachments are private and confidential and may contain legally privileged information. If you are not an authorised recipient, the copying or distribution of this e-mail and any attachments is prohibited and you must not read, print or act in reliance on this e-mail or attachments. This notice should not be removed. -Original Message- Sent: Wednesday, 7 January 2004 7:14 AM The application is a third-party application using Merant's ODBC driver. How do people normally install the client. Do you do an install to every workstation??? [EMAIL PROTECTED] 1/6/04 2:54:34 PM At 11:39 AM 1/6/2004, Jeffrey Beckstrom 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? There is a reason that Oracle doesn't support configurations like this. There is a fair amount of chatter between an application and the Oracle client DLL's. When this chatter starts flying over the network rather than merely going to a local DLL, you start to get performance problems. How are your application(s) designed? It's probably possible to tweak an OCI application to make fewer OCI calls. If you're using ODBC, and have the budget, you could purchase one of the wire-protocol ODBC drivers. Justin Cave Distributed Database Consulting -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Reardon, Bruce (CALBBAY) 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Eric King 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).
Re: oracle client on PC's
We do an install on the workstation but the installation has been packaged and is pushed I believe with SMS or at least it used to be done that way. From: Jeffrey Beckstrom [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: oracle client on PC's Date: Tue, 06 Jan 2004 12:14:28 -0800 The application is a third-party application using Merant's ODBC driver. How do people normally install the client. Do you do an install to every workstation??? [EMAIL PROTECTED] 1/6/04 2:54:34 PM At 11:39 AM 1/6/2004, Jeffrey Beckstrom 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? There is a reason that Oracle doesn't support configurations like this. There is a fair amount of chatter between an application and the Oracle client DLL's. When this chatter starts flying over the network rather than merely going to a local DLL, you start to get performance problems. How are your application(s) designed? It's probably possible to tweak an OCI application to make fewer OCI calls. If you're using ODBC, and have the budget, you could purchase one of the wire-protocol ODBC drivers. Justin Cave Distributed Database Consulting -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Justin Cave 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). _ STOP MORE SPAM with the new MSN 8 and get 2 months FREE* http://join.msn.com/?page=dept/bcommpgmarket=en-caRU=http%3a%2f%2fjoin.msn.com%2f%3fpage%3dmisc%2fspecialoffers%26pgmarket%3den-ca -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: david davis 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).
Re: oracle client on PC's
--- 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, I'd recommend a Citrix MetaFrame Server farm and a truckload of cash (the servers *could be* Solaris/SPARC). 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).
Re: oracle client on PC's
--- 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).
Re: oracle client on PC's
At 11:39 AM 1/6/2004, Jeffrey Beckstrom 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? There is a reason that Oracle doesn't support configurations like this. There is a fair amount of chatter between an application and the Oracle client DLL's. When this chatter starts flying over the network rather than merely going to a local DLL, you start to get performance problems. How are your application(s) designed? It's probably possible to tweak an OCI application to make fewer OCI calls. If you're using ODBC, and have the budget, you could purchase one of the wire-protocol ODBC drivers. Justin Cave Distributed Database Consulting -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Justin Cave 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).
Re: oracle client on PC's
The application is a third-party application using Merant's ODBC driver. How do people normally install the client. Do you do an install to every workstation??? [EMAIL PROTECTED] 1/6/04 2:54:34 PM At 11:39 AM 1/6/2004, Jeffrey Beckstrom 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?There is a reason that Oracle doesn't support configurations like this. There is a fair amount of "chatter" between an application and the Oracle client DLL's. When this chatter starts flying over the network rather than merely going to a local DLL, you start to get performance problems.How are your application(s) designed? It's probably possible to tweak an OCI application to make fewer OCI calls. If you're using ODBC, and have the budget, you could purchase one of the wire-protocol ODBC drivers.Justin CaveDistributed Database Consulting-- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: Justin Cave INET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
Re: oracle client on PC's
--- Justin Cave [EMAIL PROTECTED] wrote: At 11:39 AM 1/6/2004, Jeffrey Beckstrom 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? There is a reason that Oracle doesn't support configurations like this. There is a fair amount of chatter between an application and the Oracle client DLL's. When this chatter starts flying over the network rather than merely going to a local DLL, you start to get performance problems. How are your application(s) designed? It's probably possible to tweak an OCI application to make fewer OCI calls. If you're using ODBC, and have the budget, you could purchase one of the wire-protocol ODBC drivers. Justin Cave Distributed Database Consulting Justin, There is a fair amount of chatter between an application and the Oracle client DLL's. I'd have to agree: D:\Oracle\Ora92\binpslist sqlplus PsList 1.23 - Process Information Lister Copyright (C) 1999-2002 Mark Russinovich Sysinternals - www.sysinternals.com Process information for MYHOST: Name Pid Pri Thd HndMemUser Time Kernel Time Elapsed Time sqlplusw 1764 8 2 105244 0:00:00.265 0:00:00.2810:00:27.421 105 handles just for one sqlplus connection. There were 44 handles and 74 references for KnownDLLs. check out Process Explorer from the SysInternals website for a gui tool for viewing handle info. Glad I checked with Process Explorer, I didn't realize that I had client-side tracing enabled in my Oracle 9.2 client (it showed the handle on the trace file). 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).
RE: oracle client on PC's
Usually it is installed and configured as a part of a standard corporate disk image. Many shops will trim the fat off the client to keep the size down. Or you walk around with a CD. -Original Message-From: Jeffrey Beckstrom [mailto:[EMAIL PROTECTED]Sent: Tuesday, January 06, 2004 2:14 PMTo: Multiple recipients of list ORACLE-LSubject: Re: oracle client on PC's The application is a third-party application using Merant's ODBC driver. How do people normally install the client. Do you do an install to every workstation??? [EMAIL PROTECTED] 1/6/04 2:54:34 PM At 11:39 AM 1/6/2004, Jeffrey Beckstrom 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?There is a reason that Oracle doesn't support configurations like this. There is a fair amount of "chatter" between an application and the Oracle client DLL's. When this chatter starts flying over the network rather than merely going to a local DLL, you start to get performance problems.How are your application(s) designed? It's probably possible to tweak an OCI application to make fewer OCI calls. If you're using ODBC, and have the budget, you could purchase one of the wire-protocol ODBC drivers.Justin CaveDistributed Database Consulting-- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: Justin Cave INET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
Re: oracle client on PC's
most of the remote sites do not have a file server at all. They access file servers at the "main office" for everything. [EMAIL PROTECTED] 1/6/04 2:54:26 PM --- 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 44113Jeffrey,Does each WAN user reside in a location that has somesort of file server? By each office location havingits own oracle client installation on a local fileserver, the .dll traffic would be minimized. You might still decide to keep the Oracle Clientconfiguration files centralized at the main office(via the use of the TNS_ADMIN environment variable).We took the route of providing all the developerdesktops with a full fat client, but used a responsefile (for OUI) to specify only the minimum filesrequired for our environment. I'd be happy to passalong the response file.We do use centralized [tnsnames,sqlnet].ora files, butalso 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" Sweepstakeshttp://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.comSan Diego, California -- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
Re: oracle client on PC's
What is a 'wire-protocol' ODBC driver? Jared On Tue, 2004-01-06 at 11:54, Justin Cave wrote: At 11:39 AM 1/6/2004, Jeffrey Beckstrom 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? There is a reason that Oracle doesn't support configurations like this. There is a fair amount of chatter between an application and the Oracle client DLL's. When this chatter starts flying over the network rather than merely going to a local DLL, you start to get performance problems. How are your application(s) designed? It's probably possible to tweak an OCI application to make fewer OCI calls. If you're using ODBC, and have the budget, you could purchase one of the wire-protocol ODBC drivers. Justin Cave Distributed Database Consulting -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Justin Cave 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still 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).
RE: oracle client on PC's
we have a standard desktop or laptop image whichwe install the client and create a package containing the change, we then push to the pc's that require the oracle client. We use onames with a primary and secondary name server. -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Jeffrey BeckstromSent: Tuesday, January 06, 2004 1:40 PMTo: Multiple recipients of list ORACLE-LSubject: oracle client on PC's 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 BeckstromDatabase AdministratorGreater Cleveland Regional Transit Authority1240 W. 6th StreetCleveland, Ohio 44113
RE: oracle client on PC's
Title: Message OK I'll bite. Why would you not 1. install the Oracle client on every PC? OR 2. make the app web enabled and just point everyone at a URL. I get really confused when folk (and this isn't aimed at you honest) are quite happy to have sqlserver,msaccess,excel,textand foxpro client access libraries on their machine ( because they come with the web browser :( ) but don't like the client software required for Oracle. Niall -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jeffrey BeckstromSent: 06 January 2004 18:40To: Multiple recipients of list ORACLE-LSubject: oracle client on PC's 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 BeckstromDatabase AdministratorGreater Cleveland Regional Transit Authority1240 W. 6th StreetCleveland, Ohio 44113
RE: oracle client on PC's
I believe the technical term is f'n magic. It is pretty much the analog of the JDBC thin client drivers - i.e. one that doesn't require the Oracle client software and communicates directly over TCP (not sure if any support anything else) with the db server. They cost. Niall -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jared Still Sent: 06 January 2004 20:45 To: Multiple recipients of list ORACLE-L Subject: Re: oracle client on PC's What is a 'wire-protocol' ODBC driver? Jared On Tue, 2004-01-06 at 11:54, Justin Cave wrote: At 11:39 AM 1/6/2004, Jeffrey Beckstrom 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? There is a reason that Oracle doesn't support configurations like this. There is a fair amount of chatter between an application and the Oracle client DLL's. When this chatter starts flying over the network rather than merely going to a local DLL, you start to get performance problems. How are your application(s) designed? It's probably possible to tweak an OCI application to make fewer OCI calls. If you're using ODBC, and have the budget, you could purchase one of the wire-protocol ODBC drivers. Justin Cave Distributed Database Consulting -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Justin Cave 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Niall Litchfield 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).
RE: oracle client on PC's
-Original Message- From: Jared Still [mailto:[EMAIL PROTECTED] Sent: Wednesday, 7 January 2004 07:45 To: Multiple recipients of list ORACLE-L Subject: Re: oracle client on PC's What is a 'wire-protocol' ODBC driver? Jared It's an ODBC driver that either speaks the native network protocol for the DB by itself, or talks via a very thin layer to a server side component that then translates. Both options mean no typical DB client is required on the machine running the ODBC app. Merant/DataDirect/Whatever-they're-called-this-week make quite a few of these. Ciao Fuzzy :-) -- The contents of this post are my opinions only If swallowed seek medical advice -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Grant Allen 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).
RE: oracle client on PC's
Ah, Merant is just down the street, sort of. Maybe they'll loan me one. :) Thanks for the explanation. The concept isn't new, but the terminology is. Jared On Tue, 2004-01-06 at 14:09, Grant Allen wrote: -Original Message- From: Jared Still [mailto:[EMAIL PROTECTED] Sent: Wednesday, 7 January 2004 07:45 To: Multiple recipients of list ORACLE-L Subject: Re: oracle client on PC's What is a 'wire-protocol' ODBC driver? Jared It's an ODBC driver that either speaks the native network protocol for the DB by itself, or talks via a very thin layer to a server side component that then translates. Both options mean no typical DB client is required on the machine running the ODBC app. Merant/DataDirect/Whatever-they're-called-this-week make quite a few of these. Ciao Fuzzy :-) -- The contents of this post are my opinions only If swallowed seek medical advice -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Grant Allen 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still 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).
RE: oracle client on PC's
Hi, I'm in Raleigh, so DataDirect is right nearby. Also, I know their current managers, etc. I worked with them on my last contract, and know something about their stuff. We needed an ODBC driver from our ETL DataStage UNIX server to an Sybase Adaptive Server Anywhere (old version) client running on Windows NT. The DataDirect guys really helped us out, especially with contact info for Sybase ASA. As I remember, the ETL DataStage wire-protocol was considered anything 'provided' with their product, e.g. Sybase 11. Therefore, 'non' wire-protocol was 3rd party like our Sybase ASA ODBC driver. We could still use the DataStage Driver Manager to configure the 3rd party ODBC. Too much information. Sorry. Whatever... :-) Send me an email and maybe I can help with info. Regards, Mike Thomas --- Jared Still [EMAIL PROTECTED] wrote: Ah, Merant is just down the street, sort of. Maybe they'll loan me one. :) Thanks for the explanation. The concept isn't new, but the terminology is. Jared On Tue, 2004-01-06 at 14:09, Grant Allen wrote: -Original Message- From: Jared Still [mailto:[EMAIL PROTECTED] Sent: Wednesday, 7 January 2004 07:45 To: Multiple recipients of list ORACLE-L Subject: Re: oracle client on PC's What is a 'wire-protocol' ODBC driver? Jared It's an ODBC driver that either speaks the native network protocol for the DB by itself, or talks via a very thin layer to a server side component that then translates. Both options mean no typical DB client is required on the machine running the ODBC app. Merant/DataDirect/Whatever-they're-called-this-week make quite a few of these. Ciao Fuzzy :-) -- The contents of this post are my opinions only If swallowed seek medical advice -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Grant Allen 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still 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). __ 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: Michael Thomas 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).