TNS-12557: TNS:protocol adapter not loadable

Hi All,

We have installed IDM on a test system( another instance is running ecc6). as per the

The document of "SAP NetWeaver Identity Management Identity Center

Getting Started" discribes that I should choose "Oracle Provider for OLEDB", however, I can't see it in the providers list. So we installed OLEDB with a different oracle home f:/oledb from the link

But after the installation Oracle Provider for OLE DB is visible but the oracle database id of IDM and ecc6 is not able to ping using tnsping.

When I use tnsping to CO9( ecc6 ), it is showing following errors with a pop up.


The procedure entry point snlinAddrLocalhost could not be located in thedynamic link library oranl10.dll


If we click OK, it is showing following error


C:\Documents and Settings\co9adm>tnsping co9

TNS Ping Utility for 32-bit Windows: Version - Production on


008 10:39:55

Copyright (c) 1997, 2003, Oracle. All rights reserved.

Used parameter files:


Used TNSNAMES adapter to resolve the alias

Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS =


.WORLD) (PROTOCOL = TCP) (HOST = server6) (PORT = 1527))) (CONNECT_DATA


(SID =


TNS-12557: TNS:protocol adapter not loadable

C:\Documents and Settings\co9adm>


tnsping issue was not because of the

listner.ora or tnsping.ora entries missing as the entries are correctly

there. But the issue is that after installing the ODP.NET ,

the dynamic link library oranl10.dll seems to be missing.

"The procedure entry point snlinAddrLocalhost could not be located in the

dynamic link library oranl10.dll"

Ie is why we are getting" TNS-12557: TNS:protocol adapter not loadable".

If you search google it clearly tells it is because of that dynamic linklibrary ( ie here i guess it is oranl10.dll ) is missing. Do you have

any idea how we can install the missing dynamic link library?.

Helpful Answer