can't logon with 32-bit Oracle Instant client, tnsnames list now showing

[William Peck 195]

I'm trying to get pl-sql developer working on a new Windows 10 machine. It's almost working (I think) but I can't get tnsnames to show up.

I have 64-bit Oracle client loaded and working, as I have a 64-bit client tool that properly connects.

I have these Preferences:
Oracle Home: c:\oracle_32\TNS_ADMIN (where I have tnsnames)
OCI Library: c:\oracle_32

To get 32-bit PL-Sql Developer working, I tried to "install" 32-bit Oracle Instant client, and that's kind of different . . . First I learned that it's not really an install, just unzip and go . . . so I put that in C:\oracle_32.

Per the documentation (Feb 2013, pg. 15), I added the following environment variables:
PATH, TNS_ADMIN, NLS_LANG

Per this experts-exchange. post, I added the additional Environment Variables:
SQLPATH, LD_LIBRARY_PATH, all pointing to c:\oracle_32

I think it's working except for TNSNAMES not coming up. At first I got "C:\oracle\product\12.1.0\client_1\bin\oci.dll", but I don't get that anymore.

 

[Marco Kalter]

For the 32 bit version of PL/SQL Developer you need to use a 32 bit Oracle Client. In case of an Oracle Instant Client you need to set the following environment variables:

• PATH
  Needs to include the Instant Client directory (where oci.dll is located).
• TNS_ADMIN
  Needs to point to the directory where sqlnet.ora and/or tnsnames.ora is located.
• NLS_LANG=language_territory.characterset
  Defines the language, territory, and character set for the client.. For example AMERICAN_AMERICA.WE8MSWIN1252.

[/list]

 

[William Peck 195]

very good, I did that (and a few other things), and it's working ! :grin: