Oracle Error starting listener: "Failed to start service, error 0"

Today I faced Below error when I was trying to start listener in my Windows machine :-

C:\Users\NewAdmin>lsnrctl start

LSNRCTL for 64-bit Windows: Version 11.2.0.1.0 - Production on 01-SEP-2014 21:40:10

Copyright (c) 1991, 2010, Oracle.  All rights reserved.

Starting tnslsnr: please wait...

Failed to start service, error 0.

I checked the log in G:\app\NewAdmin\cfgtoollogs\netca also I got below message :-

[AWT-EventQueue-0] [ 2014-09-01 20:37:08.704 IST ] [WindowsSystem.dorunRemoteExecCmd:2078]  _WS_: remote command executed, but didn't return zero.

[AWT-EventQueue-0] [ 2014-09-01 20:37:08.704 IST ] [GETCRSHOMEUtil.getCRS_HOME:147]  cmdTool.execute() failed.

[AWT-EventQueue-0] [ 2014-09-01 20:37:08.706 IST ] [HAUtils.isHASConfigured:364]  Ignoring exception in isHASConfigured: PRCT-1400 : getcrshome execution failed. Detailed error:

localnode

[AWT-EventQueue-0] [ 2014-09-01 20:37:08.707 IST ] [HAUtils.isHASConfigured:365]  oracle.cluster.deployment.ClusterwareInfo.getConfiguredCRSHome(ClusterwareInfo.java:425)

oracle.sysman.assistants.util.hasi.HAUtils.getCRSHome(HAUtils.java:592)

oracle.sysman.assistants.util.hasi.HAUtils.getHASHome(HAUtils.java:652)

oracle.sysman.assistants.util.hasi.HAUtils.isHASConfigured(HAUtils.java:360)

oracle.net.ca.ConfigureListener.getLsnrsRegWithHA(ConfigureListener.java:557)

oracle.net.ca.ConfigureListener.getListeners(ConfigureListener.java:774)

oracle.net.ca.NetCA.prepareNextPage(NetCA.java:1220)

oracle.net.ca.NetCA.wizardValidatePage(NetCA.java:1036)

oracle.ewt.wizard.WizardPage.processWizardValidateEvent(Unknown Source)

oracle.ewt.wizard.WizardPage.validatePage(Unknown Source)

oracle.ewt.wizard.BaseWizard.validateSelectedPage(Unknown Source)

oracle.ewt.wizard.BaseWizard.doFinish(Unknown Source)

oracle.ewt.wizard.BaseWizard$Action.actionPerformed(Unknown Source)

oracle.ewt.button.PushButton.processActionEvent(Unknown Source)

oracle.ewt.button.PushButton.processEventImpl(Unknown Source)

oracle.ewt.lwAWT.LWComponent.redispatchEvent(Unknown Source)

oracle.ewt.lwAWT.LWComponent.processEvent(Unknown Source)

oracle.ewt.button.PushButton.activate(Unknown Source)

oracle.ewt.lwAWT.AbstractButton.processMouseReleased(Unknown Source)

oracle.ewt.lwAWT.AbstractButton.processMouseEvent(Unknown Source)

java.awt.Component.processEvent(Component.java:5282)

java.awt.Container.processEvent(Container.java:1966)

oracle.ewt.lwAWT.LWComponent.processEventImpl(Unknown Source)

oracle.ewt.button.PushButton.processEventImpl(Unknown Source)

oracle.ewt.lwAWT.LWComponent.redispatchEvent(Unknown Source)

oracle.ewt.lwAWT.LWComponent.processEvent(Unknown Source)

java.awt.Component.dispatchEventImpl(Component.java:3984)

java.awt.Container.dispatchEventImpl(Container.java:2024)

java.awt.Component.dispatchEvent(Component.java:3819)

java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4212)

java.awt.LightweightDispatcher.processMouseEvent(Container.java:3892)

java.awt.LightweightDispatcher.dispatchEvent(Container.java:3822)

java.awt.Container.dispatchEventImpl(Container.java:2010)

java.awt.Window.dispatchEventImpl(Window.java:1791)

java.awt.Component.dispatchEvent(Component.java:3819)

java.awt.EventQueue.dispatchEvent(EventQueue.java:463)

java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.java:242)

java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:163)

java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:153)

java.awt.Dialog$1.run(Dialog.java:535)

java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:209)

java.awt.EventQueue.dispatchEvent(EventQueue.java:461)

java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.java:242)

java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:163)

java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:157)

java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:149)

java.awt.EventDispatchThread.run(EventDispatchThread.java:110)

[AWT-EventQueue-0] [ 2014-09-01 20:37:08.708 IST ] [ConfigureListener.getLsnrsRegWithHA:568]  HAS is installed but *NOT* Configured !!

[AWT-EventQueue-0] [ 2014-09-01 20:37:08.708 IST ] [ConfigureListener.getLsnrsRegWithCRS:650]  NOT a Cluster !!

[AWT-EventQueue-0] [ 2014-09-01 20:37:08.709 IST ] [ConfigureListener.getScanLsnrNames:693]  NOT a Cluster !!

[AWT-EventQueue-0] [ 2014-09-01 20:37:08.710 IST ] [ConfigureListener.getListeners:811]  Returning SI lsnrs = LISTENER

By checking the above its seems port was free but still it's not able to read the listener related files.

LSNRCTL status was giving me below message :-

C:\Users\NewAdmin>lsnrctl status

LSNRCTL for 64-bit Windows: Version 11.2.0.1.0 - Production on 01-SEP-2014 21:40:00

Copyright (c) 1991, 2010, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=amit-PC)(PORT=9001)))

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

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

It seems LSNRCTL command was not able to read the listener related files from already set environment variables(ORACLE_HOME and PATH).

I checked the environment variables , In User level settings ORACLE_HOME and PATH variables was properly defined but in System level Settings ORACLE_HOME was set to another location. I changed it as its in USER level setting and then tried to start the listener and it started successfully. PFB output :-

C:\Users\NewAdmin>lsnrctl status

LSNRCTL for 64-bit Windows: Version 11.2.0.1.0 - Production on 01-SEP-2014 21:51:22

Copyright (c) 1991, 2010, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=amit-PC)(PORT=9001)))

STATUS of the LISTENER

------------------------

Alias                     LISTENER

Version                   TNSLSNR for 64-bit Windows: Version 11.2.0.1.0 - Production

Start Date                01-SEP-2014 21:51:09

Uptime                    0 days 0 hr. 0 min. 15 sec

Trace Level               off

Security                  ON: Local OS Authentication

SNMP                      OFF

Listener Parameter File   G:\app\NewAdmin\product\11.1.0\db_1\network\admin\listener.ora

Listener Log File         g:\app\newadmin\diag\tnslsnr\amit-PC\listener\alert\log.xml

Listening Endpoints Summary...

  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=amit-PC)(PORT=9001)))

Services Summary...

Service "CLRExtProc" has 1 instance(s).

  Instance "CLRExtProc", status UNKNOWN, has 2 handler(s) for this service...

The command completed successfully

I hope this article helped you.

Regards,

Amit Rath