This discussion is archived
3 Replies Latest reply: Nov 17, 2012 11:31 AM by user5716448 RSS

ora-12557 tnsproctol not loadable 2 oracle_homes on same server

user5716448 Newbie
Currently Being Moderated
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 Oracle ACE
    Currently Being Moderated
    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 Oracle ACE
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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

Legend

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