11 Replies Latest reply: Nov 18, 2012 2:21 PM by user5716448 RSS

    Oracle client and tnsping

    user5716448
      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
          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
            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
              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....
                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
                  Billy~Verreynne
                  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
                    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
                      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
                        Thanks again.
                        • 9. Re: Oracle client and tnsping
                          user5716448
                          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
                            Billy~Verreynne
                            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
                              Thanks for idea