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?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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
Protecting & Securing Your Critical Data

Considering 93 percent of companies file for bankruptcy within 12 months of a disaster that blocked access to their data for 10 days or more, planning for the worst is just smart business. Learn how Acronis Backup integrates security at every stage

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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Windows OS

From novice to tech pro — start learning today.