title: ERROR 704 & 12154 while connecting sqlloader to server
body: <p>I have a oracle database based on a server, and I want to import the data in the tables on the server.
  I am trying to use sqlloadr(sqlldr) for inserting all data in the oracle database, which is on localhost and there is no problem in this case, but the problem occurs while I try to connect a web-server(not localhost).</p>
  
  <p>The command that I've used in localhost case:</p>
  
  <pre><code>sqlldr &lt;usrname&gt;/&lt;password&gt; control=table.ctl log=table.log ERRORS=25000
  </code></pre>
  
  <p>and following is concerning to web-server</p>
  
  <pre><code>sqlldr &lt;usrname&gt;/&lt;password&gt;@LABSERVER control=table.ctl log=table.log ERRORS=25000
  </code></pre>
  
  <p>where I created a tnsnames.ora as following:</p>
  
  <pre><code>LABSERVER =
    (DESCRIPTION =
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = TCP)(Host = &lt;hostaddress&gt;)(Port = 1521))
      )
      (CONNECT_DATA =
        (SERVICE_NAME = &lt;servicename&gt;)
      )
    )
  </code></pre>
  
  <p>but I got this error:</p>
  
  <pre><code>SQL*Loader-704: Internal error: ulconnect:OCIServerAttache [0]
  
  ORA-12154: TNS:could not resolve the connect identifier specified
  </code></pre>
  
  <p>Any idea will be appreciated</p>