CAN NOT FIND OCI DLL

SQL Navigator
1

Hello,

I have installed on a machine SQL Nvigator 5.5 and instantclient_10_2
When I try to connect through SQL Navigator it sent a message CAN NOT FIND OCI DLL, I already check the folder that instantclient created and the oci.dll is there, I changed the PATH variable and add at the begining the path where the oci.dll is located

2

Sql nav. version: 5.5.4?
you are using 32 bits version of the instant client?

I would suggest installing SQL Nav and the instance client in a folder with no ().

Also check the last post by Bruce on http://sqlnavigator.inside.quest.com/thread.jspa?threadID=623

I would suggest upgrading SQL nav.

Message was edited by: Fsilva

3

I already check the version and it’s 5.0.0.607. both the os and the instantclient are 32-bit

4

5.0 is kind of old version…I couldn’t find info…but from the 5.5 release notes I got:

"Some Instant Client Light clientzip package distributions have been found contain the oraociei10.dll DataShared Library instead oraociicus10.dll (specific for the light client). SQLNavigator requires oraociicus10.dlln if using the light client or it will failto start; workaround: add the oraociicus10.dll to the light clientdirectory."
Also if you are trying to connect to a 11g database that it only possible with at least version 5.4
I do not know if instant client was already supported for 5.0 version.
Maybe someone from quest can help you more…

good luck

5

The machine has the basic instant client package plus the odbc package, this is a list of the dll files that are in the instantclient_10_2 folder:

oci.dll
ocijdbc10.dll
ociw32.dll
orannzsbb10.dll
oraocci10.dll
oraociei10.dll
sqora32.dll
sqoras32.dll
sqresja.dll
sqresus.dll

does any dll file is missing?

6

From in the info I have I think that DB version 10.2 was not supported in SQL Nav 5.0.