Can one user pc have both oracle 9g and 11g?

Posted on 2009-12-16
Last Modified: 2013-12-19
I have a financial apps that is on 10G database and using 9g Oracle client.

I have a new Apps running on 11g and using 11g client.

Even though I have both services defined in tnsnames.ora, both apps are not able to run.

Any comments?
Question by:artradis
    LVL 15

    Accepted Solution

    I understand that u have two databases one is in 10g and other on 11g,
    At the client side only install 10g cleint so that u can connect the both servers from a single home
    LVL 3

    Assisted Solution

    On the client machine verify that your TNS_ADMIN environment variable is pointing to a location that has all database services defined in tnsnames.ora.
    LVL 15

    Assisted Solution

    by:Shaju Kumbalath
    If u want to keep the existing homes , keep one home as default home and keep all TNS homes in default home.
     as logictank sail the TNS_ADMIN should be pointing to that home or on windows u can change Registry value of Home0 to the desired home
    LVL 34

    Assisted Solution

    by:Mark Geerlings
    Yes, you can have two (or more) versions of the Oracle client software installed on a client PC, and they can both (or all) work.  Or, you can have just one version (the newer version) of the Oracle client software installed, and you can configure that to support connecting to two different Oracle databases, and they could be the Oracle version or different Oracle version.  I have Oracle8, Oracle9 and Oracle10 clients on my laptop, and I can connect to Oracle8, Oracle9, Oracle10 or Oracle11 databases with any of them.

    So, you have multiple options.  If you use just one Oracle client, the challenge will be in confgiuring SQL*Net to connect to two different databases (but this isn't so difficult).  If you use two Oracle client versions, the challenge will be to configure your two different applications to use the correct version of the Oracle client.  Also (obviously) you will need each of the two separate Oracle clients to be configured correctly to connect to just the intended Oracle database.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Join & Write a Comment

    Why doesn't the Oracle optimizer use my index? Querying too much data Most Oracle developers know that an index is useful when you can use it to restrict your result set to a small number of the total rows in a table. So, the obvious side…
    This post first appeared at Oracleinaction  ( Anju Garg (Myself). I  will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
    This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
    This video shows how to Export data from an Oracle database using the Datapump Export Utility.  The corresponding Datapump Import utility is also discussed and demonstrated.

    755 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now