Two Oracle clients on the same server

Hi All,

Is it okay to have two oracle clients (both 11g and 12) in the same windows server? What are the potential issues I could face?The reason I am doing this is to fix attached SQL server linked server connection issue.
Sri GAsked:
Who is Participating?
 
Martin MillerCTOCommented:
Yes, this is OK, as these make outbound connections. if you have the SERVER on same system/address then the listen ports need to be different.

  ip-address-1: PORT1
  ip-address-1: PORT2    <=== if the server is on same listening address,  PORT2 has to be different than PORT1
0
 
Sri GAuthor Commented:
Thanks Martin,

Is there any configurations I have to change in listener.ora and tnsnames.ora file after installation?

We have already installed 12 client and now we need to install 11g client on same windows machine
0
 
Pushpakumara MahagamageVPCommented:
Yes you can have 11g and 12c clients in one PC. Carefull, if you are a dev.  your oracle dll will bind when you build solution.

Yes try tns ping to your server,  use net configuration manager or you can edit listener.ora

configure listner - https://docs.oracle.com/cd/E18283_01/network.112/e10836/listenercfg.htm

https://community.toadworld.com/platforms/oracle/b/weblog/archive/2017/03/07/oracle-11g-12c-client-install-on-windows-lightweight-and-locked-down
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
Martin MillerCTOCommented:
Sri,

I see Pushpakumara Mahagamage has posted  helpful links, and yes you will need to make configuration updates.
0
 
Geert GOracle dbaCommented:
Martin's comment is for listeners, not for clients
Actually most comments above are for listeners and that's nothing to do with oracle clients

The links posted in #a42501253:
first: irrelevant
second: only relevant until step 2


attached ?
there is no attachment

You can have a lot of clients
unless you do something specific to use a certain client only 1 gets used

The client used will be the one designated by the "home selector"
at least it used to be like that a decade ago

nowadays, it's the first one found via the path environment variable
typically the last client installed will be the one being used
as it's path gets prepended to the existing path environment variable

the only reason, beside 32-bit/64-bit, you install multiple clients is for compatibilty
besides that, you only need 1 client (1 for 32-bit and 1 for 64-bit)

you can have a common tns_admin location on the server for all clients by setting the tns_admin system variable

what error are you getting actually ?
and what made you decide to install multiple versions of the client ?
1
 
Mark GeerlingsDatabase AdministratorCommented:
Yes, you certainly can have two different Oracle client versions installed on a single Windows computer.  I've been doing that for over 20 years, with a variety of different Oracle client versions.  Unless this Windows computer (server or not) is actually running an Oracle database, you don't need to worry about listener files.  Those aren't needed or used on Windows client machines.  It doesn't matter if the version of Windows is actually a "server" version of Windows.  If it is not running an Oracle database, as far as Oracle software is concerned this is a "client" computer that can connect to an Oracle database that runs somewhere else on your network.
0
 
Sri GAuthor Commented:
--
0
 
Geert GOracle dbaCommented:
really ? it works without following my comment ?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.