Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Oracle 10 and Oracle 11 clients coexistence

I'am a asp.net web developer.

I have the Oracle Client 11 instaled to test some features (EF support), but my applications must be in Oracle10 because my customer uses it.

So, if i work in my customer project i need the Oracle10 instaled (to test it in my workstation), and if i want to test the features of Oracle11 i need to install oracle 11.

My question is: How to coexists Oracle 10 and 11 clients in same workstation.

In other words, i want to debug and run my asp.net web applications in my own workstation and simply change the web.config to use Oracle10 or Oracle11 client.

It is possible?

like image 657
Ewerton Avatar asked Mar 11 '11 19:03

Ewerton


People also ask

Can you have two versions of Oracle client installed?

For example, with multiple Oracle homes, you can install release 8.0. 5 and 8.0. 4 products in different Oracle homes on the same computer. You can still install different releases of Oracle products in the same Oracle home provided they have different second-digit release numbers.

Can Oracle 11g and 12c coexist?

Yes, it is possible.

Can Oracle 12c and 19c coexist?

Yes you can run Oracle 12c and Oracle 19c in same server but you need to configure listener ports separately as below. E.g. : Oracle 12c listener on 1521 and the Oracle 19c listener on 1522, You can try this method.

Can you install both 32 and 64 bit Oracle client?

You can install Oracle 32-bit and Oracle 64-bit on the same server. The two installs must reside in different ORACLE_HOME directories though. So install Oracle 32-bit in a different directory than your 64-bit version and they will both coexist quite nicely.


1 Answers

As long as you install the two versions of the Oracle client in different Oracle Homes, they should coexist peacefully. There are just a couple of gotchas to be aware of

  1. By default, each Oracle Home will have a separate tnsnames.ora file (and sqlnet.ora file, etc.). That often causes confusion if you've configured a TNS alias in one Oracle Home and not in the other. You can configure your environment to use a single set of TNS configuration files by setting the TNS_ADMIN environment variable to point at the directory that contains the one true source of TNS configuration issues (i.e. set TNS_ADMIN to %Oracle11g_Home%\network\admin to always use the tnsnames.ora file from your 11g Oracle Home).
  2. Some third-party products are not multi-home compliant. If you use something like the legacy Microsoft ODBC Driver for Oracle, for example, it will use whichever version of the Oracle client appears first in your PATH. If you are using Oracle drivers to connect to the database, that shouldn't be an issue. If you do need to switch which is the default Oracle Home, you can either manually edit your PATH or you can fire up the Oracle Universal Installer and under Installed Products | Environment, you can control the order that Oracle Homes appear in the PATH.
like image 57
Justin Cave Avatar answered Nov 15 '22 10:11

Justin Cave