Reinstalled 11g client...now Navigator "Cannot load OCI DLL: oci.dll"

SQL Navigator
1

(Win7 64 bit using 11g 32 bit Client)

I ended up reinstalling Oracle 11g client on my box and now Navigator won’t load. The oci.dll error is raised and then the app closed. I can connect to databases via SQL*Plus without a problem and as far as I can tell, all necessary files are in the their expected location. I tried uninstalling/reinstalling Navigator and it didn’t change anything. I’ve gone through the previous threads on this problem but haven’t found anything helpful. FYI, I am not using an instant client.

Any ideas why Navigator would think there is no Oracle client? Navigator worked perfectly fine until I reinstalled the client.

2

My bad - the copy of the client I have is mislabeled - it’s actually the 64 bit client. I’ll install the 32 bit and go from there.

3

Hi Dan,

Yes SQLNav only support 32 bit client, go ahead to reinstall 32 bit and try again.
Any issue found, please feel free to contact us anytime, thanks.

Regards,
Shirly

4

I am having this issue with SQL Optimizer 8.8.0 for Oracle. I have three Oracle installations. Oracle 11.2.0.1 x32, Oracle 11.2.0.1 x64, and Ora 6i Forms/Reports. My system path variable has reference in the order listed previously (11g x32, 11g x64, 6i). I continue to get this error. I’ve tried removing HKCU Quest Optimizer Hive and it didn’t work. I’ve tried varying the path and to no avail. Please assist.

5

Hi Kevans,

Do you have SQL Optimizer 8.8.0 32 bit or 64 bit? When did you see the OCI error? Is it when you launch SQL Optimizer or when you try to create a session in
SQL Optimizer? Do you have the same OCI error when you use SQL Navigator too?

Thanks,

Vincent

From: kevans [mailto:bounce-kevans@toadworld.com]

Sent: Thursday, 10 October 2013 8:44 AM

To: sqlnav@toadworld.com

Subject: RE: [SQL Navigator - Discussion Forum] Reinstalled 11g client…now Navigator “Cannot load OCI DLL: oci.dll”

RE: Reinstalled 11g client…now Navigator "Cannot load OCI DLL: oci.dll"

Reply by kevans

I am having this issue with Question SQL Optimizer 8.8.0 for Oracle. I have three oracle installations Oracle 11.2.0.1 x32, Oracle 11.2.0.1 x64, and Ora 6i Forms. My system path variable has
reference in the order listed abave (11g x32, 11g x64, 6i). I continue to get this error. I’ve tried removing HKCU Quest Optimizer Hive and it didn’t work. I’ve tried varying the path and to no avail. Please assist.

To reply, please reply-all to this email.

Stop receiving emails
on this subject.

Or Unsubscribe from SQL Navigator - General
notifications altogether.

SQL Navigator - Discussion Forum

Flag
this post as spam/abuse.

6

I have SQL Optimizer 8.8.0.2585 x64 (doesn’t say 32 or 64 in Help | About, but it’s installed to the ‘C:\Program Files’ and not ‘c:\Program Files (x86)’. If I bring up SQL Optimizer stand-along (without Toad already open), I get it during the create connection. If I have Toad open and execute SQL Optimizer from Database | Optimize | Advanced SQL Optimization, I get it when I click the Auto Optimize. Both display the error on connection: Dialogue ‘Check Connection’ with the message “Cannot load OCI DLL: c:\orant\bin\oci.dll”. Below is my currrent path environment variable/statement:

c:\oracle\product\11.2.0\client32\bin;c:\oracle\product\11.2.0\client64\bin;C:\orant\bin;C:\Program Files (x86)\AMD APP\bin\x86_64;C:\Program Files (x86)\AMD APP\bin\x86;%SystemRoot%\system32;%SystemRoot%;%SystemRoot%\System32\Wbem;%SYSTEMROOT%\System32\WindowsPowerShell\v1.0;C:\Program Files (x86)\Shoreline Communications\ShoreWare Client;C:\Program Files (x86)\ATI Technologies\ATI.ACE\Core-Static;C:\Program Files (x86)\Borland\StarTeam SDK 9.2\Lib;C:\Program Files (x86)\Borland\StarTeam SDK 9.2\Bin;C:\Program Files\Microsoft\Web Platform Installer;C:\Program Files (x86)\Microsoft ASP.NET\ASP.NET Web Pages\v1.0;C:\Program Files (x86)\Windows Kits\8.0\Windows Performance Toolkit;C:\Program Files\Microsoft SQL Server\110\Tools\Binn;C:\orant\jdk\bin

Sorry, I do not have SQL Navigator, I may be in the wrong forum, but the majority of posts regarding this error were here.

Thank you in advance for your feedback/help. Anything I can provide or try are appreciated.

I know that I could probably uninstall the x64 suite and install the x32, but I’d much rather resolve and move forward than step back. Thx again.

7

Well, interesting. I figured out what was going wrong. From the Connection Manager, the Installed Clients | Connect Using was defaulting to the Oracle 6i Report/Forms home. Once I selected the 11g home, presto. Usually the products select by default the home which is first listed in the system PATH and uses connections from what is specified by the TNS_ADMIN system variable. Thanks Vincent for helping!