title: Status : Failure -Test failed: Listener refused the connection with error: ORA-12514, TNS:listener does not currently know of service requested
body: <p>I am getting this error while connecting to oracle 12c from SQL Developer,</p>
  
  <pre><code>Status : Failure -Test failed: Listener refused the connection with the following error:
  ORA-12514, TNS:listener does not currently know of service requested in connect descriptor
  </code></pre>
  
  <p>My <strong>tnsnames.ora</strong> file contents is:</p>
  
  <blockquote>
    <p>ORACLR_CONNECTION_DATA =
      (DESCRIPTION =
        (ADDRESS_LIST =
          (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
        )
        (CONNECT_DATA =
          (SID = CLRExtProc)
          (PRESENTATION = RO)
        )   )</p>
    
    <p>ORCL1 =   (DESCRIPTION =
        (ADDRESS_LIST =
          (ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.1.10)(PORT = 1521))
        )
        (CONNECT_DATA =
          (SERVICE_NAME = orcl.abc.com)
        )   )</p>
    
    <p>ORCL =   (DESCRIPTION =
        (ADDRESS = (PROTOCOL = TCP)(HOST = INT.abc.com)(PORT = 1521))
        (CONNECT_DATA =
          (SERVER = DEDICATED)
          (SERVICE_NAME = orcl.abc.com)
        )   )</p>
  </blockquote>
  
  <p>My <strong>listener.ora</strong> file contents is:</p>
  
  <blockquote>
    <p>SID_LIST_LISTENER =
      (SID_LIST =
        (SID_DESC =
          (SID_NAME = CLRExtProc)
          (ORACLE_HOME = C:\app\oracle\product\12.1.0\dbhome_1)
          (PROGRAM = extproc)
          (ENVS = "EXTPROC_DLLS=ONLY:C:\app\oracle\product\12.1.0\dbhome_1\bin\oraclr12.dll")
        )
      )</p>
    
    <p>LISTENER =   (DESCRIPTION_LIST =
        (DESCRIPTION =
          (ADDRESS = (PROTOCOL = TCP)(HOST = INT.abc.com)(PORT = 1521))
          (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
        )   )</p>
  </blockquote>
  
  <p>I am using <strong>Service Name</strong> as <code>'orcl1'</code> and <strong>Host Name</strong> as <code>'10.10.1.10'</code> in sql developer "Add Connection" window and getting the above error.</p>
  
  <p>I am able to connect to sqlplus using cmd with proper username and password.
   Any help will be appreciated.</p>