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