Pl Sql Developer Initialization Error Could Not Load Oci Dll

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 could not locate oci dll toad company Business Learn more about hiring developers or posting ads with us Server Fault initialization error could not locate oci dll toad Questions Tags Users Badges Unanswered Ask Question _ Server Fault is a question and answer site for system and network administrators. Join

Load Library Oci.dll Returned 0

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

Pl Sql Developer Initialization Error Sql Net Not Properly Installed

to Oracle using 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 oracle client downloads Mar 20 '11 at 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| Did you find this question interesting? Try our newsletter Sign up for our newsletter and get our top new questions delivered to your inbox (see an example). Subscribed! Success! Please click the link in the confirmation email to activate your subscription. 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 thi

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

Could Not Locate Oci Dll Oracle 11g

not post a blank message. Please type your message and try again. More oci.dll download discussions in Database Installation All PlacesDatabaseGeneral Database DiscussionsDatabase Installation This discussion is archived 7 Replies Latest reply on Jun cannot load oci dll oci dll 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 http://serverfault.com/questions/249666/initialization-error-while-trying-to-connect-to-oracle-using-sqldeveloper 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, https://community.oracle.com/thread/622900 91447Views 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

em 4 de junho de 2013 por Capitão Caverna Olá, Estava montando meu ambiente de desenvolvimento Oracle no Windows 8 / 64 bits e tive problema com o SQLDeveloper, que mostrei como resolver https://brunoantognolli.wordpress.com/2013/06/04/pl-sql-developer-initialization-error-could-not-load-oci-dll/ aqui. Além do SqlDeveloper eu costumo utilizar o PL SQL Developer e como nem tudo são flores, eu também tive problemas com a instalação do PL SQL Developer. A mensagem que eu recebia ao tentar utilizar o PL SQL Developer dizia o seguinte: _____________________________________________________________ [Window Title] PL/SQL Developer [Content] Initialization error Could not initialize "C:\app\Bruno\product\11.2.0\dbhome_1\bin\oci.dll" Make sure you have the 32 bits Oracle Client oci dll installed. OracleHomeKey: OracleHomeDir: C:\app\Bruno\product\11.2.0\dbhome_1 Found: oci.dll Using: C:\app\Bruno\product\11.2.0\dbhome_1\bin\oci.dll LoadLibrary(C:\app\Bruno\product\11.2.0\dbhome_1\bin\oci.dll) returned 0 [OK] _____________________________________________________________ Para resolver esse problema primeiramente baixe um client Oracle de 32 Bits: instantclient-basic-nt-11.2.0.3.0.zip http://www.oracle.com/technetwork/topics/winsoft-085727.html Em seguida, descompacte o client 32 bits em um diretório de sua preferência. Na tela de login do PL Sql Developer clique em "CANCEL", a tela inicial do programa será exibida. Procure por: Tolls -> Preferences. Em "OCI could not locate Library" adicione o caminho da oci.dll 32bits. Em seguida, o erro de DLL será resolvido. Aplique a alteração e reinicie sua ferramenta. Confira meu perfil profissional no LinkedIn e faça parte da minha rede. https://lnkd.in/w9kyFR Bruno F. Antognolli. Compartilhe isso:TwitterFacebookCurtir isso:Curtir Carregando... Relacionado Esse post foi publicado em Banco de Dados, Oracle e marcado 64 bits, client 32, client 32 bits, desenvolvimento, Erro, oci.dll, oracle client, PL SQL Developer por Capitão Caverna. Guardar link permanente. 10 respostas em “Pl Sql Developer Initialization error could not loadoci.dll” Flávia Gomes em 27 de junho de 2013 às 11:45 disse: Bruno, bom dia. Estou obtendo um erro semelhante: Initialization error Could not locate OCI dll OracleHomeKey: SOFTWARE\ORACLE\KEY_OraClient11g_home1 OracleHomeDir: C:\oracle\product\product\11.2.0\client_1 Se eu fizer o que você sugere neste post, consigo logar mas não consigo visualizar as tabelas e qualquer query trava o PL/SQL. Alguma outra sugestão? Obrigada. Comentar ↓ Flávia Gomes em 27 de junho de 2013 às 14:22 disse: Conseguimos identificar qual era o problema: na máquina tem tanto o Oracle 10 quanto o 11 e a path do sistema não estava referenciando o ORAHOME do 10, só do 11. Parece que