title: ora 12541: no listener oracle 12c
body: <p>I have installed Oracle 12c server and client on the same laptop.</p>
  
  <p>Previously it was running, but now I started getting this error <code>ORA-12541: no listener</code>.</p>
  
  <p>My listener service is up and running, and I can connect through SQL Developer, but I get that error when I try to connect through SQL*Plus using <code>system/Lab12345@lab</code>.</p>
  
  <pre><code>C:\Users\hunai&gt;lsnrctl status
  
  LSNRCTL for 64-bit Windows: Version 12.1.0.1.0 - Production on 15-JUN-2017 12:57:07
  Copyright (c) 1991, 2013, Oracle.  All rights reserved.
  Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
  
  STATUS of the LISTENER
  ------------------------
  &gt;Alias                     LISTENER
  Version                   TNSLSNR for 64-bit Windows: Version 12.1.0.1.0 - Production
  Start Date                15-JUN-2017 12:38:45
  Uptime                    0 days 0 hr. 18 min. 23 sec
  Trace Level               off
  Security                  ON: Local OS Authentication
  SNMP                      OFF
  Listener Parameter File   C:\app\hunai\product\12.1.0\dbhome\network\admin\listener.ora
  Listener Log File         C:\app\hunai\diag\tnslsnr\DESKTOP-0RL2PU2\listener\alert\log.xml
  Listening Endpoints Summary...
    (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1521ipc)))
    (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521)))
    (DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=DESKTOP-0RL2PU2)(PORT=5500))(Security=(my_wallet_directory=C:\APP\HUNAI\admin\lab\xdb_wallet))(Presentation=HTTP)(Session=RAW))
  Services Summary...
  Service "CLRExtProc" has 1 instance(s).
    Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
  Service "lab" has 1 instance(s).
    Instance "lab", status READY, has 1 handler(s) for this service...
  Service "labXDB" has 1 instance(s).
    Instance "lab", status READY, has 1 handler(s) for this service...
  The command completed successfully
  </code></pre>
  
  <p>This is my <code>tnsnames.ora</code> file:</p>
  
  <pre><code># tnsnames.ora Network Configuration File: C:\app\hunai\product\12.1.0\dbhome\network\admin\tnsnames.ora
  # Generated by Oracle configuration tools.
  
  LAB =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
      (CONNECT_DATA =
        (SERVER = DEDICATED)
        (SERVICE_NAME = lab)
      )
    )
  
  LISTENER_LAB =
    (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
  
  
  ORACLR_CONNECTION_DATA =
    (DESCRIPTION =
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
      )
      (CONNECT_DATA =
        (SID = CLRExtProc)
        (PRESENTATION = RO)
      )
    )
  </code></pre>
  
  <p>Kindly tell me how to resolve this issue.</p>