unable to connect using 11g rel2 client on 64 bit windows 7

vid

Member
I am trying to use PL/SQL developer 8.0.4 against 11g rel2 [11.2.0.2.0] client but the pl/sql developer is not able to detect the 11g oracle home and its relative tns names. I was looking in past post and checked a few things:

I am able to connect using sqlplus.exe and oci.dll is found in by bin folder. I tried tools=> preferences=> connection => OCI library : C:\app\thotav\product\11.2.0\client_1\bin\oci.dll. It still did not work.

Following are the configurations in [oracle info]
Info
PL/SQL Developer
Version 8.0.4.1514
01.56763 - 50 user license
Windows 7 (64-bit) 6.1 Build 7601 (Service Pack 1)

Physical memory : 4,123,900 kB (2,368,704 available)
Paging file : 4,194,304 kB (4,194,304 available)
Virtual memory : 2,097,024 kB (1,972,056 available)

Parameters
C:\Program Files\PLSQL Developer\plsqldev.exe

Preferences
Session mode: Multi
OCI Library: C:\app\thotav\product\11.2.0\client_1\bin\oci.dll
Use OCI7: False

Preference Files
C:\Users\thotav\AppData\Roaming\PLSQL Developer\Preferences\default\Default.ini
C:\Users\thotav\AppData\Roaming\PLSQL Developer\Preferences\thotav\default.ini

Plug-Ins

Aliases

Homes

DLLs
C:\app\thotav\product\11.2.0\client_1\bin\oci.dll

TNS File

Using
Home:
DLL: C:\app\thotav\product\11.2.0\client_1\bin\oci.dll
OCI: not initialized

Registry :
SOFTWARE\ORACLE

Path


C:\app\thotav\product\11.2.0\client_1\bin
C:\Windows\system32
C:\Windows
C:\Windows\System32\Wbem
C:\Windows\System32\WindowsPowerShell\v1.0\
 
I had a similar problem, help is only putting "C: \ app \ thotav \ product \ 11.2.0 \ client_1 \ bin" at the beginning of the PATH variable.

It was on XP, I am not sure about W7.

I hope this has helped.
 
Back
Top