title: SQL*Loader-704 and ORA-12154
body: <pre><code>sqlldr "xxxx/xxxx@YYYYYXXXX" control=/home/local/INTERNAL/xxxxx/Presc_SQLLDR_File/Presc_SQLLDR.ctl log=/home/local/INTERNAL/xxxxx/Presc_SQLLDR_File/Presc_log.log data=home/achand/Presc_SQLLDR_File/Presc_SQLLDR.ctl
  </code></pre>
  
  <p>Whenever i'm trying to execute sqlldr I'm getting below error</p>
  
  <pre><code>SQL*Loader-704: Internal error: ulconnect: OCIServerAttach [0]
  ORA-12154: TNS:could not resolve the connect identifier specified
  </code></pre>
  
  <p>I tried <code>tnsping YYYYYXXXX</code> </p>
  
  <p>I got below error</p>
  
  <blockquote>
    <p>TNS-03505: Failed to resolve name</p>
  </blockquote>
  
  <p>tnsnames.ora contain</p>
  
  <pre><code>DDCPPSD.WORLD =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = XXXXXYYY)(PORT = 1521))
      (CONNECT_DATA =
        (SERVER = DEDICATED)
        (SID = YYYYYXXXX)
      )
    )
  </code></pre>