title: Oracle listener not running and won't start
body: <p>I am getting the following errors while from the <code>lsnrctl status</code> command:</p>
  
  <pre><code>C:\Users\pna105&gt;lsnrctl stat
  
   LSNRCTL for 64-bit Windows: Version 11.2.0.1.0 - Production on 08-OCT-2014 17:53
   :55
  
   Copyright (c) 1991, 2010, Oracle.  All rights reserved.
  
   Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
   TNS-12541: TNS:no listener
   TNS-12560: TNS:protocol adapter error
    TNS-00511: No listener
     64-bit Windows Error: 2: No such file or directory
   Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521)))
   TNS-12541: TNS:no listener
   TNS-12560: TNS:protocol adapter error
   TNS-00511: No listener
   64-bit Windows Error: 61: Unknown error
  </code></pre>
  
  <p>It was working fine before restart but now it is not working and I also can't access my Oracle homepage.</p>
  
  <p>My <code>tnsnames.ora</code> is:</p>
  
  <pre><code>  ORACLE = 
    (DESCRIPTION =  
      (ADDRESS_LIST =  
        (ADDRESS = (PROTOCOL = TCP)(HOST = Localhost)(PORT = 1521))  
      )  
      (CONNECT_DATA =  
        (SERVICE_NAME = ORACLE)  
      )  
     )
  
     LISTENER_ORACLE =
    (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>My <code>listener.ora</code> is: (Here were error due to brackets misplaced adding few spaces resolved the problem TNS-12518)</p>
  
  <pre><code>   SID_LIST_LISTENER =
     (SID_LIST =
     (SID_DESC =
      (SID_NAME = ORACLE)
      (ORACLE_HOME = C:\app\PNA105\product\11.2.0\dbhome_1)
    )  
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = C:\app\PNA105\product\11.2.0\dbhome_1)
      (PROGRAM = extproc)
     )
     (SID_DESC =
    (SID_NAME = CLRExtProc)
    (ORACLE_HOME = C:\app\PNA105\product\11.2.0\dbhome_1)
    (PROGRAM = extproc)
    (ENVS = "EXTPROC_DLLS=ONLY:C:\app\PNA105\product\11.2.0\dbhome_1\bin\oraclr11.dll")
    )
    )
  
    LISTENER =
   (DESCRIPTION_LIST =
    (DESCRIPTION =
    (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
    (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
    )
    )
  
    ADR_BASE_LISTENER = C:\app\PNA105
  </code></pre>
  
  <p>Following is the output of <code>lsnrctl start</code> command</p>
  
  <pre><code>C:\Users\pna105&gt;lsnrctl start
  
  LSNRCTL for 64-bit Windows: Version 11.2.0.1.0 - Production on 08-OCT-2014 18:26
  :22
  
   Copyright (c) 1991, 2010, Oracle.  All rights reserved.
  
   Starting tnslsnr: please wait...
  
    TNS-12560: TNS:protocol adapter error
     TNS-00530: Protocol adapter error
  </code></pre>
  
  <p>Following is the Last entry needed from log file.</p>
  
  <pre><code> Started with pid=14784
   Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1521ipc)))
   Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521)))
   Listener completed notification to CRS on start
  
   09-OCT-2014 15:46:01 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=__jdbc__)(USER=INL007306$))
  (SERVICE_NAME=oracle)) * (ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=57389)) * 
  establish * oracle * 12518
  TNS-12518: TNS:listener could not hand off client connection
  TNS-12560: TNS:protocol adapter error
   TNS-00530: Protocol adapter error
   64-bit Windows Error: 203: Unknown error
   Dynamic address is already listened on (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp) 
   (HOST=127.0.0.1)(PORT=1521)))
   09-OCT-2014 15:46:06 * service_register * oracle * 0
   Thu Oct 09 15:46:11 2014
   09-OCT-2014 15:46:11 * service_update * oracle * 0
   09-OCT-2014 15:46:12 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=__jdbc__)(USER=INL007306$))
   (SERVICE_NAME=oracle)) * (ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=57393)) * 
    establish * oracle * 0
   09-OCT-2014 15:46:12 * service_update * oracle * 0
   09-OCT-2014 15:46:13 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=__jdbc__)(USER=INL007306$))
   (SERVICE_NAME=oracle)) * (ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=57394)) * 
   establish * oracle * 0
  </code></pre>
  
  <p>Tried to resolve TNS-12518 and listener started but still not able to access 
  Oracle home page</p>
  
  <p>output of lnsrctl stat</p>
  
  <pre><code>C:\Users\pna105&gt;lsnrctl stat
  
  LSNRCTL for 64-bit Windows: Version 11.2.0.1.0 - Production on 09-OCT-2014 17:16
  :56
  
   Copyright (c) 1991, 2010, Oracle.  All rights reserved.
  
   Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
   STATUS of the LISTENER
    ------------------------
   Alias                     LISTENER
   Version                   TNSLSNR for 64-bit Windows: Version 11.2.0.1.0 - Produ
   ction
   Start Date                09-OCT-2014 15:45:58
   Uptime                    0 days 1 hr. 30 min. 58 sec
   Trace Level               off
   Security                  ON: Local OS Authentication
   SNMP                      OFF
   Listener Parameter File   C:\app\PNA105\product\11.2.0\dbhome_1\network\admin\li
   stener.ora
   Listener Log File         c:\app\pna105\diag\tnslsnr\INL007306\listener\alert\lo
   g.xml
   Listening Endpoints Summary...
   (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1521ipc)))
   (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521)))
    Services Summary...
    Service "CLRExtProc" has 1 instance(s).
    Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
    Service "ORACLE" has 2 instance(s).
    Instance "ORACLE", status UNKNOWN, has 1 handler(s) for this service...
    Instance "oracle", status READY, has 1 handler(s) for this service...
    Service "PLSExtProc" has 1 instance(s).
    Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
    Service "oracleXDB" has 1 instance(s).
    Instance "oracle", status READY, has 1 handler(s) for this service...
  </code></pre>
  
  <p>T     he command completed successfully</p>