 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 #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 #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 #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 #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 #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 #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
