title: Able to connect to Databse using TNS alias but NOT using service name
body: <p>I am to trying connect to a database using TNS, and I am able to connect successfully using an alias:</p>
  
  <pre><code>sqlplus user/password@UHKGLXXX
  </code></pre>
  
  <p>However, when I connect to same database using the service name, I get the below error: </p>
  
  <pre><code>sqlplus user/password@pl0676o.hk.bbc:2006/UHKGLXXX.hk.bbc
  </code></pre>
  
  <blockquote>
    <p>ORA-12514: TNS:listener does not currently know of service requested in connect descriptor</p>
  </blockquote>
  
  <p>Can someone please help me out with this. </p>
  
  <p>Below is the TNSNAMES entry : </p>
  
  <pre><code>UHKGLXXX =
    (DESCRIPTION =
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = TCP)(HOST = pl0676o.hk.bbc)(PORT = 2006))
      )
      (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = UHKGLXXX.hk.bbc)
      )
    )
  
  LISTENER_UHKGLXXX = (ADDRESS = (PROTOCOL = TCP)(HOST = pl0676o.hk.bbc)(PORT = 2006))
  </code></pre>