Missing Database from drop down list

[spike]

I've got a couple of people round here that have a strange problem I can't seem to resolve. They are running the 32 bit Oracle 12c client with the latest 32 bit version of PSD. Despite PSD being able to find the tnsnames.ora file (as it shows in in the support section) and having the correct ORACLE home selected, none of the people can log on. When you get a connection screen there are no databases listed in the drop down. tnsping works OK as does SQL Developer from Oracle.

I can't find anything different in their set up when compared to mine (that does work).

Anyone seen this before? I can't seem to find anything on the forums. All the issues I can find relate to not being able to find the tnsnames.ora, which doesn't appear to be an issue here.

Any help appreciated as people are having to use SQL Developer instead.

 

[Marco Kalter]

Can you start PL/SQL Developer without connecting, go to Help > Support Info, press the 'Copy all pages' button on this info screen, and paste this text into an e-mail reply? Can you do this on both your PC and on a PC that has these problems?

 

[William Robertson]

Do the tnsping commands all return the same thing, and are all the tnsnames.ora and sqlnet.ora files the same?

Also, do the SQL Developer connections use TNS (rather than JDBC, which in my experience is more common for SQL Dev), and can the other users connect via SQL*Plus?

Most sites I've worked on use LDAP these days (sqlnet.ora has "NAMES.DIRECTORY_PATH=(LDAP,ONAMES,TNSNAMES,HOSTNAME)", and tnsping reports "Used LDAP adapter to resolve the alias"), and the legacy TNSNAMES.ora setup can just be a distraction (we ignore the list of TNS instances to connect to because the ones we want aren't in it).