Today I faced Below error when I was trying to start listener in my Windows machine :-
I checked the log in G:\app\NewAdmin\cfgtoollogs\netca also I got below message :-
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 :-
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 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