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 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\