Home » RDBMS Server » Networking and Gateways » Cannot start Listener (Linux, Oracle11g)
Cannot start Listener [message #429786] Thu, 05 November 2009 15:44 Go to next message
mlee733
Messages: 9
Registered: November 2009
Junior Member
----------------I am unable to start my listener, any help is appreciated (Please see below).

----------------When I enter "lsnrctl start" I receive the following (according to netstat, port 1521 is not in use):
TNSLSNR for Linux: Version 11.1.0.6.0 - Production
System parameter file is /oracle/db11g/network/admin/listener.ora
Log messages written to /oracle/diag/tnslsnr/owcvm/listener/alert/log.xml
Error listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=owcvm.localdomain)(PORT=1521)))
TNS-12542: TNS:address already in use
TNS-12560: TNS:protocol adapter error
TNS-00512: Address already in use
Linux Error: 98: Address already in use

Listener failed to start. See the error message(s) above...

-----------------When I enter "lsnrctl stop" or "lsnrctl stat" I receive the following:
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=owcvm.localdomain)(PORT=1521)))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
Linux Error: 111: Connection refused


----------------My listener.ora file:
# listener.ora Network Configuration File: /oracle/db11g/network/admin/listener.ora
# Generated by Oracle configuration tools.

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = owcvm.localdomain)(PORT = 1521))
)
)

----------------My tnsnames.ora file:
# tnsnames.ora Network Configuration File: /oracle/db11g/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.

OWCDEV =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = owcvm)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = owcdev)
)
)

----------------My hosts file:
# Do not remove the following line, or various programs
# that require network functionality will fail.
127.0.0.1 localhost.localdomain localhost
192.168.14.128 owcvm.localdomain owcvm

Report message to a moderator

