Solved

TOAD OCI.DLL error on Oracle 11g

Posted on 2009-03-31
5
12,557 Views
Last Modified: 2013-12-18
Dear Experts -
I've intalled oracle 11g on Windows Vista 64bit. I've Toad 9.7.x.
I'm getting the following error when i tried to connect to oracle from Toad.
Cannot load OCI DLL: C:\app\st\product\11.1.0\db_1\BIN\oci.dll

Thanks in advance for your time and help.
0
Comment
Question by:sventhan
  • 2
5 Comments
 
LVL 4

Assisted Solution

by:pinkuray
pinkuray earned 200 total points
ID: 24036764
Hi,
In Vista you will get the error the best way to use oracle in vista is make a virtual server system and load oracle 11g on you can use any linux or windows OS then use toad or any other tool to access oracle.
0
 
LVL 1

Expert Comment

by:fox9106
ID: 24044752
I had the same problem. In my case I've installed the Oracle Database 11g for 64 bits and TOAD only works with clients with 32 bits.

To solve this problem install a 32 bit client.


0
 
LVL 18

Author Comment

by:sventhan
ID: 24045157
thanks experts.
@fox9106:
install a 32 bit client of what?
0
 
LVL 1

Accepted Solution

by:
fox9106 earned 300 total points
ID: 24048624
Install the Oracle Client 32 bits.

You can download the oracle client 32 bits from this links

Oracle Database 11g Release 1 Client (11.1.0.6.0)
for Microsoft Windows (32-bit)
http://www.oracle.com/technology/software/products/database/oracle11g/111060_win32soft.html

or

Oracle Database 10g Client Release 2 (10.2.0.3)
http://www.oracle.com/technology/software/products/database/oracle10g/htdocs/10203vista.html

0

Featured Post

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Entity Framework is a powerful tool to help you interact with the DataBase but still doesn't help much when we have a Stored Procedure that returns more than one resultset. The solution takes some of out-of-the-box thinking; read on!
I annotated my article on ransomware somewhat extensively, but I keep adding new references and wanted to put a link to the reference library.  Despite all the reference tools I have on hand, it was not easy to find a way to do this easily. I finall…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.

832 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question