32 bit PLSQL DEV , 64 bit Windows 7 and 32 bit Oracle Client

[FahimP]

I have been trying to use plsql developer with 64 bit windows 7 and a 32 bit oracle client, but it has been a pain in the neck for last many days. I have tried every solution online. Please help resolve this issue.

PL/SQL Developer
Version 12.0.3.1821 (32 bit)
01.112935 - Unlimited user license
Service Contract: 01/04/2018
Windows 7 (64-bit) Build 7601 (Service Pack 1)

Physical memory : 33,540,948 kB (6,880,652 available)
Paging file : 67,080,020 kB (37,076,752 available)
Virtual memory : 2,097,024 kB (1,881,340 available)

Parameters
C:\Program Files (x86)\PLSQL Developer 12\plsqldev.exe

Preferences
Session mode: Multi
OCI Library: C:\Oracle\instantclient_12_2\bin\oci.dll
Use OCI7: False
Allow Multiple Connections: True

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

License File
C:\ProgramData\PLSQL Developer\aalf.dat

Debug file
C:\Users\ifsrmt3\AppData\Roaming\PLSQL Developer 12\PlSqlDev.elf

Plug-Ins
*Active Query Builder (C:\Program Files (x86)\PLSQL Developer 12\PlugIns\ActiveQueryBuilder.dll)
*PL/SQL Documentation (plsqldoc) (C:\Program Files (x86)\PLSQL Developer 12\PlugIns\plsqldoc.dll)
(* is Active)

Aliases

Homes
odac (C:\Oracle\instantclient_12_2\)

DLLs
C:\Oracle\instantclient_12_2\bin\oci.dll

TNS File

Using
Home: C:\Oracle\instantclient_12_2
DLL: C:\Oracle\instantclient_12_2\bin\oci.dll
OCI: not initialized

Process
Working Set = 92,839,936
Memory = 34,160,672
GDI Objects = 717
User Objects = 348
Handles = 182

Monitor
PixelsPerInch = 96

Id = 0
Primary = True
Handle = 65537
Left = 0
Top = 0
Width = 1680
Height = 1050

MainFormOnTaskbar = False

 

[Marco Kalter]

I see you are using an Oracle Instant Client. Does the file C:\Oracle\instantclient_12_2\bin\oci.dll exist? Can you confirm that this is a 32 bit Oracle Client?

 

[FahimP]

I have both 32 | 64 bit Oracle Clients.
C:\Oracle\instantclient_12_2\
C:\Oracle\instantclient_12_1_64\

The file oci.dll exists in following paths
C:\Oracle\instantclient_12_2\
C:\Oracle\instantclient_12_2\bin
C:\Oracle\instantclient_12_1_64\

i have tried all but no luck and same error.

 

[Marco Kalter]

What exactly is the error message? Feel free to contact support@allroundautomations.com for faster turnaround times.

 

[FahimP]

The error is a sample

 

[Marco Kalter]

Can you start C:\Oracle\instantclient_12_2\bin\sqlplus.exe and check if you can connect?