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 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 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 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 o
FAQ Contact Us Frequently Asked Questions: Which version should I use, 32bit or 64bit? 32bit programs need to use the 32bit Oracle Client. 64bit programs need to use the 64bit Oracle Client. Use the version that matches the Oracle Client that you have installed. The 64bit version can access more memory than the 32bit version, but beyond that there are no differences. What Oracle Client versions are supported? It's important to use the version that works with your Oracle Server. In general this means that you should use an Oracle Client version that is equal to or higher than the highest Oracle Server version that you use. Newer versions of our products use the Oracle Unicode Client calls by default and so require clients that support these calls. If you need to use an http://serverfault.com/questions/249666/initialization-error-while-trying-to-connect-to-oracle-using-sqldeveloper older Oracle Client you can uncheck the "Use Uncode Oracle Client Calls" option on the login options window. In general we recommend the 11.2 Oracle Client or higher as Oracle fixed a problem described in the next question. Why am I getting error ORA-12154 when I try to login to Oracle on my 64bit Windows Operating System? On 64bit Operating Systems the installer will install 32bit software into a directly containing "(x86)". Some versions of the Oracle Client won't work if an http://www.benthicsoftware.com/faq.html application using the client is installed in a directory path containing "()" characters. To fix this just install the program to a directory that doesn't have "()" characters in it or install a newer version of the Oracle Client that doesn't have this problem. This is Oracle Bug #3807408 and should be fixed in newer client versions (note: seems to be fixed in the 11.2 client.) Why am I getting an error "Can not initialize OCI" or "Cannot load OCI DLL" when I try to login? This means that the program couldn't load the Oracle Client. This can happen in the following cases: a. The Oracle Client is missing or installed incorrectly. b. You are trying to use the 64bit version of the Oracle Client with either Golden 5.x or the 32bit version of Golden 6.x. Golden 5.x needs the 32bit Oracle Client. c. You are trying to use the 32bit version of the Oracle Client with the 64bit version of Golden 6.x. Golden 6.x 64bit needs the 64bit Oracle Client. d. The user does not have read or execute rights to the Oracle Client files. To quickly check if it's a rights problem, right click the startup icon and choose "Run as administrator". If that fixes the problem then the issue is that the user account is missing read or execute rights to an Oracle Client file. Why am I seeing #data_error# messages in the datagrid or the results look like Chinese
em 4 de junho de 2013 por Capitão Caverna Olá, Estava montando meu ambiente de desenvolvimento Oracle no Windows 8 / 64 bits e https://brunoantognolli.wordpress.com/2013/06/04/pl-sql-developer-initialization-error-could-not-load-oci-dll/ tive problema com o SQLDeveloper, que mostrei como resolver aqui. Além do SqlDeveloper eu costumo utilizar o PL SQL Developer e como nem tudo são flores, eu também http://www.toadworld.com/products/toad-for-oracle/f/10/t/20009 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 initialization error 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 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 initialization error could 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 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/SQ
NoSQL Oracle SQL Server PRODUCTSDiscussion & Resources Benchmark Factory Code Tester for Oracle SharePlex SQL Navigator SQL Optimizer Spotlight Stat Toad Intelligence Central Toad Data Modeler Toad Data Point Toad Extension for Eclipse Toad for Hadoop Toad for IBM DB2 Toad for Oracle Toad for MySQL Toad for SQL Server Toad for SAP Solutions Toad MAC Edition Home » Products » Toad for Oracle » Toad for Oracle Forum » TOAD Error: cannot load OCI DLL in TAOD_FOR_ORACLE_FREEWARE12.0.0.61 TOAD Error: cannot load OCI DLL in TAOD_FOR_ORACLE_FREEWARE12.0.0.61 Toad for Oracle Community Join Overview Forum Code Tester for Oracle Forum Spotlight on Oracle Forum SQL Optimizer for Oracle Forum Toad for Oracle Forum Blog Code Tester for Oracle Blog Spotlight on Oracle Blog SQL Optimizer for Oracle Blog Toad for Oracle Blog Idea Pond Connections Debug Editor General Grid Import/Export Monitor MyToad Other Schema Browser Team Coding Utilities Wiki Code Tester for Oracle Wiki Spotlight on Oracle Wiki SQL Optimizer for Oracle Wiki Toad for Oracle Wiki Media Code Tester for Oracle Videos Spotlight on Oracle Videos SQL Optimizer for Oracle Videos Toad Apps Toad for Oracle Videos Beta Beta Overview Beta Forum Members Forum Options RSS Feed Tweet Related Posts RE: TOAD Error: cannot load OCI DLL for TAOD_FOR_ORACLE_FREEWARE12.0.0.61 by Bert Scalzo on 2 Aug 2013 Not Answered Cannot load OCI DLL error after upgrade and/or copy user settings by michael.tessier on 15 Oct 2014 Not Answered oci dll error by Guest on 11 Oct 2010 View More This question has suggested answer(s) TOAD Error: cannot load OCI DLL in TAOD_FOR_ORACLE_FREEWARE12.0.0.61 Follow PankajUkharde / 2 Aug 2013 at 10:57am Hi I got error while connecting to Toad for oracle(12.0.0.61)_freeware: TOAD Error: cannot load OCI DLL: c:\Users\patilpan\Downloads\Softs\instanntclient_12_1\oci.dll, but the file is there in mentioen directory, Please help. Create an account to join the discussion. You have posted to a forum that requires a moderator to approve posts before they are publicly available. Replies All Replies Follow Bert Scalzo / 2 Aug 2013 at