Not able to locate oci.dll for instant 11.2 32 bit clinet

Latest Sqlnav 6.5, windows 7 64 bit OS

On win 7 64 bit I have a local 64 bit database with 64 bit client.
B/cSql nav does not support 64 bit I have also installed 32 bit instant client light (11.2.0.2). I have added this instant client to PATH

Sqlnav cannot seem to find oci.dll, unless I start it from the directory where instant clent was unpacked.

I have also noticed that this instant client is not recognized by sqlnav as a valid home (BTW it is recognized by TOAD) :

SOFTWARE\ORACLE (Oracle Root)
ORACLE_HOME_NAME:
ORACLE_HOME:
ORACLE_SID:
NLS_LANG:
SQLPATH:
LOCAL:
Home directory does NOT exist!
Home is NOT valid!

Instant Client - 11.2.0.1.0
ORACLE_HOME_NAME: C:\Apps\Oracle\product\11.2.0\instantclient_11_2
ORACLE_HOME: C:\Apps\Oracle\product\11.2.0\instantclient_11_2
ORACLE_SID:
NLS_LANG:
SQLPATH:
LOCAL:
C:\Apps\Oracle\product\11.2.0\instantclient_11_2exists.
C:\Apps\Oracle\product\11.2.0\instantclient_11_2is in PATH.
Client DLL: C:\Apps\Oracle\product\11.2.0\instantclient_11_2\oci.dll
Client Version: 11.2.0.1.0
Home is NOT valid!

Hi zgur,

Sorry for a late reply on your post on another thread....

Could you please send us the the support bundle from your Win 7 environment.

In SQL Navigator, pls go to menu Help->Submit Feedback, then save click Save to File, then attach the .dta file with your post.

I have a 11g light client on Win 7 and having it first in the Path System Variable, everything is working fine...

Thanks and regards,
Bruce

Message was edited by: bruceduong

From your screenshot I can tell that you are not using instant client, I think i is the regular Oracle client, which you install using the installer.

Instant client is a zip archive you simply unpack to your harddrive.

it can be downloaded here:
http://www.oracle.com/technetwork/topics/winsoft-085727.html

I used this package :

Instant Client Package - Basic Lite: Smaller version of the Basic, with only English error messages
and Unicode, ASCII, and Western European character set support (10.2 only)

instantclient-basiclite-nt-11.2.0.2.0.zip
SupportBundle.dta (5.34 KB)

Hi,

Thank you very much for you the support bundle and your notes on the client on my envi.

We can confirm that we have issues in SQL Navigator to detect the 11g instant client as invalid. SQL Navigator is currently looking for oraociei10.dll, if the file is not there, it will assume the client is not valid. We will fix it for you in the next v6.6 release and it will be in the first v6.6 Beta drop.

The work around is to make a copy of oraociei11.dll and rename it to oraociei10.dll in the directory C:\Apps\Oracle\product\11.2.0\instantclient_11_2.

Please note that SQL Navigator can ONLY work with 1 instant client having it to be first in the path system variables, The instant client will be the default home.

Can you please make changes to your path to have the instant client path to be first in the list:

Path=C:\Apps\Oracle\product\11.2.0\instantclient_11_2;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0;C:\Apps\Perforce;C:\Apps\TextPad 5;C:\Apps\ant-1.8.2\bin;C:\Apps\Java\jdk1.6.0_25\bin;C:\Apps\MySQL\MySQLServer5.5\bin;c:\Apps\Oracle\product\11.2.0\dbhome_1\bin;C:\Apps\cygwin\bin;C:\Program Files (x86)\Intel\Services\IPT\

Thanks and regards,
Bruce
nav.jpeg

Hi,

Thank you very much for you the support bundle and your notes on the client on my envi.

We can confirm that we have issues in SQL Navigator to detect the 11g instant client as invalid. SQL Navigator is currently looking for oraociei10.dll, if the file is not there, it will assume the client is not valid. We will fix it for you in the next v6.6 release and it will be in the first v6.6 Beta drop.

The work around is to make a copy of oraociei11.dll and rename it to oraociei10.dll in the directory C:\Apps\Oracle\product\11.2.0\instantclient_11_2.

Please note that SQL Navigator can ONLY work with 1 instant client having it to be first in the path system variables, The instant client will be the default home.

Can you please make changes to your path to have the instant client path to be first in the list:

Path=C:\Apps\Oracle\product\11.2.0\instantclient_11_2;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0;C:\Apps\Perforce;C:\Apps\TextPad 5;C:\Apps\ant-1.8.2\bin;C:\Apps\Java\jdk1.6.0_25\bin;C:\Apps\MySQL\MySQLServer5.5\bin;c:\Apps\Oracle\product\11.2.0\dbhome_1\bin;C:\Apps\cygwin\bin;C:\Program Files (x86)\Intel\Services\IPT\

Thanks and regards,
Bruce

Thanks, the workaround resolved my issue. One minor note - oraorciei11.dll does not exist in the home, the source dll name is oraocci11.dll

Funny thing is that on your screen shot the home is being recognized as 11.2.0.1 incorrectly (i assume you have downloaded the latest client from my link). Same thing exists for TOAD 11.2.0.2 instant client is recognized as 11.2.0.1 client.

On my machine the client is being recognized correctly as 11.2.0.2 :

SOFTWARE\ORACLE (Oracle Root)
ORACLE_HOME_NAME:
ORACLE_HOME:
ORACLE_SID:
NLS_LANG:
SQLPATH:
LOCAL:
Home directory does NOT exist!
Home is NOT valid!
Instant Client - 11.2.0.2.0
ORACLE_HOME_NAME: C:\Apps\Oracle\product\11.2.0\instantclient_11_2
ORACLE_HOME: C:\Apps\Oracle\product\11.2.0\instantclient_11_2
ORACLE_SID:
NLS_LANG:
SQLPATH:
LOCAL:
C:\Apps\Oracle\product\11.2.0\instantclient_11_2 exists.
C:\Apps\Oracle\product\11.2.0\instantclient_11_2 is in PATH.
Client DLL: C:\Apps\Oracle\product\11.2.0\instantclient_11_2\oci.dll
Client Version: 11.2.0.2.0
Home is valid.

Hi zgur,

Thanks for letting us know.

As per my previous note, we will need to make more changes to check the version of Oracle instant client…In your environment, it shows the correct version since you use oraocci11.dll as the base of the work around. That dll has the correct version as 11.2.0.2

We will clean up the routine and the verison checking should work in the next release for you.

Thanks and regards,
Bruce

Message was edited by: bruceduong

Hi, I have latest SqlNavigator 6.6 on windows 7 32 bit

oracle instant client installed.

Instant Client - 11.2.0.1.0
ORACLE_HOME_NAME: C:\PROGRAM FILES\ORACLE\BIN
ORACLE_HOME: C:\PROGRAM FILES\ORACLE\BIN
ORACLE_SID:
NLS_LANG: AMERICAN_AMERICA.WE8MSWIN1252
SQLPATH: C:\Program Files\Oracle\bin
LOCAL:
C:\PROGRAM FILES\ORACLE\BIN exists.
C:\PROGRAM FILES\ORACLE\BIN is in PATH.
Client DLL: C:\PROGRAM FILES\ORACLE\BIN\oci.dll
Client Version: 11.2.0.1.0
Home is valid.

when I try to open Job Manager, it return me error:
ORA-01019: unable to allocate memory in the user side.

Same version work fine with full Oracle client installation.

Thx.

Hi,

It’s a known issue that Job Manager does not work with instant client. We have already had CR 14403 for it. We’ll let you know when we can fix this.

Thanks,
Vincent