Re: Cannot start Listener [message #429788 is a reply to message #429786] Thu, 05 November 2009 16:08 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Your listener.ora is not complete.
First hit in google took me here
http://www.mike-devlin.com/oracle/listener_ora.htm

You have to define the listener and associate the SID with it.

Report message to a moderator

Re: Cannot start Listener [message #429993 is a reply to message #429788] Fri, 06 November 2009 13:56 Go to previous messageGo to next message
mlee733
Messages: 9
Registered: November 2009
Junior Member
Hi,

I believe the extra information in your link is optional, and that the most basic form of the listener.ora would be:
ht
tp://ww
w.orafaq.co
m/wiki/Listener.ora

Please advise, or let me know if I misunderstand.

Thanks.

Report message to a moderator

Re: Cannot start Listener [message #429994 is a reply to message #429993] Fri, 06 November 2009 14:01 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
listener.ora does not need to exist for V10+

The Oracle listener will start & run just fine without any listener.ora file existing

Report message to a moderator

Re: Cannot start Listener [message #429999 is a reply to message #429994] Fri, 06 November 2009 14:34 Go to previous messageGo to next message
mlee733
Messages: 9
Registered: November 2009
Junior Member
When I rename my listener.ora file I get the following error for the "lsnrctl start" command:

TNSLSNR for Linux: Version 11.1.0.6.0 - Production
Log messages written to /oracle/diag/tnslsnr/owcvm/listener/alert/log.xml
Error listening on: (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
TNS-12542: TNS:address already in use
TNS-12560: TNS:protocol adapter error
TNS-00512: Address already in use
Linux Error: 98: Address already in use

Listener failed to start. See the error message(s) above...

-The HOST= entry is blank - is that OK?
-Also, it reports that Address 1521 is already in use, but that port does not show up in a netstat.
-"lsnrctl stop" and "lsnrctl stat" still output the following:

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
Linux Error: 111: Connection refused

How can the port be in use if there is nothing listening on it?

Report message to a moderator

Re: Cannot start Listener [message #430002 is a reply to message #429999] Fri, 06 November 2009 14:54 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
CUT lines below & PASTE into terminal window

date
env | sort
cat /etc/hosts
netstat -a | grep 152
lsnrctl status
lsnrctl service
lsnrctl stop
lsnrctl service
lsnrctl status
date


CUT commands & results from above & PASTE back here

Report message to a moderator

Re: Cannot start Listener [message #430004 is a reply to message #430002] Fri, 06 November 2009 15:08 Go to previous messageGo to next message
mlee733
Messages: 9
Registered: November 2009
Junior Member
[oracle@owcvm ~]$ date
Fri Nov 6 13:04:30 PST 2009
[oracle@owcvm ~]$ env | sort
COLORTERM=gnome-terminal
CVS_RSH=ssh
DBUS_SESSION_BUS_ADDRESS=unix:abstract=/tmp/dbus-jCMpDk6JRE,guid=575850939c983807c1e493004af47a71
DESKTOP_SESSION=default
DESKTOP_STARTUP_ID=
DISPLAY=:0.0
G_BROKEN_FILENAMES=1
GDMSESSION=default
GDM_XSERVER_LOCATION=local
GNOME_DESKTOP_SESSION_ID=Default
GNOME_KEYRING_SOCKET=/tmp/keyring-ql0CbO/socket
GTK_RC_FILES=/etc/gtk/gtkrc:/home/oracle/.gtkrc-1.2-gnome2
HISTSIZE=1000
HOME=/home/oracle
HOSTNAME=owcvm.localdomain
INPUTRC=/etc/inputrc
LANG=en_US.UTF-8
LD_LIBRARY_PATH=/oracle/db11g/lib
LESSOPEN=|/usr/bin/lesspipe.sh %s
LOGNAME=oracle
LS_COLORS=no=00:fi=00:di=00;34:ln=00;36:pi=40;33:so=00;35:bd=40;33;01:cd=40;33;01:or=01;05;37;41:mi=01;05;37;41:ex=00;32:*.cmd=00;32: *.exe=00;32:*.com=00;32:*.btm=00;32:*.bat=00;32:*.sh=00;32:*.csh=00;32:*.tar=00;31:*.tgz=00;31:*.arj=00;31:*.taz=00;31:*.lzh=00;31:*. zip=00;31:*.z=00;31:*.Z=00;31:*.gz=00;31:*.bz2=00;31:*.bz=00;31:*.tz=00;31:*.rpm=00;31:*.cpio=00;31:*.jpg=00;35:*.gif=00;35:*.bmp=00; 35:*.xbm=00;35:*.xpm=00;35:*.png=00;35:*.tif=00;35:
MAIL=/var/spool/mail/oracle
ORACLE_BASE=/oracle
ORACLE_HOME=/oracle/db11g
ORACLE_SID=owcdev
ORAENV_ASK=NO
PATH=/usr/kerberos/bin:/usr/local/bin:/usr/bin:/bin:/usr/X11R6/bin:/home/oracle/bin:/oracle/db11g/bin
PWD=/home/oracle
SESSION_MANAGER=local/owcvm.localdomain:/tmp/.ICE-unix/4088
SHELL=/bin/bash
SHLVL=2
SSH_AGENT_PID=4137
SSH_ASKPASS=/usr/libexec/openssh/gnome-ssh-askpass
SSH_AUTH_SOCK=/tmp/ssh-PBZPWe4088/agent.4088
TERM=xterm
USERNAME=oracle
USER=oracle
_=/usr/bin/env
WINDOWID=52428881
XAUTHORITY=/tmp/.gdmTW212U
XMODIFIERS=@im=none
[oracle@owcvm ~]$ cat /etc/hosts
# Do not remove the following line, or various programs
# that require network functionality will fail.
127.0.0.1 localhost.localdomain localhost
192.168.14.128 owcvm.localdomain owcvm
192.168.234.2553 oldip.localdomain oldip
[oracle@owcvm ~]$ netstat -a | grep 152
[oracle@owcvm ~]$ lsnrctl status

LSNRCTL for Linux: Version 11.1.0.6.0 - Production on 06-NOV-2009 13:04:32

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

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
Linux Error: 111: Connection refused
[oracle@owcvm ~]$ lsnrctl service

LSNRCTL for Linux: Version 11.1.0.6.0 - Production on 06-NOV-2009 13:04:53

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

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
Linux Error: 111: Connection refused
[oracle@owcvm ~]$ lsnrctl stop

LSNRCTL for Linux: Version 11.1.0.6.0 - Production on 06-NOV-2009 13:05:15

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

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
Linux Error: 111: Connection refused
[oracle@owcvm ~]$ lsnrctl service

LSNRCTL for Linux: Version 11.1.0.6.0 - Production on 06-NOV-2009 13:05:36

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

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
Linux Error: 111: Connection refused
[oracle@owcvm ~]$ lsnrctl status

LSNRCTL for Linux: Version 11.1.0.6.0 - Production on 06-NOV-2009 13:05:58

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

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
Linux Error: 111: Connection refused
[oracle@owcvm ~]$ date
Fri Nov 6 13:07:22 PST 2009

Report message to a moderator

Re: Cannot start Listener [message #430007 is a reply to message #430004] Fri, 06 November 2009 15:31 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
You did not CUT & PASTE all at once but that is OK.

I need more details. Please do below & post results back here

uname -a
cat /etc/hostname

I'll be away for about 90 minutes.

Report message to a moderator

Re: Cannot start Listener [message #430010 is a reply to message #430007] Fri, 06 November 2009 15:38 Go to previous messageGo to next message
mlee733
Messages: 9
Registered: November 2009
Junior Member
Before (and now) the final commmand does not execute with all the rest. It is written to the line, but I have to press enter to get it to execute.

[oracle@owcvm ~]$ uname -a
Linux owcvm.localdomain 2.6.18-128.1.14.0.1.el5 #1 SMP Tue Jun 16 19:30:35 EDT 2009 i686 i686 i386 GNU/Linux
[oracle@owcvm ~]$ cat /etc/hostname
cat: /etc/hostname: No such file or directory

Report message to a moderator

Re: Cannot start Listener [message #430015 is a reply to message #430010] Fri, 06 November 2009 17:48 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
post results from following:

ping owcvm.localdomain
ping owcvm

Report message to a moderator

Re: Cannot start Listener [message #430016 is a reply to message #429786] Fri, 06 November 2009 18:04 Go to previous messageGo to next message
mlee733
Messages: 9
Registered: November 2009
Junior Member
Both ping commands did not get any response - I cancelled each after 2 minutes.

Report message to a moderator

Re: Cannot start Listener [message #430018 is a reply to message #430016] Fri, 06 November 2009 19:15 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>Both ping commands did not get any response
This indicates basic OS networking misconfiguration.
ping must work before listener has a chance of working.
Obtain assistance from local sysadmin/network wizard

Is any type of OS virtualization involved?

[Updated on: Fri, 06 November 2009 19:16]

Report message to a moderator

Re: Cannot start Listener [message #430260 is a reply to message #429786] Mon, 09 November 2009 16:22 Go to previous messageGo to next message
mlee733
Messages: 9
Registered: November 2009
Junior Member
Yes, I am running this as a an image through VMWare Server 2.0

I used ifconfig to check the virtual ip address, and changed the host file to reflect the result. Now, I am able to ping both owcvm and owcvm.localdomain and start the listener - but I receive a troubling message: The listener supports no services.
Is this a problem, or possibly just how this is particular listener is configured to run?

[oracle@owcvm ~]$ lsnrctl start

LSNRCTL for Linux: Version 11.1.0.6.0 - Production on 09-NOV-2009 14:04:22

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

Starting /oracle/db11g/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 11.1.0.6.0 - Production
System parameter file is /oracle/db11g/network/admin/listener.ora
Log messages written to /oracle/diag/tnslsnr/owcvm/listener/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=owcvm.localdomain)(PORT=1521)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=owcvm.localdomain)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 11.1.0.6.0 - Production
Start Date 09-NOV-2009 14:04:27
Uptime 0 days 0 hr. 0 min. 5 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /oracle/db11g/network/admin/listener.ora
Listener Log File /oracle/diag/tnslsnr/owcvm/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=owcvm.localdomain)(PORT=1521)))
The listener supports no services
The command completed successfully

Report message to a moderator

Re: Cannot start Listener [message #430679 is a reply to message #430018] Wed, 11 November 2009 12:59 Go to previous messageGo to next message
mlee733
Messages: 9
Registered: November 2009
Junior Member
Yes, I am running this as a an image through VMWare Server 2.0

I used ifconfig to check the virtual ip address, and changed the host file to reflect the result. Now, I am able to ping both owcvm and owcvm.localdomain and start the listener - but I receive a troubling message: The listener supports no services.
Is this a problem, or possibly just how this is particular listener is configured to run?

[oracle@owcvm ~]$ lsnrctl start

LSNRCTL for Linux: Version 11.1.0.6.0 - Production on 09-NOV-2009 14:04:22

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

Starting /oracle/db11g/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 11.1.0.6.0 - Production
System parameter file is /oracle/db11g/network/admin/listener.ora
Log messages written to /oracle/diag/tnslsnr/owcvm/listener/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=owcvm.localdomain)(PORT=1521)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=owcvm.localdomain)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 11.1.0.6.0 - Production
Start Date 09-NOV-2009 14:04:27
Uptime 0 days 0 hr. 0 min. 5 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /oracle/db11g/network/admin/listener.ora
Listener Log File /oracle/diag/tnslsnr/owcvm/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=owcvm.localdomain)(PORT=1521)))
The listener supports no services
The command completed successfully

Report message to a moderator

Re: Cannot start Listener [message #430681 is a reply to message #430679] Wed, 11 November 2009 13:13 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
Errors come with Codes & Messages.
When nothing is broken, no "fix" is needed.

post results from following


lsnrctl service

Report message to a moderator

Re: Cannot start Listener [message #430685 is a reply to message #430681] Wed, 11 November 2009 13:59 Go to previous messageGo to next message
mlee733
Messages: 9
Registered: November 2009
Junior Member
lsnrctl service results are at the bottom, but the reason I think there may still be an issue is that I receive the following when I try to start up the Weblogic server (is this something you can help with?):

----------------start Weblogic log snippet-----------------
WARNING: The domain runtime MBean server has not been found after trying for 600 seconds.
<Nov 11, 2009 10:16:01 AM PST> <Notice> <WebLogicServer> <BEA-000365> <Server state changed to STANDBY>
<Nov 11, 2009 10:16:01 AM PST> <Notice> <WebLogicServer> <BEA-000365> <Server state changed to STARTING>
<Nov 11, 2009 10:32:53 AM PST> <Warning> <J2EE> <BEA-160195> <The application version lifecycle event listener

oracle.security.jps.wls.listeners.JpsAppVersionLifecycleListener is ignored because the application em is not

versioned.>
<Nov 11, 2009 11:48:43 AM PST> <Error> <ServletContext-/NonJ2EEManagement> <BEA-000000> <Failed to register

registerMBean.
javax.naming.NameNotFoundException: Unable to resolve 'oracleDmsNotifier'. Resolved ''; remaining name

'oracleDmsNotifier'
at weblogic.jndi.internal.BasicNamingNode.newNameNotFoundException(BasicNamingNode.java:1139)
at weblogic.jndi.internal.BasicNamingNode.lookupHere(BasicNamingNode.java:252)
at weblogic.jndi.internal.ServerNamingNode.lookupHere(ServerNamingNode.java:182)
at weblogic.jndi.internal.BasicNamingNode.lookup(BasicNamingNode.java:206)
at weblogic.jndi.internal.WLEventContextImpl.lookup(WLEventContextImpl.java:254)
Truncated. see log file for complete stacktrace
>
<Nov 11, 2009 11:49:47 AM PST> <Warning> <JNDI> <BEA-050006> <An attempt was made to look up versioned object

"oracleDmsOpmnInfoCenter" from an external client or another application. This can potentially cause in-flight work

of the application version not being tracked properly and thus being retired prematurely.>

------------end Weblogic log snippet ------------------------





[oracle@owcvm ~]$ lsnrctl service

LSNRCTL for Linux: Version 11.1.0.6.0 - Production on 11-NOV-2009 11:56:10

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=owcvm.localdomain)(PORT=1521)))
Services Summary...
Service "owcdev" has 1 instance(s).
Instance "owcdev", status READY, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:69 refused:0 state:ready
LOCAL SERVER
Service "owcdevXDB" has 1 instance(s).
Instance "owcdev", status READY, has 1 handler(s) for this service...
Handler(s):
"D000" established:0 refused:0 current:0 max:1022 state:ready
DISPATCHER <machine: owcvm.localdomain, pid: 5534>
(ADDRESS=(PROTOCOL=tcp)(HOST=owcvm.localdomain)(PORT=46228))
Service "owcdev_XPT" has 1 instance(s).
Instance "owcdev", status READY, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:69 refused:0 state:ready
LOCAL SERVER
The command completed successfully

Report message to a moderator

Re: Cannot start Listener [message #430687 is a reply to message #430685] Wed, 11 November 2009 14:16 Go to previous message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
NOT an Oracle issue

http://kr.forums.oracle.com/forums/thread.jspa?messageID=3209960

Report message to a moderator

Previous Topic: TNS Names
Next Topic: Changing Gateways in Oracle RAC
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Nov 21 11:49:20 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.