title: Oracle TNS: net service name is incorrecly specified
body: <p>I'm trying to access an Oracle database on an old server we inherited for a client.</p>
  <p>I'm confident I have the Oracle database and listener started and working, but when trying to access <code>sqlplus</code> or the <code>exp</code> commands, I'm getting the following error:</p>
  <blockquote>
  <p>ORA-12162: TNS:net service name is incorrectly specified</p>
  </blockquote>
  <p>I have edited the <code>tnsnames.ora</code> file to change the host to <code>127.0.0.1</code> rather than an external URL and I am able to successfully <code>tnsping</code> my connection, but am not getting much further.</p>