Oracle Error Ora-12640
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 6.2 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up Oracle Linked Server error: ORA-12640: Authentication adapter initialization failed up vote 1 down vote favorite 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!! oracle share|improve this question asked Apr 15 '10 at 0:10 Chensformers 1,73422239 Connecting as the same user in both cases? Same software? Same subnet? Same tnsnames.ora file? –Dave Jarvis Apr 22 '10 at 1:13 add a comment| 3 Answers 3 active oldest votes up vote 1 down vote accepted Just to clarify - you are both connecting to the same SQL Server box that has a linked server to Oracle, and his query executes and yours does not, correct? I want to rule out oracle drivers and configuration issues. If you're both logging onto the SQL Server to run your query, then you need to look at how your linked server is set to handle authentication. Is it passing through your credentials (make sure you have permissions on the Oracle box), or is it using a set of Oracle credentials? If it's using Oracle credentials, then I have no idea what's going on. If you and your co-worker each have SQL Server installed on your respective local machines, and have both created a linked server, then you should check your Oracle driver, then check your permissions on Oracle, and make sure you have the sam
sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. Results 1 to 7 of 7 Thread: Enough of ORA-12640. Please help. Tweet Thread Tools Show Printable Version Subscribe to this Thread… Search Thread Advanced Search Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode 02-27-07,07:54 #1 Andurin View Profile View Forum Posts Registered User Join Date Aug 2004 Location Istanbul Posts 17 Unanswered: Enough of ORA-12640:Authentication adapter initialization failed. Please help. Hello to all, First I want http://stackoverflow.com/questions/2641892/oracle-linked-server-error-ora-12640-authentication-adapter-initialization-fai to start with my faulting server description: (Lets name this machine as Machine91) Oracle 10g release 10.2.0.2.0 MS Windows 2003 Enterprise Edition with service pack 1 and IIS 6.0 I've a web application (ASP.NET application) gives the following error when ever I try to login (that checks my password and username etc. from an oracle database). "ORA-12640: Authentication adapter initialization failed." Ok, I have a solution for this problem which is: The original entry in http://www.dbforums.com/showthread.php?1615519-Enough-of-ORA-12640-Please-help sqlnet.ora file : SQLNET.AUTHENTICATION_SERVICES = (NTS) Changing this one to: SQLNET.AUTHENTICATION_SERVICES = (NONE). But I simply don't want to use it. Because. This web project works without problem if I place and configure it on my local machine which is a Windows XP professional with IIS 5.1. The same web application successfully connects to the oracle database (that database server is the same server that I mentioned above *Machine91 ) and logins to the program... What is the difference ? why Machine91's IIS can not connect to the Oracle DB on it self and give "ORA-12640: Authentication adapter initialization failed." error ? Any ideas ? Thank you very much. Note: If more information is needed for you to answer I can give additional information. Please just ask. Last edited by Andurin; 02-27-07 at 08:04. Reply With Quote 02-27-07,11:01 #2 LKBrwn_DBA View Profile View Forum Posts Registered User Join Date Jun 2003 Location West Palm Beach, FL Posts 2,713 The most common cause of permission problems when you are trying to run ASP pages is the fact that the IIS users do not have read & execute access on the %ORACLE_HOME% directory and subdirectories (%ORACLE_HOME%\bin in particular). You may need to do a SQL*Net trace to identify the source of your error. To enable SQL*Net tracing, in the sqlnet.ora file add the following lines: trace_level_client=16 trace_file_client=c
CommunityOracle User Group CommunityTopliners CommunityOTN Speaker BureauJava CommunityError: You don't have JavaScript enabled. This tool uses JavaScript and much of it will not work correctly without it enabled. Please turn JavaScript back on and reload this page. https://community.oracle.com/thread/2618762 Please enter a title. You can not post a blank message. Please https://community.oracle.com/community/developer/search.jspa?q=ORA-12640 type your message and try again. More discussions in General Database Discussions All PlacesDatabaseGeneral Database Discussions This discussion is archived 0 Replies Latest reply on Jan 9, 2014 8:14 AM by user472167 Oracle Windows Sevice does not start (ORA-12640: Authentication adapter initialization failed) user472167 Jan 9, 2014 oracle error 8:14 AM I converted a physical windows 2003 machine to a virtual hyperv machine.The following error occurs in oradim.log when I try to start the Oracle Windows Service on the virtual server:ORA-12640: Authentication adapter initialization failedI recreated the service and the password file but with no luck.I also tried to change sqlnet.ora with the following: (Replaced NTS to NONE)SQLNET.AUTHENTICATION_SERVICES= oracle error ora-12640 (NONE)In this case the service was started but when I tried to connect as sysdba using sqlplus "/ as sysdba" the "ORA-01031: insufficient privileges" error occurs. If you connect using the password then it connects fine. But I would like to be able to connect without a password because I have some scripts that I do not want to hardcode the sysdba password.I also removed and readded the administrator password from ORA_DBA group but again with no luck. I have the same question Show 0 Likes(0) 202Views Tags: none (add) ora-01031Content tagged with ora-01031, oracleContent tagged with oracle, sysdbaContent tagged with sysdba, windowsContent tagged with windows, seviceContent tagged with sevice, oradim.logContent tagged with oradim.log, ora-12640Content tagged with ora-12640 This content has been marked as final. Show 0 replies Actions About Oracle Technology Network (OTN)My Oracle Support Community (MOSC)MOS Support PortalAboutModern Marketing BlogRSS FeedPowered byOracle Technology NetworkOracle Communities DirectoryFAQAbout OracleOracle and SunRSS FeedsSubscribeCareersContact UsSite MapsLegal NoticesTerms of UseYour Privacy Rights© 2007-2016 Jive Software | Powered by Home | Top of pageJive Software Version: 8.0.3.1 , revision: 20160414082626.1619a91.release_8.0.3.x
CommunityOracle User Group CommunityTopliners CommunityOTN Speaker BureauJava CommunityError: You don't have JavaScript enabled. This tool uses JavaScript and much of it will not work correctly without it enabled. Please turn JavaScript back on and reload this page.Search this communityOracle CommunityBridged communitiesOracle BlogsOracle University TrainingOracle VideosOTN DocumentationOTN Search ResultsSearch forSearch forContentSearch forPeopleSearch forPlacesLast modifiedLast modifiedAll timeLast modified1 dayLast modified7 daysLast modified30 daysLast modified90 daysLast modified1 yearSort byRelevanceRelevanceLast modifiedLast modifiedRestrict results byRestrict results by: PeopleRestrict results by: PlacesSubspace depthSubspace depthNo subspacesSubspace depthChild subspacesSubspace depthAll subspacesMatchingMatch names onlyDeactivated UsersShow/HideShowShowAll contentShowBlog postsShowDocumentsShowDiscussionsShowPollsShowIdeasShowStatus updatesShowMessagesShowExternal activityShowShowAll placesShowSpacesShowProjectsShowGroupsContent marked asShowAll ContentShowFinalShowReservedShowCommunity RecommendedShowOutdatedShowAction ItemShowDecisionShowHelpfulShowResolvedShowCommunity Feedback RequestedSocial Search On/OffSearchSearch TipsView more results from Oracle BlogsView more results from Oracle University TrainingView more results from Oracle VideosView more results from OTN DocumentationView more results from OTN Search ResultsAbout Oracle Technology Network (OTN)My Oracle Support Community (MOSC)MOS Support PortalAboutModern Marketing BlogRSS FeedPowered byOracle Technology NetworkOracle Communities DirectoryFAQAbout OracleOracle and SunRSS FeedsSubscribeCareersContact UsSite MapsLegal NoticesTerms of UseYour Privacy Rights© 2007-2016 Jive Software | Powered by Home | Top o