This content has been marked as final. Show 3 replies
Check MOS notes :
'ORA-12557: TNS:Protocol Adapter Not Loadable' While Running OUI [ID 735400.1]
We have windows server with 2 oracle_homes (22.214.171.124) - 32 bit client and 126.96.36.199 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 homeRemove 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.
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
Edited by: user5716448 on 17-Nov-2012 11:31