Oracle listener cannot start and gives error return code1.
Environment:
OS : Windows Server 2008, DB : Oracle 11g, SAP ECC 6 .0 EHP6
Investigations :
Look into logs
C:\Program Files\sapinst_instdir\ERPEhP6\AS-ABAP\ORA\CENTRAL\lsnrctl.log
LSNRCTL for 64-bit Windows: Version 11.2.0.3.0 - Production on 24-JUN-2013 18:33:56
Copyright (c) 1991, 2011, 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=SIDHOST.local)(PORT=1521)))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
64-bit Windows Error: 61: Unknown error
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=GDI.WORLD)))
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
Resolution:
Look into the usage of port . i.e Other application may using the same port. To know port usage at windows command prompt execute
netstat -ano | findstr 1521 > This command gives if the port is free or its been using by any other application. If output is ESTABLISHED it means this port is used by some application and command gives process id using this port.
C:\Users\Administrator>netstat -ano | findstr 1521
tasklist /SVC /FI "PID eq 9682" > This command will give you application name holding this process id. Alternatively you can see in windows task manager.
C:\Users\Administrator>tasklist /SVC /FI "PID eq 9682"
Image Name PID Services
========================= ======== ====================
java.exe 9892 N/A
Now we have two options left. Either change port for listener or change other applications port which is using this port 1521.
In my scenario I have gone for changing port for oracle listener in file listener.ora at path C:\app\Administrator\product\11.2.0\dbhome_1\NETWORK\ADMIN\listener.ora. Changed default port 1521 to free port 1527.
Start oracle listener from services.msc or command prompt. This solved my issue and installation moved further.
Keywords:
TNS-12541: TNS:no listener, TNS-12560: TNS:protocol adapter error , TNS-00511: No listener