<div dir="ltr"><div><div>Hi again<br><br>I have moved a little bit forward and I have edited the file tnsnames.ora located under C:\OraClient11g\product\11.2.0\client_1\NETWORK\ADMIN:<br><br><div style="margin-left:40px">name_of_my_db =<br> (DESCRIPTION = <br> (ADDRESS_LIST =<br> (ADDRESS = (PROTOCOL = TCP)(HOST = *********)(PORT = 1568))<br> )<br> (CONNECT_DATA =<br> (SERVICE_NAME = name_of_my_db)<br> )<br>)<br></div><br></div>Will Qgis read this file or does it require its own copy of it? If yes, where should it be located? If no, how does it know where tnsnames.ora is stored? Should there be an entry in the registry?<br><br></div><div>By the way, my sqlnet.ora file (also located in C:\OraClient11g\product\11.2.0\client_1\NETWORK\ADMIN) looks like this:<br><br><div style="margin-left:40px"># sqlnet.ora Network Configuration File: C:\oracle\product\10.2.0\NETWORK\ADMIN\sqlnet.ora<br># Generated by Oracle configuration tools.<br><br>################<br># Filename......: sqlnet.ora<br># Name..........: $Id: sqlnet.ora,v 1.3 2004/11/22 13:47:17 oracle Exp $<br># Date..........: $Source: /data/repository/cvsroot/ORACLE/env_sqlnet/indus/sqlnet.ora,v $<br>#<br>################<br><br>SQLNET.AUTHENTICATION_SERVICES= (NTS)<br><br>NAMES.DIRECTORY_PATH= (LDAP,TNSNAMES,ONAMES)<br><br>SQLNET.CRYPTO_SEED = "************************"<br><br>NAMES.PREFERRED_SERVERS =<br> (ADDRESS_LIST =<br> (ADDRESS = (COMMUNITY = ************************)(PROTOCOL = TCP)(Host = ************************)(Port = 1568))<br> (ADDRESS = (COMMUNITY = ************************)(PROTOCOL = TCP)(Host = ************************)(Port = 1568))<br> (ADDRESS = (COMMUNITY = ************************)(PROTOCOL = TCP)(Host = ************************)(Port = 1568))<br> (ADDRESS = (COMMUNITY = ************************)(PROTOCOL = TCP)(Host = ************************)(Port = 1568))<br> (ADDRESS = (COMMUNITY = ************************)(PROTOCOL = TCP)(Host = ************************)(Port = 1529))<br> (ADDRESS = (COMMUNITY = ************************)(PROTOCOL = TCP)(Host = ************************)(Port = 1527))<br> (ADDRESS = (COMMUNITY = ************************)(PROTOCOL = TCP)(Host = ************************)(Port = 1528))<br> )<br><br>NAMES.DEFAULT_DOMAIN = ************************<br><br>SQLNET.EXPIRE_TIME = 0<br></div><br></div><div><br></div>Thanks a lot in advance!<br><br>Stéphane<br><div><div><br></div></div></div><div class="gmail_extra"><br clear="all"><div><div dir="ltr">--<br>"Le mot progrès n'aura aucun sens tant qu'il y aura des enfants malheureux" -- Albert Einstein<br><br>"Si les contacts avec les étrangers lui étaient permis, [le citoyen
ordinaire] découvrirait que ce sont des créatures semblables à lui-même
et que la plus grande partie de ce qu'on lui a raconté d'eux est fausse.
Le monde fermé, scellé, dans lequel il vit, serait brisé, et la
crainte, la haine, la certitude de son bon droit, desquelles dépend sa
morale, pourraient disparaître" -- George Orwell ("1984")<br><br>Photos de voyages, photos de montagne: <a href="http://www.henriod.info/" target="_blank">http://www.henriod.info</a><span dir="ltr"><span dir="ltr" title="Appeler ce numéro de téléphone en/au(x) Tadjikistan avec Skype : +992934624662"><span> </span></span> <br></span></div></div>
<br><div class="gmail_quote">2014-09-30 7:47 GMT+02:00 Stéphane Henriod <span dir="ltr"><<a href="mailto:s@henriod.info" target="_blank">s@henriod.info</a>></span>:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr"><div>Hi all<br><br></div>I want to connect Qgis 2.4 to an Oracle DB (with SDE) but I always get connection errors.<br><p>I have tried many different options from within the window <em>Create a new Oracle Connection</em> but I always get an error message (<em>ORA-12514: TNS:listener does not currently know of service requested in connect descriptor</em>
or similar messages). I know however that the DB is working and
listening. I know the correct host, the correct port and I have valid
username / password.</p>
<p>The IT support here gave me 2 (independent) pieces of advice but I'm not sure how to implement them with Qgis:</p>
<ul><li>"Does your client (Qgis) know about the correct <em>tns_admin</em> directory?"</li><li>"Make sure that LDAP is listed first: NAMES.DIRECTORY_PATH = (LDAP, TNSNAMES,ONAMES)"</li></ul>
<p>Anyone has an idea?</p>
<p>Thanks a lot in advance!</p>Stéphane<br><br>PS: this question has also been posted here: <a href="http://gis.stackexchange.com/questions/115534/qgis-how-setup-ldap-as-default-to-resolve-a-connection-to-oracle" target="_blank">http://gis.stackexchange.com/questions/115534/qgis-how-setup-ldap-as-default-to-resolve-a-connection-to-oracle</a> but unsuccessfully so far<br><br><div><div dir="ltr">--<br>"Le mot progrès n'aura aucun sens tant qu'il y aura des enfants malheureux" -- Albert Einstein<br><br>"Si les contacts avec les étrangers lui étaient permis, [le citoyen
ordinaire] découvrirait que ce sont des créatures semblables à lui-même
et que la plus grande partie de ce qu'on lui a raconté d'eux est fausse.
Le monde fermé, scellé, dans lequel il vit, serait brisé, et la
crainte, la haine, la certitude de son bon droit, desquelles dépend sa
morale, pourraient disparaître" -- George Orwell ("1984")<br><br>Photos de voyages, photos de montagne: <a href="http://www.henriod.info/" target="_blank">http://www.henriod.info</a><span dir="ltr"><span dir="ltr" title="Appeler ce numéro de téléphone en/au(x) Tadjikistan avec Skype : +992934624662"><span> </span></span> <br></span></div></div>
</div>
</blockquote></div><br></div>