Oracle listener not running and won't start

Question

I am getting the following errors while from the lsnrctl status command:

C:\Users\pna105>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 

It was working fine before restart but now it is not working and I also can't access my Oracle homepage.

My tnsnames.ora is:

  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)   )   ) 

My listener.ora is: (Here were error due to brackets misplaced adding few spaces resolved the problem TNS-12518)

   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 

Following is the output of lsnrctl start command

C:\Users\pna105>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 

Following is the Last entry needed from log file.

 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 

Tried to resolve TNS-12518 and listener started but still not able to access Oracle home page

output of lnsrctl stat

C:\Users\pna105>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... 

T he command completed successfully

Answer 1

I had the same problem. Solution in my case: run CMD as ADMINISTRATOR. then type and execute: "lsnrctl start" wait about 2 minutes then should work. (in my case was only 50 seconds, but just to be on the safe side)