tnsnames.ora

[discordian]

I searched the FAQ and the forum for this and I apologize in advance in case I just missed it.

I have dbeaver v2.1.0 installed (had the same prblem with 2.0.7) on Ubuntu 12.04. How do I specify where to look for my tnsnames.ora file for the Oracle Thin connection? When I flip over to TNS tab, the tnsnames dropdown lets me type in it, but the dropdown is grayed out.

Things I've tried:
1. create tns_names variable in dbeaver's preferences and point it to directory where tnsnames.ora file can be found.
2. make sure ORACLE_HOME environment is set and $ORACLE_HOME/network/admin/tnsnames.ora exists and is readable.
3. made a copy of tnsnames.ora in /etc directory

I know my tnsnames.ora file is correct. sqldeveloper from oracle uses it (from the /etc directory) without any issues.

Thanks for your help.

[Serge]

Hello,

At first I have to admit that TNNAMES issue was tested only for Windows. Hopefully after your report it will work on Linux as well
tnsnames file can't be found because of case sensitive file names on Linux. Now it looks for ORACLE_HOME/Network/Admin/TNSNAMES.ORA file. Obviously it should always use lower case names.

Currently as a workaround I may suggest to declare environment variable TNS_ADMIN which will point to the directory where tnanames.org file lives (e.g. "/etc"). One problem is that DBeaver looks for file TNSNAMES.ORA (in upper case). You may try to copy tnsnames.ora into TNSNAMES.ORA.

Next DBeaver version will fix this problem.

Thansk for report!