Solved

TOAD OCI.DLL error on Oracle 11g

Posted on 2009-03-31
5
12,617 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Age Calculation from specific date 19 55
Read CLOB data from Oracle using JAVA 3 39
User Prompt in Vertica SQL (vsql) 1 33
emailing registered email addresses in phpmyadmin 5 63
Shadow IT is coming out of the shadows as more businesses are choosing cloud-based applications. It is now a multi-cloud world for most organizations. Simultaneously, most businesses have yet to consolidate with one cloud provider or define an offic…
Shell script to create broker configuration file using current broker Configuration, solely for purpose of backup on Linux. Script may need to be modified depending on OS-installation. Please deploy and verify the script in a test environment.
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…
This video shows how to Export data from an Oracle database using the Datapump Export Utility.  The corresponding Datapump Import utility is also discussed and demonstrated.

737 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