Solved

TOAD OCI.DLL error on Oracle 11g

Posted on 2009-03-31
5
12,519 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
Comment Utility
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
Comment Utility
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
Comment Utility
thanks experts.
@fox9106:
install a 32 bit client of what?
0
 
LVL 1

Accepted Solution

by:
fox9106 earned 300 total points
Comment Utility
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

What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

Join & Write a Comment

Suggested Solutions

CCModeler offers a way to enter basic information like entities, attributes and relationships and export them as yEd or erviz diagram. It also can import existing Access or SQL Server tables with relationships.
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…

743 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

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now