title: How do I setup Oracle ODBC drivers on RHEL 6/Linux
body: <p>I need to setup Oracle ODBC drivers on RHEL 6 to connect to an Oracle data source residing on a remote Windows machine. </p>
  
  <p>I have taken the following steps:<br>
  [1] Installed oracle-instanceclient-basic<br>
  [2] Set environment variables: ORACLE_HOME and LD path<br>
  [3] Created /etc/oracle/TNSnames.ora and configured but it did not set it correctly</p>
  
  <p>Initially, I got the error, <code>"Connect failed because target or object does not exist"</code></p>
  
  <p>Then, I set: <code>ORACLE_SID = DB_NAME</code> in the TNSnames.ora file.</p>
  
  <p>But, that did not fix the issue, I got a new error message now: <code>"TNS: net service name is incorrectly specified"</code></p>