plsql 12 64bit logon database list is empty

[Talent]

I install plsql developer 12 64bit, in win10 64bit,use Oracle ODAC 12 64bit,
and change plsql shortcut target to "C:\Program Files\PLSQL Developer 12\plsqldev.exe" InstantClient=C:\OracleClient, the system enviroment variable already config ORACLE_HOME,Path,TNS_ADMIN .

But when I Logon, the Database dropdownlist is empty. It look like plsql can't find TNS file.

Help, please.
Thanks.

 

[Marco Kalter]

Can you go to Help > Support Info, press the 'Copy all pages' button on this info screen, and paste this text into an e-mail reply?

 

[JamesJr]

Hi Marco,

Not sure if this has ever been resolved.

But we recently installed Oracle Client 19 64bit and PLSQL Developer 11 64bit on a Windows 10 PC encountered the same problem.

Here's the content of the Support Info screen:
PL/SQL Developer
Version 11.0.0.1762
01.100458 - 20 user license
Service Contract: None
Windows 8 (64-bit) 6.2 Build 9200

Physical memory : 2,097,152 kB (2,097,152 available)
Paging file : 4,194,304 kB (4,194,304 available)
Virtual memory : 2,097,024 kB (1,895,636 available)

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

Preferences
Session mode: Multi
OCI Library:
Use OCI7: False
Allow Multiple Connections: True

Preference Files
C:\Program Files (x86)\PLSQL Developer\Preferences\Default\Default.ini
C:\Users\A0814538\AppData\Roaming\PLSQL Developer\Preferences\A0814538\default.ini

License File
C:\Users\A0814538\AppData\Roaming\PLSQL Developer\aalf.dat

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

Plug-Ins
*Active Query Builder (C:\Program Files (x86)\PLSQL Developer\PlugIns\ActiveQueryBuilder.dll)
*PL/SQL Documentation (plsqldoc) (C:\Program Files (x86)\PLSQL Developer\PlugIns\plsqldoc.dll)
*Red Gate Deployment Plug-In (C:\Program Files (x86)\PLSQL Developer\PlugIns\RedGate.dll)
*Version Control Interface 1.2 (C:\Program Files (x86)\PLSQL Developer\PlugIns\VCS.dll)
(* is Active)

Aliases

Homes

DLLs
D:\app\Oracle\product\19.0.0\client_1\bin\oci.dll

TNS File

Using
Home:
DLL:
OCI: not initialized

Monitor
Id = 0
Primary = True
Handle = 65537
Left = 0
Top = 0
Width = 1366
Height = 768

MainFormOnTaskbar = False

 

[Marco Kalter]

Your PL/SQL Developer version is 32 bit, so this also requires a 32 bit version of the Oracle Client. 32 bit applications cannot use the 64 bit client, and 64 bit applications cannot use the 32 bit client. It needs to match.

 

[JamesJr]

Hi Marco,

I see... my mistake, didn't realize that when I was given the information.

Thanks a lot for helping with this. Much appreciated.