Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Oracle 9i client and TOAD

8681Mar 9 2006 — edited Mar 9 2006

Hi,

I am trying to use Toad tool to connect to Oracle database and view/edit sql tables queries etc

For that purpose I also installed Oracle 9i client application on windows xp

I have tnsnames.ora and sql ora file in my Oracle path .... network/admin

When I open Toad - New Connection, - It shows Database dropdown list as it has read it from the tnsnames.ora

I input User/Schema and Password

I select connect as option as "Normal"

When I hit Ok I get following error in Toad popup dialog box :---
"Initialization error Could not locate OCI dll

When I click "Details" button of dialog box it gives details as :---

Building Oracle HOMES List
HOME Name OraHome92 added to list.
HOME Name OraHome92 added to list
Found multiple homes, searching each HOME x for valid PATH
searching in SOFTWARE\ORACLE\HOME1
Oracle_Home found in
SOFTWARE\ORACLE\HOME1 is in system path !

searching in SOFTWARE\ORACLE\HOME0
Unloading previous Oracle DLL

Oracle Guru please tell me how to get rid of this problem so that I can connect using TOAD to database

thanks,
pp

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 6 2006

Added on Mar 9 2006

#database-installation

3 comments

37,368 views