title: Why can I log in with SQL Developer but not with SQL*Plus?
body: <p>I'm trying to connect to from SQL*Plus and get error ORA-12154, but I can connect from SQL Developer without any error. I can <code>tnsping</code> and also <code>lsnrctl</code> is okay and the listener is up and running.</p>
  
  <p>I can connect as <code>sys</code> like <code>sqlplus sys as sysdba</code> which works fine; but with another user I do <code>sqlplus username</code> and when I type the password it gives me:</p>
  
  <pre><code>ORA-12154: TNS:could not resolve the connect identifier specified
  </code></pre>