3 Replies Latest reply: Nov 17, 2012 1:31 PM by user5716448 RSS

    ora-12557 tnsproctol not loadable 2 oracle_homes on same server

    user5716448
      Hi,


      We have windows server with 2 oracle_homes (11.2.0.3) - 32 bit client and 11.2.0.3 64 bit client.

      64-bit one can tnspinh <SID>fine

      32-bit one get tns protocol not loadable.

      Have set user environment variables for PATH and ORACLE_HOME and also TNS_ADMIN fto try and forec the 32-bit one to be able to tnsping O.Kora-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.

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

      Any ideas how can have both as application needs 32-bit libraries (user32) and 64 bit libraries (user64)
        • 1. Re: ora-12557 tnsproctol not loadable 2 oracle_homes on same server
          Osama_Mustafa
          Check MOS notes :
          'ORA-12557: TNS:Protocol Adapter Not Loadable' While Running OUI [ID 735400.1]
          • 2. Re: ora-12557 tnsproctol not loadable 2 oracle_homes on same server
            orafad
            user5716448 wrote:
            We have windows server with 2 oracle_homes (11.2.0.3) - 32 bit client and 11.2.0.3 64 bit client.
            >
            Have set user environment variables for PATH and ORACLE_HOME and also TNS_ADMIN fto try and forec the 32-bit one to be able to tnsping O.Kora-12557 tnsproctol not loadable when try tnsping as user who has 32bit oracle cleint as oracle home
            Remove ORACLE_HOME and TNS_ADMIN. (The former should not be set as env variable on Win -- working installs have it set in Registry keys.)

            Set PATH to include 64 bit Oracle install at the top (first entry in PATH).

            Try tnsping <tns alias>

            Try tnsping hostname:port/service_name

            Set PATH to include 32-bit Oracle at the top.

            Try tnsping again as above.

            Copy-paste complete command line session from above in a follow up post here.
            • 3. Re: ora-12557 tnsproctol not loadable 2 oracle_homes on same server
              user5716448
              Hi,

              Works O.K if do instructiosn you specified doing it manually.

              However, her is the situation we have but cannot set path explcilty at session level in this way.

              3rd party reporting application - most of this requires 640-bit oracel client libraries so makes sens for this oracle_hoem to be first in path an this fine and this O.K these services run under account user_64

              However, some of it requires 32-bit libraries so had hoped to run these services under different windows user account, user_32 hence setting up of user environment variable for only this user ORACLE_HOME so this user would pick up this ORACLE_HOME which does but tnsping fails as not first in path.

              Tried solution mentioned in previous post PATH=%ORACLE_HOME%\bin%path% but still no joy.

              Would we have to ensure no system environment variable for path and just 2 user environment variables for path.

              user_32 with oracle_home 32 as firts in path and user_64 with oracle_home64 first in path

              Thanks

              Edited by: user5716448 on 17-Nov-2012 11:31