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: 563

Filed under:

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

Related posts about Oracle