TNS-12557: TNS:protocol adapter not loadable

[Former Member]

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

http://www.oracle.com/technology/software/tech/windows/ole_db/index.html.

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 10.1.0.2.0 - Production on

19-JUN-2

008 10:39:55

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

Used parameter files:

C:\usr\sap\CO9\SYS\profile\oracle\sqlnet.ora

Used TNSNAMES adapter to resolve the alias

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

(COMMUNITY = SAP

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

=

(SID =

CO9) (GLOBAL_NAME = CO9.WORLD)))

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 10.1.0.4.0 ,

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?.

[markus_doehr2 · Accepted solution]

> C:\Documents and Settings\co9adm>tnsping co9

>

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

> 19-JUN-2

> 008 10:39:55

>

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

First I would recommend using a supported database version, 10.1 is not supported.

From the installation guide:

<quote>

The Identity Center supports the following database systems:

u2022 Microsoft SQL Server version 2000 or 2005

u2022 Oracle version 10.2

</quote>

Markus

[Former Member · Accepted solution]

Hi

Check the PATH environmental varialble and other also.

The error is in those things. Please ractify that and u would get rid of this problem.

[Former Member · Accepted solution]

Hi Marcus,

The oracle version is 10.2 itself

Please check this.

###

SQL> select * from v$version;

BANNER

-

---

Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Prod

PL/SQL Release 10.2.0.2.0 - Production

CORE 10.2.0.2.0 Production

TNS for 32-bit Windows: Version 10.2.0.2.0 - Production

NLSRTL Version 10.2.0.2.0 - Production

###

>TNS Ping Utility for 32-bit Windows: Version 10.1.0.2.0

ie it seems like TNS Ping Utilities version.

But when I uninstalled OLE DB 1.4.0, it is working fine.

###########

C:\Documents and Settings\Administrator>tnsping co9

TNS Ping Utility for 32-bit Windows: Version 10.2.0.2.0 - Production on 20-JUN-2

008 12:02:32

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

Used parameter files:

C:\oracle\CO9\102\network\admin\sqlnet.ora

Used TNSNAMES adapter to resolve the alias

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

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

9) (GLOBAL_NAME = CO9.WORLD)))

OK (20 msec)

C:\Documents and Settings\Administrator>

##########

But now TNS utility version have been changed back to Version 10.2.0.2.0 "

"TNS Ping Utility for 32-bit Windows: Version 10.2.0.2.0 .

Do you have any other tips?

[Former Member · Accepted solution]

Hi Deepak

Can you please tell exactly what should be set in path variable as I could not find any issues with my path variable

C:\Program files\PHP\;C:\oracle\CO9\102\bin;c:\sapdb\programs\bin;c:\sapdb\programs\pgm;%SystemRoot%\system32;%SystemRoot%;%SystemRoot%\System32\Wbem;C:\j2sdk1.4.2_08\bin

Also this tnsping issue is automatically fixed, if we uninstall the OLE DB 1.4.0 and the tnsping will work properly as shown in my previous post. I guess the issue is with the missing DLL files.

Do you have any tips?

[Former Member · Accepted solution]

Hi Deepak,

I was able to fix this when I changed the path of the oledb installtion in PATH variable to the last while it was first earlier.

Now the path is like this

C:\Program Files\PHP\;C:\oracle\CO9\102\bin;c:\sapdb\programs\bin;c:\sapdb\programs\pgm;%SystemRoot%\system32;%SystemRoot%;%SystemRoot%\System32\Wbem;C:\j2sdk1.4.2_08\bin;D:\oracle\product\10.1.0\Client_1\bin;D:\oracle\product\10.1.0\Client_1\jre\1.4.2\bin\client;D:\oracle\product\10.1.0\Client_1\jre\1.4.2\bin;

Thank you once again. but I am getting another error

ORA-12154: TNS:could not resolve service name

when I try to create a connection to database c24 using IDM Identity center create database configuration wizard, even though I am able to use tnsping to successfully to c24( IDM database).

C:\Documents and Settings\Administrator>tnsping c24

TNS Ping Utility for 32-bit Windows: Version 10.2.0.2.0 - Production on 23-JUN-2

008 12:29:46

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

Used parameter files:

C:\oracle\CO9\102\network\admin\sqlnet.ora

Used TNSNAMES adapter to resolve the alias

Attempting to contact (DESCRIPTION = (ADDRESS = (COMMUNITY = SAP.WORLD)(PROTOCOL

= TCP)(HOST = server6)(PORT = 1527)) (CONNECT_DATA = (SERVER = DEDICATED) (SERV

ICE_NAME = c24)))

OK (20 msec)

##

It seems like the note 443867 have solution which i am refering now. Do you have any quick tips?

[Former Member · Accepted solution]

Hi

Yes this is the note,

It would help you out.

[Former Member · Accepted solution]

Hi Deepak

Earlier I said, the error when clicking the test connection in Netweaver Identity center , Identity center database configuration wizard is

##

Test Connection Failed because of an error in initializing provider. ORA-12154: TNS: could not

resolve the connect identifier specified

###

Now it is showing

###

Test connection Failed because of an error in initializing provider. ORA-12557: TNS:protocol

adapter not loadable

###

This issue does not seems anything related with lisntner.ora, tnsnames.ora, sqlnet.ora

as I am able to tnsping and login successfully in sqlplus

###

C:\Documents and Settings\Administrator>tnsping c24

TNS Ping Utility for 32-bit Windows: Version 10.2.0.2.0 - Production on 25-JUN-2

008 18:56:50

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

Used parameter files:

C:\oracle\CO9\102\network\admin\sqlnet.ora

Used TNSNAMES adapter to resolve the alias

Attempting to contact (DESCRIPTION = (ADDRESS = (COMMUNITY = SAP.WORLD)(PROTOCOL

= TCP)(HOST = server6)(PORT = 1527)) (CONNECT_DATA = (SERVER = DEDICATED) (SERV

ICE_NAME = c24)))

OK (10 msec)

C:\Documents and Settings\Administrator>

###

##

C:\Documents and Settings\Administrator>sqlplus mxmc_admin/test@c24

SQL*Plus: Release 10.2.0.2.0 - Production on Wed Jun 25 18:59:05 2008

Copyright (c) 1982, 2005, Oracle. All Rights Reserved.

Connected to:

Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production

With the Partitioning, OLAP and Data Mining options

SQL>

###

Do you have any idea about this "Test Connection Failed because of an error in initializing provider."

Please give some tips.

[Former Member]

this is solved

[Former Member]

Hello ,

Please check , ORACLE_SID is not set

setenv ORACLE_SID=<ORA SID> and then try again

Regards

Pratap

[Former Member]

The issue is fixed now.

What I did was installed a new oracle home on the server with database for IDM and oledb ( oracle provider for oledb, oracle for odbc etc). In the same installation itself under option "custom" (you need to have oracle installation cd to see this option as stage products) you will get oledb and data access drivers and we do not have to download it separately. There you need to select oracle windows interface 10.2. and options like oledb etc .Also on the next step click on create a database. also I have removed the oracle_home environment variable for administrator.