Oracle listener not running and won t start

Question

I am getting the following errors while from the lsnrctl status command   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   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 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   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 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      T     he command completed successfully

User · Answer

I solved it by updating listener ora file inside oracle directory oraclexe app oracle product 11 2 0 server network ADMIN   Why did it happen to me was because I changed my system name but inside listener ora there was old name for HOST   This might be one of the reasons    for those who still face such issue might think of this possibility as well

User · Answer

I encountered the same problem and reason being  Mine is a personal windows PC  And i have modified the computer name and the same did not reflect in listener ora  Updating ORACLE HOME network ADMIN listener ora with updated host name fixed the issue

User · Answer

In my case somehow windows listener service had stopped working so I was not able to connect to Qracle using SQL Developer  However I was able to connect through sqlplus   Below solution worked for me   First  ensure that your listener service is running     C  Documents and Settings ME gt lsnrctl status    If the listener service is not running  re-start the listener service using the Windows task manager or use the DOS command line utility to re-start the Windows service with the net start command   C  Documents and Settings ME gt net start OracleOraDb10g home1TNSListener    Try to start the listener service using lsnrctl from DOS prompt    lsnrctl start

User · Answer

Check that ORACLE HOME environment variable is pointing to the correct oracle home  In my case it was changed by another software installation

User · Answer

I encounter similar problem when installing oracle 11gR2 on Windows 2012 server  the problem is solved when I run cmd exe as Admistrator privilege and run  lsnrctl start LISTENER

User · Answer

In my Windows case the listener would not start  and  lsnrctl start  would hang forever   The solution was to kill all processes of extproc   I suspect it had something funny to do with my vpn

User · Answer

I had the same problem on 11 201 on Windows  After  additional install 11 203 64bit server and client in new folders  PATH environment variable was changed right after install  Error in listener appeared after listener service restart  In my case there was a night time and number of windows updates  so windows server restart helped us  Also I cleaned listener log file according to http   pavandba com tag tns-12560-tns-protocol-adapter-error   it was surprisingly big

User · Answer

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

User · Answer

Problem  The listener service is stopped in services msc   Cause  User password was changed   Solution   Open services msc  Right-click the specific listener service  Click Properties  Click the Logon tab  Change the password  Click OK  Start the service

User · Answer

In my case the listener service would not start because it was set to listen to a VPN connection as well to other serveral interfaces   Once I connected to the VPN  it just started   However   Imre s trick with  lsnrctl start  put me to the right track

User · Answer

Same happened to me after I changed computer name  To fix that  just locate listener ora file and replace old computer name with the new one

User · Answer

In my case  I tried to start the listener via console    gt  lsnrctl star   This command printed the following error   TNS-12560  TNS protocol adapter error TNS-00583  Valid node checking  unable to parse configuration parameters   So  I performed the following actions    Check if Oracle listener ora or sqlnet ora file contains special characters Check if Oracle listener ora or sqlnet ora  file are in wrong format or syntax Check if Oracle listener ora or sqlnet ora file have some left justified parenthesis which are not accepted by oracle parser    Have a look at these files and check the proper syntax  If possible remove rename sqlnet ora and try to restart the listener  Or remove rename both listener ora or sqlnet ora file and recreate it properly  These will defenitely resolve the issue

User · Answer

I managed to resolve the issue that caused the configuration to fail on a docker container running the Hortonworks HDP 2 6 Sandbox   If the initial configuration fails the listener will be running and will have to be killed first   ps -aux   grep tnslsnr kill  process id identified above    Then next step is then to fix the shared memory issue which makes the configuration process fail   Oracle XE requires 1 Gb of shared memory and fails otherwise  I didn t try 512 mb  according to https   blogs oracle com oraclewebcentersuite implement-oracle-database-xe-as-docker-containers   vi  etc fstab   change add the line to   tmpfs     dev shm     tmpfs   defaults size 1024m 0 0   Then reload the configuration by   mount -a   Keep in mind that the next time you restart the docker container you might have to do  mount -a

User · Answer

1 Check the Environment variables  must be set for System and not for user    ORACLE HOME   C  oraclexe app oracle product 11 2 0 server ORACLE SID   XE   2 Check if you have the right definition in listener ora  XE      DESCRIPTION LIST        DESCRIPTION          ADDRESS    PROTOCOL   IPC  KEY   EXTPROC1          ADDRESS    PROTOCOL   TCP  HOST   localhost  PORT   1521              DEFAULT SERVICE LISTENER    XE    3 Restart the service  Services   OracleServiceXE   After that you may see a new service called OracleXETNSListenerXE  There is already an old OracleXETNSListener   I started both and then I was able to make a successful connection   Edit   If everything is running but you still can t connect  check if there is no error  ORA-12557  TNS protocol adapter not loadable   To correct the error go back to the Environment variables and this time edit the one called  Path  Be sure that C  oraclexe app oracle product 11 2 0 server bin is somewhere at the beginning  definitely before any other path pointing to a different version of the Oracle DB

[oracle] Oracle listener not running and won't start

Examples related to oracle

Examples related to oracle11g

Examples related to tns