| Unable to start listener [message #496682] |
Tue, 01 March 2011 22:38  |
jxh461
Messages: 185
Registered: March 2005
|
Senior Member |
|
|
Greetings to all.
I am having a problem getting my listner to start. I need help and it is a learning opportunity.
[oracle@jhlinux ~]$ lsnrctl start
LSNRCTL for Linux: Version 11.1.0.6.0 - Production on 01-MAR-2011 23:26:30
Copyright (c) 1991, 2007, Oracle. All rights reserved.
Starting /u01/app/oracle/product/11.1.0/db_1/bin/tnslsnr: please wait...
TNSLSNR for Linux: Version 11.1.0.6.0 - Production
System parameter file is /u01/app/oracle/product/11.1.0/db_1/network/admin/listener.ora
Log messages written to /u01/app/oracle/diag/tnslsnr/jhlinux/listener/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=jhlinux.home.com)(PORT=1521)))
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=jhlinux.home.com)(PORT=1521)))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
Linux Error: 111: Connection refused
[oracle@jhlinux ~]$
Contents of listener.ora
[oracle@jhlinux admin]$ cat listener.ora
# listener.ora Network Configuration File: /u01/app/oracle/product/11.1.0/db_1/network/admin/listener.ora
# Generated by Oracle configuration tools.
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = jhlinux.home.com)(PORT = 1521))
)
)
[oracle@jhlinux admin]$
Please let me know what other information you need me to post. I am thinking that oracle is the victime of networking setup but I am not sure why. Thanks to all in advance.
|
|
|
|
|
|
| Re: Unable to start listener [message #496776 is a reply to message #496690] |
Wed, 02 March 2011 07:02  |
jxh461
Messages: 185
Registered: March 2005
|
Senior Member |
|
|
[oracle@jhlinux ~]$ [b]id[/b]
uid=501(oracle) gid=501(oinstall) groups=501(oinstall),502(dba)
[oracle@jhlinux ~]$ [b]env | sort[/b]
COLORTERM=gnome-terminal
CVS_RSH=ssh
DBUS_SESSION_BUS_ADDRESS=unix:abstract=/tmp/dbus-REtUdnNsVD,guid=8cc16d4d0ee299ffcd8ccc7dd55ab400
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-KEmc6i/socket
GTK_RC_FILES=/etc/gtk/gtkrc:/home/oracle/.gtkrc-1.2-gnome2
HISTSIZE=1000
HOME=/home/oracle
HOSTNAME=jhlinux
INPUTRC=/etc/inputrc
LANG=en_US.UTF-8
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
OLDPWD=/u01/app/oracle/product/11.1.0/db_1/network/admin
ORACLE_BASE=/u01/app/oracle
ORACLE_HOME=/u01/app/oracle/product/11.1.0/db_1
ORACLE_SID=orcl
PATH=/usr/kerberos/bin:/usr/local/bin:/usr/bin:/bin:/usr/X11R6/bin:/usr/sbin:/u01/app/oracle/product/11.1.0/db_1/bin:/home/oracle/bin
PWD=/home/oracle
SESSION_MANAGER=local/jhlinux:/tmp/.ICE-unix/2687
SHELL=/bin/bash
SHLVL=2
SSH_AGENT_PID=2746
SSH_ASKPASS=/usr/libexec/openssh/gnome-ssh-askpass
SSH_AUTH_SOCK=/tmp/ssh-LzBgYd2687/agent.2687
TERM=xterm
USERNAME=oracle
USER=oracle
_=/usr/bin/env
WINDOWID=48234577
XAUTHORITY=/tmp/.gdmUBGJRV
XMODIFIERS=@im=none
[oracle@jhlinux ~]$ [b]uname -a[/b]
Linux jhlinux 2.6.18-8.el5 #1 SMP Fri Jan 26 14:15:14 EST 2007 x86_64 x86_64 x86_64 GNU/Linux
[oracle@jhlinux ~]$ [b]cat /etc/hosts[/b]
# Do not remove the following line, or various programs
# that require network functionality will fail.
# ::1 localhost6.localdomain6
192.168.1.1 jhlinux.home.com jhlinux
127.0.0.1 localhost.localdomain localhost
197.0.0.1 localhost.domain localhost
|
|
|
|
|
|
| Re: Unable to start listener [message #496889 is a reply to message #496807] |
Wed, 02 March 2011 21:13 |
jxh461
Messages: 185
Registered: March 2005
|
Senior Member |
|
|
[oracle@jhlinux ~]$ /sbin/ifconfig
eth0 Link encap:Ethernet HWaddr 00:00:6C:91:4A:91
inet addr:192.168.1.207 Bcast:192.168.1.255 Mask:255.255.255.0
inet6 addr: fe80::200:6cff:fe91:4a91/64 Scope:Link
UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1
RX packets:8402 errors:0 dropped:0 overruns:0 frame:0
TX packets:4797 errors:0 dropped:0 overruns:0 carrier:0
collisions:0 txqueuelen:1000
RX bytes:1825963 (1.7 MiB) TX bytes:630507 (615.7 KiB)
Interrupt:209
lo Link encap:Local Loopback
inet addr:127.0.0.1 Mask:255.0.0.0
inet6 addr: ::1/128 Scope:Host
UP LOOPBACK RUNNING MTU:16436 Metric:1
RX packets:17622 errors:0 dropped:0 overruns:0 frame:0
TX packets:17622 errors:0 dropped:0 overruns:0 carrier:0
collisions:0 txqueuelen:0
RX bytes:4141744 (3.9 MiB) TX bytes:4141744 (3.9 MiB)
|
|
|
|
|
|
| Re: Unable to start listener [message #497072 is a reply to message #496890] |
Thu, 03 March 2011 20:49 |
jxh461
Messages: 185
Registered: March 2005
|
Senior Member |
|
|
After rebooting the value of the inet addr has changed.
[oracle@jhlinux ~]$ /sbin/ifconfig
eth0 Link encap:Ethernet HWaddr 00:00:6C:CA:B9:8C
inet addr:192.168.1.213 Bcast:192.168.1.255 Mask:255.255.255.0
inet6 addr: fe80::200:6cff:feca:b98c/64 Scope:Link
UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1
RX packets:5 errors:0 dropped:0 overruns:0 frame:0
TX packets:39 errors:0 dropped:0 overruns:0 carrier:0
collisions:0 txqueuelen:1000
RX bytes:1890 (1.8 KiB) TX bytes:8584 (8.3 KiB)
Interrupt:209
lo Link encap:Local Loopback
inet addr:127.0.0.1 Mask:255.0.0.0
inet6 addr: ::1/128 Scope:Host
UP LOOPBACK RUNNING MTU:16436 Metric:1
RX packets:1147 errors:0 dropped:0 overruns:0 frame:0
TX packets:1147 errors:0 dropped:0 overruns:0 carrier:0
collisions:0 txqueuelen:0
RX bytes:3313300 (3.1 MiB) TX bytes:3313300 (3.1 MiB)
[oracle@jhlinux ~]$ cat /etc/hosts
# Do not remove the following line, or various programs
# that require network functionality will fail.
# ::1 localhost6.localdomain6
192.168.1.207 jhlinux.home.com jhlinux
127.0.0.1 localhost.localdomain localhost
[oracle@jhlinux ~]$
[Updated on: Thu, 03 March 2011 21:06] Report message to a moderator |
|
|
|
|
|
|
|
| Re: Unable to start listener [message #497352 is a reply to message #497080] |
Fri, 04 March 2011 21:59 |
jxh461
Messages: 185
Registered: March 2005
|
Senior Member |
|
|
This is the only way I am able to login.
[oracle@jhlinux ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.1.0.6.0 - Production on Fri Mar 4 23:00:20 2011
Copyright (c) 1982, 2007, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL>
|
|
|
|
|
|
| Re: Unable to start listener [message #497952 is a reply to message #497354] |
Mon, 07 March 2011 22:09 |
jxh461
Messages: 185
Registered: March 2005
|
Senior Member |
|
|
[oracle@jhlinux ~]$ lsnrctl start
LSNRCTL for Linux: Version 11.1.0.6.0 - Production on 07-MAR-2011 23:10:56
Copyright (c) 1991, 2007, Oracle. All rights reserved.
Starting /u01/app/oracle/product/11.1.0/db_1/bin/tnslsnr: please wait...
TNSLSNR for Linux: Version 11.1.0.6.0 - Production
Log messages written to /u01/app/oracle/diag/tnslsnr/jhlinux/listener/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=jhlinux.home.com)(PORT=1521)))
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
TNS-12532: TNS:invalid argument
TNS-12560: TNS:protocol adapter error
TNS-00502: Invalid argument
Linux Error: 113: No route to host
[oracle@jhlinux ~]$
|
|
|
|
|
|
| Re: Unable to start listener [message #497956 is a reply to message #497953] |
Mon, 07 March 2011 22:40 |
jxh461
Messages: 185
Registered: March 2005
|
Senior Member |
|
|
[oracle@jhlinux ~]$ cat /etc/hosts
# Do not remove the following line, or various programs
# that require network functionality will fail.
# ::1 localhost6.localdomain6
#192.168.1.215 jhlinux.home.com jhlinux
127.0.0.1 localhost.localdomain localhost
[oracle@jhlinux ~]$ lsnrctl start
LSNRCTL for Linux: Version 11.1.0.6.0 - Production on 07-MAR-2011 23:35:47
Copyright (c) 1991, 2007, Oracle. All rights reserved.
Starting /u01/app/oracle/product/11.1.0/db_1/bin/tnslsnr: please wait...
TNSLSNR for Linux: Version 11.1.0.6.0 - Production
Log messages written to /u01/app/oracle/diag/tnslsnr/jhlinux/listener/alert/log.xml
Error listening on: (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
TNS-12545: Connect failed because target host or object does not exist
TNS-12560: TNS:protocol adapter error
TNS-00515: Connect failed because target host or object does not exist
Listener failed to start. See the error message(s) above...
[oracle@jhlinux ~]$
In log file mentioned above
[oracle@jhlinux ~]$ tail -20 /u01/app/oracle/diag/tnslsnr/jhlinux/listener/alert/log.xml
type='UNKNOWN' level='16' host_id='jhlinux'
host_addr='UNKNOWN'>
<txt>Started with pid=2861
</txt>
</msg>
<msg time='2011-03-07T23:35:47.951-05:00' org_id='oracle' comp_id='tnslsnr'
type='UNKNOWN' level='16' host_id='jhlinux'
host_addr='UNKNOWN'>
<txt>Error listening on: (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
</txt>
</msg>
<msg time='2011-03-07T23:35:47.972-05:00' org_id='oracle' comp_id='tnslsnr'
type='UNKNOWN' level='16' host_id='jhlinux'
host_addr='UNKNOWN'>
<txt>TNS-12545: Connect failed because target host or object does not exist
TNS-12560: TNS:protocol adapter error
TNS-00515: Connect failed because target host or object does not exist
</txt>
</msg>
|
|
|
|
|
|
|
|
|
|
| Re: Unable to start listener [message #497965 is a reply to message #497961] |
Mon, 07 March 2011 23:31 |
jxh461
Messages: 185
Registered: March 2005
|
Senior Member |
|
|
[root@jhlinux ~]# /sbin/service iptables stop
Flushing firewall rules: [ OK ]
Setting chains to policy ACCEPT: filter [ OK ]
Unloading iptables modules: [ OK ]
[root@jhlinux ~]# /sbin/service iptables start
[root@jhlinux ~]# ping localhost
PING localhost.localdomain (127.0.0.1) 56(84) bytes of data.
64 bytes from localhost.localdomain (127.0.0.1): icmp_seq=1 ttl=64 time=0.020 ms
64 bytes from localhost.localdomain (127.0.0.1): icmp_seq=2 ttl=64 time=0.019 ms
64 bytes from localhost.localdomain (127.0.0.1): icmp_seq=3 ttl=64 time=0.018 ms
64 bytes from localhost.localdomain (127.0.0.1): icmp_seq=4 ttl=64 time=0.019 ms
--- localhost.localdomain ping statistics ---
4 packets transmitted, 4 received, 0% packet loss, time 2999ms
rtt min/avg/max/mdev = 0.018/0.019/0.020/0.000 ms
[oracle@jhlinux ~]$ lsnrctl start
LSNRCTL for Linux: Version 11.1.0.6.0 - Production on 08-MAR-2011 01:06:30
Copyright (c) 1991, 2007, Oracle. All rights reserved.
Starting /u01/app/oracle/product/11.1.0/db_1/bin/tnslsnr: please wait...
TNSLSNR for Linux: Version 11.1.0.6.0 - Production
Log messages written to /u01/app/oracle/diag/tnslsnr/jhlinux/listener/alert/log.xml
Error listening on: (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
TNS-12545: Connect failed because target host or object does not exist
TNS-12560: TNS:protocol adapter error
TNS-00515: Connect failed because target host or object does not exist
Listener failed to start. See the error message(s) above...
[Updated on: Tue, 08 March 2011 00:04] Report message to a moderator |
|
|
|
|
|
| Re: Unable to start listener [message #498142 is a reply to message #498139] |
Tue, 08 March 2011 22:28 |
jxh461
Messages: 185
Registered: March 2005
|
Senior Member |
|
|
During installation I got the following error at the end. Could this be the reason I am failing to start the listener ?
Jan 29, 2011 1:31:19 AM oracle.sysman.emcp.EMConfig perform
SEVERE: Failed to allocate port(s) in the specified range(s) for the following process(es): JMS [5540-5559],RMI [5520-5539],Database Control [5500-5519],EM Agent [3938] | [1830-1849]
Refer to the log file at /u01/app/oracle/cfgtoollogs/dbca/orcl/emConfig.log for more details.
Jan 29, 2011 1:31:19 AM oracle.sysman.emcp.EMConfig perform
CONFIG: Stack Trace:
oracle.sysman.emcp.exception.EMConfigException: Failed to allocate port(s) in the specified range(s) for the following process(es): JMS [5540-5559],RMI [5520-5539],Database Control [5500-5519],EM Agent [3938] | [1830-1849]
at oracle.sysman.emcp.EMDBPreConfig.checkPorts(EMDBPreConfig.java:2480)
at oracle.sysman.emcp.EMDBPreConfig.performConfiguration(EMDBPreConfig.java:743)
at oracle.sysman.emcp.EMDBPreConfig.invoke(EMDBPreConfig.java:250)
at oracle.sysman.emcp.EMDBPreConfig.invoke(EMDBPreConfig.java:177)
at oracle.sysman.emcp.EMConfig.perform(EMConfig.java:220)
at oracle.sysman.assistants.util.em.EMConfiguration.run(EMConfiguration.java:460)
at java.lang.Thread.run(Thread.java:595)
[Updated on: Tue, 08 March 2011 22:30] Report message to a moderator |
|
|
|
|
|
| Re: Unable to start listener [message #498700 is a reply to message #498144] |
Thu, 10 March 2011 19:55 |
jxh461
Messages: 185
Registered: March 2005
|
Senior Member |
|
|
I unplugged my maching from the router (netgear) and connected it directly.
Here is what I am seeing.
[oracle@jhlinux admin]$ /sbin/ifconfig
eth0 Link encap:Ethernet HWaddr 00:00:6C:1A:E6:79
inet addr:71.199.128.153 Bcast:255.255.255.255 Mask:255.255.255.0
inet6 addr: fe80::200:6cff:fe1a:e679/64 Scope:Link
UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1
RX packets:10201 errors:0 dropped:0 overruns:0 frame:0
TX packets:201 errors:0 dropped:0 overruns:0 carrier:0
collisions:0 txqueuelen:1000
RX bytes:739029 (721.7 KiB) TX bytes:26336 (25.7 KiB)
Interrupt:209
lo Link encap:Local Loopback
inet addr:127.0.0.1 Mask:255.0.0.0
inet6 addr: ::1/128 Scope:Host
UP LOOPBACK RUNNING MTU:16436 Metric:1
RX packets:1264 errors:0 dropped:0 overruns:0 frame:0
TX packets:1264 errors:0 dropped:0 overruns:0 carrier:0
collisions:0 txqueuelen:0
RX bytes:3412122 (3.2 MiB) TX bytes:3412122 (3.2 MiB)
then I started the listener and got the following
[oracle@jhlinux admin]$ lsnrctl start
LSNRCTL for Linux: Version 11.1.0.6.0 - Production on 10-MAR-2011 20:47:52
Copyright (c) 1991, 2007, Oracle. All rights reserved.
Starting /u01/app/oracle/product/11.1.0/db_1/bin/tnslsnr: please wait...
TNSLSNR for Linux: Version 11.1.0.6.0 - Production
System parameter file is /u01/app/oracle/product/11.1.0/db_1/network/admin/listener.ora
Log messages written to /u01/app/oracle/diag/tnslsnr/jhlinux/listener/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost.localdomain)(PORT=1521)))
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=jhlinux.home.com)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 11.1.0.6.0 - Production
Start Date 10-MAR-2011 20:47:53
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/oracle/product/11.1.0/db_1/network/admin/listener.ora
Listener Log File /u01/app/oracle/diag/tnslsnr/jhlinux/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost.localdomain)(PORT=1521)))
The listener supports no services
The command completed successfully
So I took this to mean that I need to startup the database. So once I started the database I quickly found out there is no listener.
[oracle@jhlinux ~]$ sqlplus scott@orcl
SQL*Plus: Release 11.1.0.6.0 - Production on Thu Mar 10 20:56:01 2011
Copyright (c) 1982, 2007, Oracle. All rights reserved.
Enter password:
ERROR:
ORA-12541: TNS:no listener
|
|
|
|
| Re: Unable to start listener [message #498702 is a reply to message #498700] |
Thu, 10 March 2011 20:10 |
 |
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
|
Senior Member |
|
|
tnsping orcl
lsnrctl status
lsnrctl stop
mv /u01/app/oracle/product/11.1.0/db_1/network/admin/listener.ora /u01/app/oracle/product/11.1.0/db_1/network/admin/listener.ora.sav
lsnrctl start
do as above then COPY results and PASTE all back here
[Updated on: Thu, 10 March 2011 20:11] Report message to a moderator |
|
|
|
| Re: Unable to start listener [message #498714 is a reply to message #498702] |
Thu, 10 March 2011 20:57 |
jxh461
Messages: 185
Registered: March 2005
|
Senior Member |
|
|
[oracle@jhlinux ~]$ tnsping orcl
TNS Ping Utility for Linux: Version 11.1.0.6.0 - Production on 10-MAR-2011 21:54:39
Copyright (c) 1997, 2007, Oracle. All rights reserved.
Used parameter files:
/u01/app/oracle/product/11.1.0/db_1/network/admin/sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = jhlinux.home.com)(PORT = null)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl)))
TNS-12541: TNS:no listener
[oracle@jhlinux ~]$
[oracle@jhlinux ~]$ lsnrctl status
LSNRCTL for Linux: Version 11.1.0.6.0 - Production on 10-MAR-2011 21:55:57
Copyright (c) 1991, 2007, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=jhlinux.home.com)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 11.1.0.6.0 - Production
Start Date 10-MAR-2011 20:47:53
Uptime 0 days 1 hr. 8 min. 4 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/oracle/product/11.1.0/db_1/network/admin/listener.ora
Listener Log File /u01/app/oracle/diag/tnslsnr/jhlinux/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost.localdomain)(PORT=1521)))
The listener supports no services
The command completed successfully
[oracle@jhlinux ~]$ lsnrctl stop
LSNRCTL for Linux: Version 11.1.0.6.0 - Production on 10-MAR-2011 21:56:39
Copyright (c) 1991, 2007, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=jhlinux.home.com)(PORT=1521)))
The command completed successfully
[oracle@jhlinux ~]$
[oracle@jhlinux ~]$ mv /u01/app/oracle/product/11.1.0/db_1/network/admin/listener.ora /u01/app/oracle/product/11.1.0/db_1/network/admin/listener.ora.sav
[oracle@jhlinux ~]$ lsnrctl start
LSNRCTL for Linux: Version 11.1.0.6.0 - Production on 10-MAR-2011 21:58:19
Copyright (c) 1991, 2007, Oracle. All rights reserved.
Starting /u01/app/oracle/product/11.1.0/db_1/bin/tnslsnr: please wait...
TNSLSNR for Linux: Version 11.1.0.6.0 - Production
Log messages written to /u01/app/oracle/diag/tnslsnr/jhlinux/listener/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost.localdomain)(PORT=1521)))
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 11.1.0.6.0 - Production
Start Date 10-MAR-2011 21:58:19
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Log File /u01/app/oracle/diag/tnslsnr/jhlinux/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost.localdomain)(PORT=1521)))
The listener supports no services
The command completed successfully
|
|
|
|
|
|
| Re: Unable to start listener [message #498728 is a reply to message #498717] |
Thu, 10 March 2011 22:17 |
jxh461
Messages: 185
Registered: March 2005
|
Senior Member |
|
|
[oracle@jhlinux ~]$ lsnrctl status
LSNRCTL for Linux: Version 11.1.0.6.0 - Production on 10-MAR-2011 23:19:04
Copyright (c) 1991, 2007, Oracle. All rights reserved.
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 11.1.0.6.0 - Production
Start Date 10-MAR-2011 23:17:49
Uptime 0 days 0 hr. 1 min. 15 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Log File /u01/app/oracle/diag/tnslsnr/jhlinux/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost.localdomain)(PORT=1521)))
The listener supports no services
The command completed successfully
[oracle@jhlinux ~]$ sqlplus scott@orcl
SQL*Plus: Release 11.1.0.6.0 - Production on Thu Mar 10 23:19:17 2011
Copyright (c) 1982, 2007, Oracle. All rights reserved.
Enter password:
ERROR:
ORA-12541: TNS:no listener
|
|
|
|
|
|
| Re: Unable to start listener [message #498733 is a reply to message #498731] |
Thu, 10 March 2011 22:46 |
jxh461
Messages: 185
Registered: March 2005
|
Senior Member |
|
|
[oracle@jhlinux ~]$ cat /etc/hosts
# Do not remove the following line, or various programs
# that require network functionality will fail.
# ::1 localhost6.localdomain6
#127.0.0.1 localhost.localdomain localhost
#127.0.0.1 jhlinux.home.com jhlinux
127.0.0.1 localhost jhlinux localhost.localdomain
[oracle@jhlinux ~]$ uname -a
Linux jhlinux 2.6.18-8.el5 #1 SMP Fri Jan 26 14:15:14 EST 2007 x86_64 x86_64 x86_64 GNU/Linux
[oracle@jhlinux ~]$
|
|
|
|
|
|
| Re: Unable to start listener [message #499243 is a reply to message #498741] |
Mon, 14 March 2011 04:50 |
ridhi_sundar
Messages: 184
Registered: November 2007
Location: Bangalore
|
Senior Member |
|
|
1. Makes sure the host entry in /etc/hosts is as below
Quote:127.0.0.1 localhost.localdomain localhost
2. Makes sure the tns entry is as below.
Quote:orcl=(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = localhost.localdomain)(PORT = null)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl)))
3. ping localhost.localdomain
4. tnsping orcl
5. sqlplus scott@orcl
|
|
|
|
| Re: Unable to start listener [message #499437 is a reply to message #499243] |
Mon, 14 March 2011 21:47 |
jxh461
Messages: 185
Registered: March 2005
|
Senior Member |
|
|
--- localhost.localdomain ping statistics ---
8 packets transmitted, 8 received, 0% packet loss, time 6999ms
rtt min/avg/max/mdev = 0.018/0.019/0.020/0.003 ms
[oracle@jhlinux admin]$ tnsping orcl
TNS Ping Utility for Linux: Version 11.1.0.6.0 - Production on 14-MAR-2011 22:45:34
Copyright (c) 1997, 2007, Oracle. All rights reserved.
Used parameter files:
/u01/app/oracle/product/11.1.0/db_1/network/admin/sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = localhost.localdomain)(PORT = null)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl)))
TNS-12541: TNS:no listener
[oracle@jhlinux admin]$ sqlplus scott@orcl
SQL*Plus: Release 11.1.0.6.0 - Production on Mon Mar 14 22:46:50 2011
Copyright (c) 1982, 2007, Oracle. All rights reserved.
Enter password:
ERROR:
ORA-12541: TNS:no listener
[oracle@jhlinux admin]$ lsnrctl start
LSNRCTL for Linux: Version 11.1.0.6.0 - Production on 14-MAR-2011 23:00:29
Copyright (c) 1991, 2007, Oracle. All rights reserved.
Starting /u01/app/oracle/product/11.1.0/db_1/bin/tnslsnr: please wait...
TNSLSNR for Linux: Version 11.1.0.6.0 - Production
System parameter file is /u01/app/oracle/product/11.1.0/db_1/network/admin/listener.ora
Log messages written to /u01/app/oracle/diag/tnslsnr/jhlinux/listener/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521)))
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost.localdomain)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 11.1.0.6.0 - Production
Start Date 14-MAR-2011 23:00:29
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/oracle/product/11.1.0/db_1/network/admin/listener.ora
Listener Log File /u01/app/oracle/diag/tnslsnr/jhlinux/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521)))
The listener supports no services
The command completed successfully
[oracle@jhlinux admin]$
[Updated on: Mon, 14 March 2011 21:59] Report message to a moderator |
|
|
|
|
|
| Re: Unable to start listener [message #499456 is a reply to message #499441] |
Mon, 14 March 2011 23:46 |
jxh461
Messages: 185
Registered: March 2005
|
Senior Member |
|
|
[oracle@jhlinux ~]$ lsnrctl status
LSNRCTL for Linux: Version 11.1.0.6.0 - Production on 15-MAR-2011 00:45:14
Copyright (c) 1991, 2007, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost.localdomain)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 11.1.0.6.0 - Production
Start Date 14-MAR-2011 23:00:29
Uptime 0 days 1 hr. 44 min. 44 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/oracle/product/11.1.0/db_1/network/admin/listener.ora
Listener Log File /u01/app/oracle/diag/tnslsnr/jhlinux/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521)))
The listener supports no services
The command completed successfully
[oracle@jhlinux ~]$ lsnrctl service
LSNRCTL for Linux: Version 11.1.0.6.0 - Production on 15-MAR-2011 00:46:46
Copyright (c) 1991, 2007, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost.localdomain)(PORT=1521)))
The listener supports no services
The command completed successfully
[oracle@jhlinux ~]$ ps -ef | grep -i pmon
oracle 2971 1 0 Mar14 ? 00:00:00 ora_pmon_orcl
oracle 3515 2876 0 00:47 pts/1 00:00:00 grep -i pmon
[oracle@jhlinux ~]$
|
|
|
|
| Re: Unable to start listener [message #499953 is a reply to message #499456] |
Wed, 16 March 2011 22:45 |
jxh461
Messages: 185
Registered: March 2005
|
Senior Member |
|
|
Black Swan, I appreciate the effort you have put forth trying to help me. I do not know what is wrong here.
In the past I was able to install Oracle 10g on RHEL 4 and I did not get this problem.
My isp is Comcast and they have this modem they use to hook the phone line and internet. Since it does not
work as a router, I had to plug the internet outlet to a netgear router to make it accessible. Could it be
that my problem is router related ?
|
|
|
|
| Re: Unable to start listener [message #499954 is a reply to message #499953] |
Wed, 16 March 2011 23:01 |
|
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
|
Senior Member |
|
|
>Could it be that my problem is router related ?
I doubt it.
I have my laptop configured to only use localhost, so I can't be hacked into regardless of where I take my laptop.
So SQL*Net "works" even when I don't have an actual network connection as shown below.
oracle@bcm-laptop:~$ lsnrctl start
LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 16-MAR-2011 20:58:20
Copyright (c) 1991, 2009, Oracle. All rights reserved.
Starting /u01/app/oracle/product/11.2.0/dbhome_1/bin/tnslsnr: please wait...
TNSLSNR for Linux: Version 11.2.0.1.0 - Production
System parameter file is /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
Log messages written to /u01/app/oracle/diag/tnslsnr/bcm-laptop/listener/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1521)))
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 11.2.0.1.0 - Production
Start Date 16-MAR-2011 20:58:22
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
Listener Log File /u01/app/oracle/diag/tnslsnr/bcm-laptop/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1521)))
Services Summary...
Service "mysql" has 1 instance(s).
Instance "mysql", status UNKNOWN, has 1 handler(s) for this service...
Service "v112" has 1 instance(s).
Instance "v112", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
oracle@bcm-laptop:~$ lsnrctl status
LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 16-MAR-2011 20:58:36
Copyright (c) 1991, 2009, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 11.2.0.1.0 - Production
Start Date 16-MAR-2011 20:58:22
Uptime 0 days 0 hr. 0 min. 14 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
Listener Log File /u01/app/oracle/diag/tnslsnr/bcm-laptop/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1521)))
Services Summary...
Service "mysql" has 1 instance(s).
Instance "mysql", status UNKNOWN, has 1 handler(s) for this service...
Service "v112" has 2 instance(s).
Instance "v112", status UNKNOWN, has 1 handler(s) for this service...
Instance "v112", status READY, has 1 handler(s) for this service...
Service "v112XDB" has 1 instance(s).
Instance "v112", status READY, has 1 handler(s) for this service...
The command completed successfully
oracle@bcm-laptop:~$ lsnrctl service
LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 16-MAR-2011 20:58:53
Copyright (c) 1991, 2009, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
Services Summary...
Service "mysql" has 1 instance(s).
Instance "mysql", status UNKNOWN, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0
LOCAL SERVER
Service "v112" has 2 instance(s).
Instance "v112", status UNKNOWN, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0
LOCAL SERVER
Instance "v112", status READY, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0 state:ready
LOCAL SERVER
Service "v112XDB" has 1 instance(s).
Instance "v112", status READY, has 1 handler(s) for this service...
Handler(s):
"D000" established:0 refused:0 current:0 max:972 state:ready
DISPATCHER <machine: bcm-laptop, pid: 2045>
(ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=11067))
The command completed successfully
|
|
|
|
|
|
|
|
| Re: Unable to start listener [message #617788 is a reply to message #499959] |
Thu, 03 July 2014 11:17 |
 |
dancko
Messages: 108
Registered: June 2013
Location: italy
|
Senior Member |
|
|
Hi 
I have the exactly same problem.
Prompting lsnrctl status command, I get:
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=VMCentOS)(PORT=1521)))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
Linux Error: 111: Connection refused
Is it possible that there not exist any solution to the problem?
I think that in my case the problem is due to a bad network configuration. I modified hosts file and network adapter ip address many times before and after installation.
BlackSwan only you can help us. You are the best here!
[Updated on: Thu, 03 July 2014 11:21] Report message to a moderator |
|
|
|
|
|
| Re: Unable to start listener [message #617794 is a reply to message #617791] |
Thu, 03 July 2014 12:57 |
|
dancko
Messages: 108
Registered: June 2013
Location: italy
|
Senior Member |
|
|
Sorry Michel Cadot, I said that only BlackSwan can be helpful because only him has answered this post/topic. But I think that many of you are very expert.
P.S.: I'm not from remote machine... I'm on local machine.
1) Result of the ping the hosname:
[oracle@VMCentOS ~]$ ping VMCentOS
PING VMCentOS (192.168.0.80) 56(84) bytes of data.
64 bytes from VMCentOS (192.168.0.80): icmp_seq=1 ttl=64 time=0.061 ms
64 bytes from VMCentOS (192.168.0.80): icmp_seq=2 ttl=64 time=0.096 ms
64 bytes from VMCentOS (192.168.0.80): icmp_seq=3 ttl=64 time=0.080 ms
64 bytes from VMCentOS (192.168.0.80): icmp_seq=4 ttl=64 time=0.445 ms
64 bytes from VMCentOS (192.168.0.80): icmp_seq=5 ttl=64 time=0.095 ms
64 bytes from VMCentOS (192.168.0.80): icmp_seq=6 ttl=64 time=0.078 ms
64 bytes from VMCentOS (192.168.0.80): icmp_seq=7 ttl=64 time=0.086 ms
2) result of "lsnrctl start <your listener name>"
[oracle@VMCentOS ~]$ lsnrctl start LISTENER
LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 03-JUL-2014 10:53:15
Copyright (c) 1991, 2009, Oracle. All rights reserved.
Starting /u01/app/oracle/product/11.2.0/dbhome_1/bin/tnslsnr: please wait...
TNSLSNR for Linux: Version 11.2.0.1.0 - Production
System parameter file is /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
Log messages written to /u01/app/oracle/diag/tnslsnr/VMCentOS/listener/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=VMCentOS)(PORT=1521)))
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=VMCentOS)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 11.2.0.1.0 - Production
Start Date 03-JUL-2014 10:53:15
Uptime 0 days 0 hr. 0 min. 10 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
Listener Log File /u01/app/oracle/diag/tnslsnr/VMCentOS/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=VMCentOS)(PORT=1521)))
The listener supports no services
The command completed successfully
[oracle@VMCentOS ~]$
3)Content of my listener.ora
# listener.ora Network Configuration File: /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
# Generated by Oracle configuration tools.
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = VMCentOS)(PORT = 1521))
)
)
ADR_BASE_LISTENER = /u01/app/oracle
3)Content of my tnsnames.ora
# tnsnames.ora Network Configuration File: /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.
ORACLEDB =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = VMCentOS)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = oracledb)
)
)
[Updated on: Thu, 03 July 2014 13:07] Report message to a moderator |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
