{"action":"opened","issue":{"url":"https://api.github.com/repos/laurenz/oracle_fdw/issues/50","labels_url":"https://api.github.com/repos/laurenz/oracle_fdw/issues/50/labels{/name}","comments_url":"https://api.github.com/repos/laurenz/oracle_fdw/issues/50/comments","events_url":"https://api.github.com/repos/laurenz/oracle_fdw/issues/50/events","html_url":"https://github.com/laurenz/oracle_fdw/issues/50","id":129469236,"number":50,"title":"tnsnames.ora","user":{"login":"jottyfan","id":13251275,"avatar_url":"https://avatars.githubusercontent.com/u/13251275?v=3","gravatar_id":"","url":"https://api.github.com/users/jottyfan","html_url":"https://github.com/jottyfan","followers_url":"https://api.github.com/users/jottyfan/followers","following_url":"https://api.github.com/users/jottyfan/following{/other_user}","gists_url":"https://api.github.com/users/jottyfan/gists{/gist_id}","starred_url":"https://api.github.com/users/jottyfan/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jottyfan/subscriptions","organizations_url":"https://api.github.com/users/jottyfan/orgs","repos_url":"https://api.github.com/users/jottyfan/repos","events_url":"https://api.github.com/users/jottyfan/events{/privacy}","received_events_url":"https://api.github.com/users/jottyfan/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":0,"created_at":"2016-01-28T14:36:23Z","updated_at":"2016-01-28T14:36:23Z","closed_at":null,"body":"Setting up oracle instant client may be not so easy, but using alien to convert rpm packages to deb files in Debian works quite well. Nevertheless, when one needs tnsnames.ora, there must be set an environment variable TNS_ADMIN that leads to the location of the tnsnames.ora. I didn't find it easy to configure this in oracle_fdw. But there's an easy solution: oracle instant client searches for tnsnames.ora in /etc, when there is no TNS_ADMIN set. It would be great to have this hint in your readme on setup instructions to save time for oracle_fdw users as tnsnames.ora is very common to oracle users."}}