How to setup oracle odbc on vagrant machine?

Question

Oracle

Hello!
I have an ubuntu-64 LTS 12.04 VM raised with vagrant.
It is necessary to configure an ODBC connection to the Oracle database on it.
If I understand correctly, this requires unixodbc and an oracle client.
I used this instruction: https://help.ubuntu.com/community/Oracle%20Instant...
The installation was OK, but I don't quite understand where I need to put the tnsnames.ora files now so that I can connect to the DB (this is for sqlplus to work).
The /usr/lib/oracle/12.1/client64/ folder contains bin and lib. There is no /network/admin inside them (as in Windows).
Can you please tell me if I missed something? And is there a good, written in simple language instructions for setting up unixodbc?

Answer 1

You installed Instant Client, but it doesn't have network/admin by default, even under Windows. To be honest, I don’t remember how it was, but for starters, you can try to simply create network / admin inside client64.
The official doc advises creating the $TNS_ADMIN environment variable so that you can place tnsnames.ora anywhere. In the same place:

If the TNS_ADMIN environment variable is not set, and TNSNAMES entries such as inst1, and so on, are used, then the ORACLE_HOME variable must be set, and the configuration files are expected to be in the $ORACLE_HOME/network/admin directory.