This discussion is archived
11 Replies Latest reply: Nov 18, 2012 12:21 PM by user5716448 RSS

Oracle client and tnsping

user5716448 Explorer
Currently Being Moderated
Hi,

We have a windows server and have installed 2 oracle clients for 11.2.0.3

A 32-bit one and a 64-bit one.

Installed the 64 bit one under one account on the server and the 32 bit one under another.

Yet when login with each account and tnsping <database_name>

it shows the used parametr file as the 32 bit one.

Is this O.K?/to be expcetde.

We have a third-party application which requires mainly 64-bit version, and some services which require the 32 bit one?

Will this be a problem fact seems to be defaulting to the 32-bit one.

Thanks
  • 1. Re: Oracle client and tnsping
    sb92075 Guru
    Currently Being Moderated
    user5716448 wrote:
    Hi,

    We have a windows server and have installed 2 oracle clients for 11.2.0.3

    A 32-bit one and a 64-bit one.

    Installed the 64 bit one under one account on the server and the 32 bit one under another.

    Yet when login with each account and tnsping <database_name>

    it shows the used parametr file as the 32 bit one.

    Is this O.K?/to be expcetde.
    it is OK for me.

    >
    We have a third-party application which requires mainly 64-bit version, and some services which require the 32 bit one?

    Will this be a problem fact seems to be defaulting to the 32-bit one.
    what is/are the differences between the two files?

    >
    Thanks
    Handle:     user5716448
    Status Level:     Newbie
    Registered:     Mar 16, 2010
    Total Posts:     313
    Total Questions:     121 (77 unresolved)

    why so MANY unanswered questions?
  • 2. Re: Oracle client and tnsping
    user5716448 Explorer
    Currently Being Moderated
    Only difference is thta 32 bit client installed in one folder, 64 bit client in another.
    Is there a way to specify the default - had hoped installiing under different users would have done this.

    Thanks
  • 3. Re: Oracle client and tnsping
    sb92075 Guru
    Currently Being Moderated
    user5716448 wrote:
    Only difference is thta 32 bit client installed in one folder, 64 bit client in another.
    If the content of the two files is the same, what difference does it make which is used?
    Is there a way to specify the default - had hoped installiing under different users would have done this.

    Thanks
    TNS_ADMIN can point to a specific directory you desire
  • 4. Re: Oracle client and tnsping
    Aman.... Oracle ACE
    Currently Being Moderated
    In general, it shouldn't matter what's the version of the client. The networking files can be pointed through the TNS_ADMIN environment variable but I am not sure that there is any way to use a specific version binary. That said, why you don't deinstall the 32 bit client and let only the 64bit be there?

    Aman....
  • 5. Re: Oracle client and tnsping
    BillyVerreynne Oracle ACE
    Currently Being Moderated
    user5716448 wrote:

    We have a windows server and have installed 2 oracle clients for 11.2.0.3
    A 32-bit one and a 64-bit one.
    Installed the 64 bit one under one account on the server and the 32 bit one under another.
    No need for separate users - that in fact simply makes o/s maintenance more complex.
    We have a third-party application which requires mainly 64-bit version, and some services which require the 32 bit one?
    You need to set the correct environment. A client needs two basic environment setting to work (using standard network-based Oracle client-server):
    a) PATH (or LD_LIBRARY_PATH on *nix) must be set, so that the client will load the correct Oracle client driver DLL
    b) optionally, TNS_ADMIN needs to be set and point to the directory containing the tnsnames.ora and sqlnet.ora files

    The 32bit and 64bit clients, need different PATH settings as the DLL to load reside in different locations. The TNS_ADMIN setting can be the same - allowing both 32bit and 64bit versions to share the same client config files. Makes this aspect of maintenance also easier.

    Do not use Oracle on Windows, but I suspect that OCI DLL is named differently for 32bit and 64bit - e.g. oci32.dll and oci64.dll for example. In this case, the PATH can safely include both 32bit and 64bit directories as there are no file name collisions.

    A 32bit client will find and load its specific DLL from the PATH, as would a 64bit client.

    If you have full client Oracle installations, that will include Oracle executables like tnsping and sqlplus. In this case you will have both 32bit and 64bit executables. So if you run the 32bit tnsping, it will use the 32bit client files. Likewise, running the 64bit tnsping will use the 64bit client files.

    Likely you will also have ORACLE_HOME set - which means when running tnsping for example, that ORACLE_HOME will be used for tnsnames.ora and sqlnet.ora configurations. (which you can override by setting TNS_ADMIN instead).

    A full client installation however makes little sense - unless this is a developer or DBA client installation. For standard database user clients, you should be using Oracle Instant Client instead. A lot smaller. No Windows registry junk. Easily managed via the PATH and TNS_ADMIN settings.
  • 6. Re: Oracle client and tnsping
    user5716448 Explorer
    Currently Being Moderated
    Thanks for the detailed advice.

    Is Oracle Instant Client an option of part of the oracle client install or a separate installation executabe altogether?

    Thanks
  • 7. Re: Oracle client and tnsping
    orafad Oracle ACE
    Currently Being Moderated
    Instant Client is separate and there's no installer either. Simply copy 2-3 files to a folder of choice, set environment and you're off.

    http://www.oracle.com/technetwork/database/features/instant-client/index-097480.html

    For dotnet there's a separate package too, called ODAC, based on Instant Client. Exists in installer or "xcopy" package variants.
  • 8. Re: Oracle client and tnsping
    user5716448 Explorer
    Currently Being Moderated
    Thanks again.
  • 9. Re: Oracle client and tnsping
    user5716448 Explorer
    Currently Being Moderated
    Hi

    ora-12557 tnsproctol not loadable when try tnsping as user who has 32bit oracle cleint as oracle home

    Have set sep user env variables for 64 and 32 bit clients.

    Guus had already set up full oracle client.

    64 bit fine but get tns error with the 32-bit cleint.

    Any ideas?

    Thanksw
  • 10. Re: Oracle client and tnsping
    BillyVerreynne Oracle ACE
    Currently Being Moderated
    Are the same tnsnames.ora and sqlnet.ora files used?

    I suggest using TNS_ADMIN and setting it to a common directory. E.g. for 64bit use only ORACLE_HOME - but for 32bit also set TNS_ADMIN to the 64bit ORACLE_HOME\network\admin directory.

    Alternatively you need to provide the tnsping error, the TNS alias definition used, and the contents of the applicable sqlnet.ora, in order for forum members to have a look at.
  • 11. Re: Oracle client and tnsping
    user5716448 Explorer
    Currently Being Moderated
    Thanks for idea

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points