This discussion is archived
3 Replies Latest reply: Nov 20, 2012 11:43 AM by orafad RSS

11gR2 XE Listener dies after about 10 seconds

arabxptyltd Newbie
Currently Being Moderated
I am able to start a listener, connect via sqlplus, but after about 10 seconds it dies and there is no explanation.

$ lsnrctl start

LSNRCTL for Linux: Version 11.2.0.2.0 - Production on 19-NOV-2012 19:29:28
Copyright (c) 1991, 2011, Oracle. All rights reserved.
Starting /u01/app/oracle/product/11.2.0/xe/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 11.2.0.2.0 - Production
System parameter file is /u01/app/oracle/product/11.2.0/xe/network/admin/listener.ora
Log messages written to /u01/app/oracle/product/11.2.0/xe/log/diag/tnslsnr/xe1/listener/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=xe1)(PORT=1521)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=xe1)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 11.2.0.2.0 - Production
Start Date 19-NOV-2012 19:29:28
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/xe/network/admin/listener.ora
Listener Log File /u01/app/oracle/product/11.2.0/xe/log/diag/tnslsnr/xe1/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=xe1)(PORT=1521)))
Services Summary...
Service "XE" has 1 instance(s).
Instance "XE", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully


$ sqlplus tungsten/****@xe1:1521/XE
SQL*Plus: Release 11.2.0.2.0 Production on Mon Nov 19 19:29:34 2012
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit Production


All the checks you would normally do confirm the port is accessible

$ netstat -pan | grep 1521
tcp 0 0 10.10.0.151:46897 10.10.0.151:1521 TIME_WAIT -
tcp 0 0 :::1521 :::* LISTEN 9840/tnslsnr
''

$ tnsping XE

TNS Ping Utility for Linux: Version 11.2.0.2.0 - Production on 19-NOV-2012 19:24:57
Copyright (c) 1997, 2011, Oracle. All rights reserved.
Used parameter files:

Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = xe1)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = XE)))
OK (10 msec)

Yet about 10 seconds later.

$ lsnrctl status

LSNRCTL for Linux: Version 11.2.0.2.0 - Production on 19-NOV-2012 19:30:21
Copyright (c) 1991, 2011, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=xe1)(PORT=1521)))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
Linux Error: 111: Connection refused



cat /u01/app/oracle/product/11.2.0/xe/network/admin/listener.ora
# listener.ora Network Configuration File:

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = XE)
(ORACLE_HOME = /u01/app/oracle/product/11.2.0/xe)
)
)

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = xe1)(PORT = 1521))
)
)


cat /u01/app/oracle/product/11.2.0/xe/network/admin/tnsnames.ora
# tnsnames.ora Network Configuration File:

XE =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = xe1)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = XE)
)
)


Any suggestions appreciated
  • 1. Re: 11gR2 XE Listener dies after about 10 seconds
    orafad Oracle ACE
    Currently Being Moderated
    What linux-based OS is on the host?

    Does it have firewall / iptables running?

    Results from those sqlplus, netstat and tnsping commands when about 10 seconds later?

    Result from lsnrctl stat immediately after 'lsnrctl start'?
  • 2. Re: 11gR2 XE Listener dies after about 10 seconds
    arabxptyltd Newbie
    Currently Being Moderated
    Hi,

    I have installed this on both CentOS 6.3, and now Oracle Linux 6.3 (both 64bit), running under Oracle VirtualBox.
    iptables is off on both systems

    Here is a script to show the timeline.

    $date;lsnrctl start;lsnrctl stat;tnsping XE;netstat -pan | grep 1521; sleep 5;date;lsnrctl stat;sleep 5;date; lsnrctl stat

    Mon Nov 19 22:02:35 EST 2012

    LSNRCTL for Linux: Version 11.2.0.2.0 - Production on 19-NOV-2012 22:02:35

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

    Starting /u01/app/oracle/product/11.2.0/xe/bin/tnslsnr: please wait...

    TNSLSNR for Linux: Version 11.2.0.2.0 - Production
    System parameter file is /u01/app/oracle/product/11.2.0/xe/network/admin/listener.ora
    Log messages written to /u01/app/oracle/product/11.2.0/xe/log/diag/tnslsnr/xe1/listener/alert/log.xml
    Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=xe1)(PORT=1521)))

    Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=xe1)(PORT=1521)))
    STATUS of the LISTENER
    ------------------------
    Alias LISTENER
    Version TNSLSNR for Linux: Version 11.2.0.2.0 - Production
    Start Date 19-NOV-2012 22:02:35
    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/xe/network/admin/listener.ora
    Listener Log File /u01/app/oracle/product/11.2.0/xe/log/diag/tnslsnr/xe1/listener/alert/log.xml
    Listening Endpoints Summary...
    (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=xe1)(PORT=1521)))
    Services Summary...
    Service "XE" has 1 instance(s).
    Instance "XE", status UNKNOWN, has 1 handler(s) for this service...
    The command completed successfully

    LSNRCTL for Linux: Version 11.2.0.2.0 - Production on 19-NOV-2012 22:02:35

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

    Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=xe1)(PORT=1521)))
    STATUS of the LISTENER
    ------------------------
    Alias LISTENER
    Version TNSLSNR for Linux: Version 11.2.0.2.0 - Production
    Start Date 19-NOV-2012 22:02:35
    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/xe/network/admin/listener.ora
    Listener Log File /u01/app/oracle/product/11.2.0/xe/log/diag/tnslsnr/xe1/listener/alert/log.xml
    Listening Endpoints Summary...
    (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=xe1)(PORT=1521)))
    Services Summary...
    Service "XE" has 1 instance(s).
    Instance "XE", status UNKNOWN, has 1 handler(s) for this service...
    The command completed successfully

    TNS Ping Utility for Linux: Version 11.2.0.2.0 - Production on 19-NOV-2012 22:02:35

    Copyright (c) 1997, 2011, Oracle. All rights reserved.

    Used parameter files:


    Used TNSNAMES adapter to resolve the alias
    Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = xe1)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = XE)))
    OK (0 msec)
    tcp 0 0 :::1521 :::* LISTEN 10187/tnslsnr
    tcp 0 0 ::ffff:10.10.0.151:1521 ::ffff:10.10.0.151:47114 TIME_WAIT -
    tcp 0 0 ::ffff:10.10.0.151:1521 ::ffff:10.10.0.151:47118 TIME_WAIT -
    tcp 0 0 ::ffff:10.10.0.151:1521 ::ffff:10.10.0.151:47115 TIME_WAIT -
    tcp 0 0 ::ffff:10.10.0.151:1521 ::ffff:10.10.0.151:47112 TIME_WAIT -
    tcp 0 0 ::ffff:10.10.0.151:1521 ::ffff:10.10.0.151:47113 TIME_WAIT -
    tcp 0 0 ::ffff:10.10.0.151:1521 ::ffff:10.10.0.151:47119 TIME_WAIT -
    tcp 0 0 ::ffff:10.10.0.151:1521 ::ffff:10.10.0.151:47120 TIME_WAIT -
    Mon Nov 19 22:02:40 EST 2012

    LSNRCTL for Linux: Version 11.2.0.2.0 - Production on 19-NOV-2012 22:02:40

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

    Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=xe1)(PORT=1521)))
    STATUS of the LISTENER
    ------------------------
    Alias LISTENER
    Version TNSLSNR for Linux: Version 11.2.0.2.0 - Production
    Start Date 19-NOV-2012 22:02:35
    Uptime 0 days 0 hr. 0 min. 5 sec
    Trace Level off
    Security ON: Local OS Authentication
    SNMP OFF
    Listener Parameter File /u01/app/oracle/product/11.2.0/xe/network/admin/listener.ora
    Listener Log File /u01/app/oracle/product/11.2.0/xe/log/diag/tnslsnr/xe1/listener/alert/log.xml
    Listening Endpoints Summary...
    (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=xe1)(PORT=1521)))
    Services Summary...
    Service "XE" has 1 instance(s).
    Instance "XE", status UNKNOWN, has 1 handler(s) for this service...
    The command completed successfully
    Mon Nov 19 22:02:45 EST 2012

    LSNRCTL for Linux: Version 11.2.0.2.0 - Production on 19-NOV-2012 22:02:45

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

    Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=xe1)(PORT=1521)))
    TNS-12541: TNS:no listener
    TNS-12560: TNS:protocol adapter error
    TNS-00511: No listener
    Linux Error: 111: Connection refused
  • 3. Re: 11gR2 XE Listener dies after about 10 seconds
    orafad Oracle ACE
    Currently Being Moderated
    Not sure that this version of 11.2 is supported on OL 6.x. (memory says 11.2.0.3 was the first to support 6.x but memory might be old or bad)
    Did you try on OL 5.2?

    Did you follow pre-reqs for installation, per Installation Guide? http://docs.oracle.com/cd/E17781_01/install.112/e18802/toc.htm


    Near the time of listener failing what do you have in listener.log and alert.log?

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points