{"action":"created","issue":{"url":"https://api.github.com/repos/serge-rider/dbeaver/issues/355","repository_url":"https://api.github.com/repos/serge-rider/dbeaver","labels_url":"https://api.github.com/repos/serge-rider/dbeaver/issues/355/labels{/name}","comments_url":"https://api.github.com/repos/serge-rider/dbeaver/issues/355/comments","events_url":"https://api.github.com/repos/serge-rider/dbeaver/issues/355/events","html_url":"https://github.com/serge-rider/dbeaver/issues/355","id":147356479,"number":355,"title":"TNSs not working propertly","user":{"login":"marco-sanjuan","id":4165141,"avatar_url":"https://avatars.githubusercontent.com/u/4165141?v=3","gravatar_id":"","url":"https://api.github.com/users/marco-sanjuan","html_url":"https://github.com/marco-sanjuan","followers_url":"https://api.github.com/users/marco-sanjuan/followers","following_url":"https://api.github.com/users/marco-sanjuan/following{/other_user}","gists_url":"https://api.github.com/users/marco-sanjuan/gists{/gist_id}","starred_url":"https://api.github.com/users/marco-sanjuan/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/marco-sanjuan/subscriptions","organizations_url":"https://api.github.com/users/marco-sanjuan/orgs","repos_url":"https://api.github.com/users/marco-sanjuan/repos","events_url":"https://api.github.com/users/marco-sanjuan/events{/privacy}","received_events_url":"https://api.github.com/users/marco-sanjuan/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/serge-rider/dbeaver/labels/bug","name":"bug","color":"fc2929"},{"url":"https://api.github.com/repos/serge-rider/dbeaver/labels/can't%20reproduce","name":"can't reproduce","color":"bfdadc"}],"state":"open","locked":false,"assignee":{"login":"serge-rider","id":6398845,"avatar_url":"https://avatars.githubusercontent.com/u/6398845?v=3","gravatar_id":"","url":"https://api.github.com/users/serge-rider","html_url":"https://github.com/serge-rider","followers_url":"https://api.github.com/users/serge-rider/followers","following_url":"https://api.github.com/users/serge-rider/following{/other_user}","gists_url":"https://api.github.com/users/serge-rider/gists{/gist_id}","starred_url":"https://api.github.com/users/serge-rider/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/serge-rider/subscriptions","organizations_url":"https://api.github.com/users/serge-rider/orgs","repos_url":"https://api.github.com/users/serge-rider/repos","events_url":"https://api.github.com/users/serge-rider/events{/privacy}","received_events_url":"https://api.github.com/users/serge-rider/received_events","type":"User","site_admin":false},"milestone":null,"comments":13,"created_at":"2016-04-11T08:40:59Z","updated_at":"2016-05-13T21:34:41Z","closed_at":null,"body":"Hi\r\n\r\nWe noted that oracle connections don't get host properly from TNSNAMES.ORA.\r\n\r\nMy case is:\r\n1. I select oracle client\r\n2. On TNS combo box, I select one (in this case PRE-ES)\r\n3. I insert user and pass\r\n4. On Test Connection, I noted that app is using TNS name as host, instead extract hostname from tsnnames.ora file.\r\n\r\nThe TNSNAMES.ORA contains;\r\n\r\n```\r\nPRE-ES=\r\n\t(DESCRIPTION =\r\n\t\t(ADDRESS_LIST =\r\n\t\t\t(ADDRESS = (PROTOCOL = TCP)(HOST = bd1.pre.es.sys.company)(PORT = 1521))\r\n\t\t)\r\n\t\t(CONNECT_DATA =\r\n\t\t\t(SERVER = DEDICATED)\r\n\t\t\t(SERVICE_NAME = devel)\r\n\t\t)\r\n\t)\r\n```\r\n\r\nAnd test connection tries to connect to *PRE-ES* instead of *bd1.pre.es.sys.company*:\r\n![image](https://cloud.githubusercontent.com/assets/4165141/14421395/adf70d30-ffd1-11e5-98cf-0f244aaf6ed6.png)\r\n\r\nThe error is:\r\n![image](https://cloud.githubusercontent.com/assets/4165141/14422033/eceeb922-ffd4-11e5-9710-b9cd6dbccb70.png)\r\n\r\nWe have to use Basic conection type to properly connect by setting host, port and database manually.\r\n\r\nThanks!\r\n"},"comment":{"url":"https://api.github.com/repos/serge-rider/dbeaver/issues/comments/219165024","html_url":"https://github.com/serge-rider/dbeaver/issues/355#issuecomment-219165024","issue_url":"https://api.github.com/repos/serge-rider/dbeaver/issues/355","id":219165024,"user":{"login":"serge-rider","id":6398845,"avatar_url":"https://avatars.githubusercontent.com/u/6398845?v=3","gravatar_id":"","url":"https://api.github.com/users/serge-rider","html_url":"https://github.com/serge-rider","followers_url":"https://api.github.com/users/serge-rider/followers","following_url":"https://api.github.com/users/serge-rider/following{/other_user}","gists_url":"https://api.github.com/users/serge-rider/gists{/gist_id}","starred_url":"https://api.github.com/users/serge-rider/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/serge-rider/subscriptions","organizations_url":"https://api.github.com/users/serge-rider/orgs","repos_url":"https://api.github.com/users/serge-rider/repos","events_url":"https://api.github.com/users/serge-rider/events{/privacy}","received_events_url":"https://api.github.com/users/serge-rider/received_events","type":"User","site_admin":false},"created_at":"2016-05-13T21:34:41Z","updated_at":"2016-05-13T21:34:41Z","body":"Umm.\r\nLooks like DBeaver can't find correct TNSNAMES.ora file. This explains all problems from the very beginning.\r\nI see that Oracle client home was set to `d:\\oracle`. Where is your TNSNAMES.ora file located?"}}