Oracle Linked Server error: ORA-12640: Authentication adapter initialization failed
        Posted  
        
            by Chenster
        on Stack Overflow
        
        See other posts from Stack Overflow
        
            or by Chenster
        
        
        
        Published on 2010-04-15T00:10:47Z
        Indexed on 
            2010/04/15
            0:13 UTC
        
        
        Read the original article
        Hit count: 637
        
Oracle
I have a linked server on SQL Server that talks to Oracle. Executing the following sql statement using Openquery
 SELECT * FROM OPENQUERY(finance, 'select * from KFRI.VW_XREF_PROJECTS')
will get error as the following:
OLE DB provider "OraOLEDB.Oracle" for linked server "finance" returned message "ORA-12640: Authentication adapter initialization failed".
Msg 7303, Level 16, State 1, Line 1
Cannot initialize the data source object of OLE DB provider "OraOLEDB.Oracle" for linked server "finance".
I tried to set :
SQLNET.AUTHENTICATION_SERVICES= (NONE)
in {$ORACLE_HOME}\NETWORK\ADMIN\sqlnet.ora. It did not help. What's interesting is my coworker is able to execute the exactly same query successfully on his machine without a hitch.
Any tips on how to fix this is greatly appreciated!!
© Stack Overflow or respective owner