10 Replies Latest reply: Jun 27, 2008 2:58 PM by Sahad K RSS

TNS-12557: TNS:protocol adapter not loadable

Sahad K
Currently Being Moderated

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

  • Re: TNS-12557: TNS:protocol adapter not loadable
    Markus Doehr
    Currently Being Moderated

    > 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

    • Re: TNS-12557: TNS:protocol adapter not loadable
      Deepak Sharma
      Currently Being Moderated

      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.

      • Re: TNS-12557: TNS:protocol adapter not loadable
        Sahad K
        Currently Being Moderated

        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?

      • Re: TNS-12557: TNS:protocol adapter not loadable
        Sahad K
        Currently Being Moderated

        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?

        • Re: TNS-12557: TNS:protocol adapter not loadable
          Deepak Sharma
          Currently Being Moderated

          Hi

           

          Yes this is the note,

          It would help you out.

          • Re: TNS-12557: TNS:protocol adapter not loadable
            Sahad K
            Currently Being Moderated

            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.

    • Re: TNS-12557: TNS:protocol adapter not loadable
      Sahad K
      Currently Being Moderated

      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?

  • Re: TNS-12557: TNS:protocol adapter not loadable
    Nagendra Pratap Singh
    Currently Being Moderated

    Hello ,

     

    Please check , ORACLE_SID is not set

     

    setenv ORACLE_SID=<ORA SID> and then try again

     

    Regards

    Pratap

    • Re: TNS-12557: TNS:protocol adapter not loadable
      Sahad K
      Currently Being Moderated

      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.

  • Re: TNS-12557: TNS:protocol adapter not loadable
    Sahad K
    Currently Being Moderated

    this is solved

Actions