Re: Installing Multiple Oracle Clients

Hi,

It's not used by many people. But, If you have many clients, you can install client softwares on application server or different home on database server. do followings:

• map a server in which client softwares will be installed, such as 'L:'
• install client softwares to 'L:'
• export Oracle registry
• import registry to other clients

according to my test in previous years, Oracle just creates windows programs folders on client boxes which is not defined in registry. this is not important.

during connection, client software is copied to client from server. if performance is acceptable, you can use these configuration without installing to many clients.

Jay Hostetter wrote:

> We are preparing to upgrade our Oracle client installation on our NT workstations.
> For the most part, we are still running the 7.3 Oracle client. We are preparing to
>install 8.1.6, 8.0.5, and possibly 8.0.4 versions of the Oracle client.
>Unfortunately, we have various 3rd party applications that are only certified with
>specific versions of the client - and of course they are not all the same Oracle
>client versions.
> The 8.1.6 client will be the default Oracle home, then we will install 8.0.5 and
>8.0.4 on those PCs that require it. We will use .bat files for those applications
>that need the 8.0.4 or 8.0.5 version of the client. The .bat files will change the
>PATH and ORACLE_HOME, then call the application.
> It looks like we are going to have to visit each PC to do a local install of the
>appropriate Oracle client(s). I am looking for input in two areas:
>
> 1) What is the easiest way to do these local installations? With the old 16-bit
>version of the Oracle client, you could do a network install, then have the
>workstations reference that installation by changing ini files. I don't think that
>the 32-bit version of the client supports network installs. Has anybody had success
>with response files? What is the trick to getting them to work? Anyway, I'm looking
>for an alternative to visiting each workstation.
>
> 2) Is there an alternative to using .bat files for referencing a different Oracle
>client? Do many folks take the risk of using a newer version of the Oracle client
>for an application, even though that application is not certified with that version
>of the Oracle client?
>
> Thanks for the input.
>
> Jay Hostetter
> Oracle DBA
> D. & E. Communications
> Ephrata, PA USA
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Jay Hostetter
> INET: jhostetter_at_decommunications.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> 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).

--
Use itrprof SQL Analyzer.

itrprof SQL Analyzer is a web based tool which analyzes
SQL_TRACE/Event10046 trace files of Oracle,
finds bottlenecks and offersinformation on how to tune them.

No download, no setup, just click
http://www.unal-bilisim.com/products/itrprof/itrprof.html


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Danisment Gazi Unal (Unal Bilisim)
  INET: danisment.unal_at_unal-bilisim.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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).