TNS-12557: TNS protocol adapter not loadable
Dear Friends,
I had an Oracle client (10.2.0) installation on my local machine (windows XP) along with the OBIEE version 10.1.3. The setup was working fine. Recently I upgraded the version of the OBIEE to 10.1.3.3.3. After the upgrade, the oracle client started behaving weirdly.
Whenever I try to tnsping or connect to a oracle database from command prompt, I get the error as TNS-12557: TNS protocol adapter not loadable with a pop-up saying "The procedure entry point snlinAddrLocalhost could not be located in the dynamic link library oranl10.dll". I checked the BIN directory of the Oracle client and the dll is available there. Also, by bin directory is set in PATH environment variable of the machine.
I am able to connect to Oracle using SQL*Plus though, but this happens when I try it from say command prompt. And unfortunately, the same is happening through OBIEE portal and I am getting the same error as I get from the command prompt. So I guess whenever I am using an external interface like a command prompt or say the OBIEE to access the database, I am getting this error. Also, I don't have multiple client installation, and my ORACLE_HOME is set to the sole installation home directory that I have in that machine. The ORACLE_HOME is set in my machine's environment variable setting too.
Can you please guide me as to what could be the possible problem. Thanking you in anticipation,
Regards,
Parashar.