Pl Sql Initialization Error Could Not Locate Oci.dll
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 Database Installation All PlacesDatabaseGeneral Database DiscussionsDatabase Installation This discussion is archived 7 Replies Latest reply on Jun 26, 2013 4:24 PM by VijayanandSettin Could not locate OCI dll 569278 Feb 21, 2008 10:19 AM Hi, I have OracleEx 10g and Odp.NET 11g (ODTwithODAC1110620.exe) installed on my machine, now when I try to install OUnit11 I got the error as title. I have in my enviroment variables "PATH" the following: C:\app\ahmad\product\11.1.0\client_1; (this the path for odp.net 11g) C:\app\ahmad\product\11.1.0\client_1\bin; (this the path for odp.net11g) C:\oraclexe\app\oracle\product\10.2.0\server\bin; (this for OracleEx 10g) is it correct that the existence of two Oracle Home the envrioment variables causes this problem? if not, then how to fix the error I am getting? Thanx, 91444Views Tags: none (add) This content has been marked as final. Show 7 replies 1. Re: Could not locate OCI dll 569278 Feb 21, 2008 10:27 AM (in response to 569278) Okay, I found this in the forums: oci.dll not found when installing 11g client and using PL/SQL I don't know if it is apply in my case because I right click on "C:\app" but there is nothing called "authenticated users" in the users names! so should I add it? Like Show 0 Likes(0) Actions 2. Re: Could not locate OCI dll 569278 Feb 21, 2008 5:03 PM (in response to 569278) Any idea? Like Show 0 Likes(0) Actions 3. Re: Could not locate OCI dll 629590 Mar 20, 2008 2:08 PM (in response to 569278) Guys, I installed Oracle 11g client because of the reported fix of System.Transactions issue known in 10g. I use PL/SQL developer, and it told me "Initialization error: Could not locate OCI dll", though the registry entry and ORAHOME folder it showed were Ok. It seems like PL/SQL developer was looking for OCI.dll not in the reported ORAHOME folder but in ORAHOME\bin folder. After copying all files (luckily, they are quite few) from ORAHOME root to bin PL/SQL developer began to work correctly. Like Show 0 Likes(0) Actions 4. Re: Could not locate OCI dll 569278 Mar 20, 2008 2:38 PM (in response to 629590) Aftering doing the same as you did, the error message no more appears, b
Start 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 Server Fault Questions Tags Users Badges Unanswered Ask Question _ Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute: Sign up Here's how it works: Anybody can ask a question Anybody can answer The best answers are voted up and rise to the top Initialization error while trying to connect to Oracle using https://community.oracle.com/thread/622900 SQLDeveloper up vote 2 down vote favorite I've installed Oracle 11.2.0 and Allround Automations' SQLDeveloper on Windows 7 64-bit. When I run SQLDeveloper and and try to connect to Oracle, I get the below error: Initialization error Could not load "C:\app\MyComp\product\11.2.0\dbhome_1\bin\oci.dll" OCIDLL forced to C:\app\MyComp\product\11.2.0\dbhome_1\bin\oci.dll LoadLibrary(C:\app\MyComp\product\11.2.0\dbhome_1\bin\oci.dll) returned 0 What can be the problem? windows-7 64-bit oracle-11g plsql sqldeveloper share|improve this question edited Jul 13 '11 at 23:34 Andrew Russell 1135 asked Mar 20 '11 at http://serverfault.com/questions/249666/initialization-error-while-trying-to-connect-to-oracle-using-sqldeveloper 19:11 Gali migrated from stackoverflow.com Mar 21 '11 at 1:29 This question came from our site for professional and enthusiast programmers. add a comment| 2 Answers 2 active oldest votes up vote 1 down vote This happens because PL/SQL Developer is incapable of loading 64-bit version of oci.dll file. To fix this, download the 32-bit version of Oracle Instant Client, extract it to a directory such as \instant_client. Next, configure PL/SQL Developer to use this version by clicking on Tool menus -> Preferences. Under Oracle Home, point to the location where you had extracted Instant client (\instant_client, in this case) and under location of OCI Library, point to the oci.dll file present in location where you had extracted Instant client ( \instant_client\oci.dll). Restart PL/SQL Developer and you should be able to connect now. share|improve this answer answered Mar 21 '11 at 8:56 Sathya 2471522 add a comment| up vote 0 down vote I had a similar problem and Ihad to specify the complete file path of oci.dll alongwith the actual oci.dll filename. share|improve this answer answered Jun 4 '14 at 23:01 user223857 1 could you write instructions - how and where did you do it. I have /instantclient folder in the PATH variable.. the oci.dll is in it –Boppity Bop May 2 at 16:52 add a comment| Your Answer dra
not locate OCI dll OracleHomeKey: SOFTWARE\ORACLE\KEY_OraClient11g_homeOracleHomeDir: D:\app\aneesh.thilakan\product\11.2.0\client_1---------------------------OK --------------------------- Solution: 1. Copy oci.dll from folder c:\app\user\product\11.2.0\client_1 2. Paste it in the folder c:\app\user\product\11.2.0\client_1\bin You had done! http://livetechnique.blogspot.com/2012/08/plsql-developer-initialization-error.html Now open your PL/SQL Developer. Posted by Aneesh Thilak at 6:56 AM Email ThisBlogThis!Share to TwitterShare to FacebookShare to Pinterest Labels: Could not locate OCI dll, Initialization error, PL/SQL Developer 195 comments: Hanieh Variani said... it does not work, and an empty mgsBox appear with "Not Login " title!!! January 15, 2013 at 9:24 PM Anonymous said... It's pl sql hard to come by experienced people for this subject, but you seem like you know what you're talking about! ΤhanκsHere is my weblog loans for people with bad credit January 28, 2013 at 12:22 AM Anonymous said... Аρρreciatе the rеcommendation.Will try it out.my webpage - 1 month loan February 6, 2013 at 11:48 PM Anonymous said... Wοаh! I'm really pl sql initialization digging the template/theme of this site. It's simρle, yet effectiѵe.A lot of times it's tough to get that "perfect balance" between usability and visual appeal. I must say you'νe donе a fantastic job with this.In aԁditiοn, the blog loads veгy fast foг mе οn Oрerа.Outstanding Blog!Feel free to visit my ωеb blog one month loanFeel free to surf my weblog ; one month loan February 11, 2013 at 8:54 AM Anonymous said... hello therе anԁ thank you for your infο - I havе definitelу pіckеd uρ anythіng new from гight here. I did hoωever exρertіse ѕοme tеchnіcal іssues using this site, sinсe I expеrіеnсеd tο relоad thе web site а lot of times ргevious to I cοuld get it tο lοaԁ pгοperly.Ι had bееn ωondering if your web hostіng іs ОK?Νot that ӏ am complаinіng, but sloω lοading іnstancеs times ωill very fгequently affect your placement in google and can ԁamage уouг high-quаlity ѕcοrе if advertiѕing anԁ marketing with Αdωords.Anywaу I am adding this RSS to my emaіl and coulԁ looκ out fοr much