title: Oracle SQLPlus ORA-01017 invalid credentials when specifying schema
body: <p>On an Oracle11g database, this works:</p>
  
  <pre><code>SQL&gt; connect USER/pass
  Connected.
  </code></pre>
  
  <p>However, this doesn't:</p>
  
  <pre><code>SQL&gt; connect USER/pass@db
  ERROR:
  ORA-01017: invalid username/password; logon denied
  </code></pre>
  
  <p>I have executed:</p>
  
  <pre><code>SQL&gt; grant connect to USER;
  Grant succeeded.
  </code></pre>
  
  <p>What am I missing?</p>
  
  <p>tnsnames.ora:</p>
  
  <pre><code>DB =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = a.dom.b.com)(PORT = 1521))
      (CONNECT_DATA =
        (SERVER = DEDICATED)
        (SERVICE_NAME = db)
      )
    )
  </code></pre>
  
  <p><strong>EDIT:</strong></p>
  
  <pre><code>:&gt; sqlplus USER/pass
  SQL*Plus: Release 11.1.0.7.0 - Production on Mon Mar 11 15
  Copyright (c) 1982, 2008, Oracle.  All rights reserved.
  Connected to:
  Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
  </code></pre>
  
  <p>The other two don't.</p>
  
  <pre><code>:&gt; sqlplus USER/pass@db
  SQL*Plus: Release 11.1.0.7.0 - Production on Mon Mar 11 15:04:44 2013
  Copyright (c) 1982, 2008, Oracle.  All rights reserved.
  
  ERROR:
  ORA-01017: invalid username/password; logon denied
  </code></pre>
  
  <p>This one produces identifier error:</p>
  
  <pre><code>:&gt; sqlplus USER/pass@db//localhost:1521
  SQL*Plus: Release 11.1.0.7.0 - Production on Mon Mar 11 15:10:38 2013
  Copyright (c) 1982, 2008, Oracle.  All rights reserved.
  
  ERROR:
  ORA-12154: TNS:could not resolve the connect identifier specified
  </code></pre>
  
  <p>I have verified tnsnames.ora entry and I am spelling service correctly.</p>
  
  <p><strong>EDIT2:</strong></p>
  
  <pre><code>:&gt; lsnrctl status
  
  LSNRCTL for 64-bit Windows: Version 11.1.0.7.0 - Production on 11-MAR-2013 15:14:19
  
  Copyright (c) 1991, 2008, Oracle.  All rights reserved.
  
  Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=a.dom.b.com)(PORT=1521
  STATUS of the LISTENER
  ------------------------
  Alias                     LISTENER
  Version                   TNSLSNR for 64-bit Windows: Version 11.1.0.7.0 - Production
  Start Date                01-MAR-2013 16:15:25
  Uptime                    9 days 21 hr. 59 min. 8 sec
  Trace Level               off
  Security                  ON: Local OS Authentication
  SNMP                      OFF
  Listener Parameter File   d:\oracle\product\11.1.0\db_1\network\admin\listener.ora
  Listener Log File         d:\oracle\diag\tnslsnr\TMDEV100\listener\alert\log.xml
  Listening Endpoints Summary...
    (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=a.dom.b.com)(PORT=1521)))
  Services Summary...
  Service "db" has 1 instance(s).
    Instance "db", status READY, has 1 handler(s) for this service...
  ...
  ...
  The command completed successfully
  </code></pre>