Oracle Error 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 installe
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. Please enter a title. You can not post a blank message. Please 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 http://stackoverflow.com/questions/2641892/oracle-linked-server-error-ora-12640-authentication-adapter-initialization-fai 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= https://community.oracle.com/thread/2618762 (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 https://community.oracle.com/community/developer/search.jspa?q=ORA-12640 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 oracle error 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 oracle error 12640 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 of pageJive Software Version: 8.0.3.1 , revision: 20160414082626.1619a91.release_8.0.3.x