Output from my lsnrctl status- What's wrong??

Posted on 2004-11-03
Last Modified: 2008-01-09
Hello experts,
I am running Oracle on Linux RedHat.
When I tried to check status  of my listener, I saw some extra info in the output, which I couldn't explain why they are there. The lines questionable outputs are commented with $$$$$$$$$$$$$$ in the below message from lsnrctl status. Do you have an explaination for why they are there?
In short, why the ports of http and ftp are also present in the output of my listener??? I'll post the content of my tnsnames.ora if you so desire, however I can assure you that these http and ftp ports are no way included in tnsnames.ora.

###############begin of output from lsnrctl status#####################

LSNRCTL for Linux: Version - Production on 03-NOV-2004 17:54:19
Copyright (c) 1991, 2004, Oracle.  All rights reserved.
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version - Production
Start Date                03-NOV-2004 17:52:33
Uptime                    0 days 0 hr. 1 min. 46 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /app/oracle/product/10.1.0/db_1/network/admin/listener.ora
Listener Log File         /app/oracle/product/10.1.0/db_1/network/log/listener.log
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=myHostName)(PORT=8080))(Presentation=HTTP)(Session=RAW)) //$$$$$$$$$$$$$$$$$$$$$$$ why it is here????????????$$
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=myHostName)(PORT=2100))(Presentation=FTP)(Session=RAW))//$$$$$$$$$$$$$$$$$$$$$$$ why it is here????????????$$
Services Summary...
Service "PLSExtProc" has 1 instance(s).
  Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "titan123" has 1 instance(s).
  Instance "titan123", status READY, has 1 handler(s) for this service...
Service "titan123XDB" has 1 instance(s).
  Instance "titan123", status READY, has 1 handler(s) for this service...
The command completed successfully

###############end of output from lsnrctl status#####################
Question by:dttai
    LVL 9

    Expert Comment

    It looks like Oracle now allows you to access the data through the HTTP and FTP protocols. Earlier TCP was the most commonly (or the only) protocol used to enable the data/information transfers across the networks.
    If you are not using web access methods to get your data, and don't intend to use these features, then safely remove it and restart the listener.

    Author Comment

    Hi pratikroy,
    In fact, I am using Tomcat to access data from Oracle and it is supposed to  use port 8080. However, with that message in Oracle listern output, I couldn't start my Tomcat !!! because it said the port is in use??? Do you see the paradox I am trying to say in here??:
    So now the port 8080 is found in Oracle listener because it "knows" that Oracle db is about to be accessed through http.
    However, the question how does it know because I haven't started Tomcat (and I can't start Tomcat because the port is already in use!!!)

    I asked the question in the first place because when I started Tomcat, Tomcat complained because the port is in use????

    Author Comment

    >>then safely remove it and restart the listener.
    Can you elaborate a little more? What do I need to remove and how??

    Author Comment

    Also, I am still perplexed how Oracle listener found these:
    (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=myHostName)(PORT=8080))(Presentation=HTTP)(Session=RAW)) //$$$$$$$$$$$$$$$$$$$$$$$ why it is here????????????$$
      (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=myHostName)(PORT=2100))(Presentation=FTP)(Session=RAW))//$$$$$$$$$$$$$$$$$$$$$$$ why it is here????????????$$

    I can understand the followings:
    because they are defined in listener.ora

    LVL 9

    Expert Comment

    I had not noticed/seen the usage of HTTP and FTP ... so I am in the same boat as yours. I will try and get you some definite answers, but in the mean time have a read through
    LVL 9

    Expert Comment

    Have you checked your listener.ora ? What are the entries there ?
    LVL 9

    Expert Comment

    LVL 9

    Expert Comment

    From Tom Kyte :

    Well, it depends on what you are trying to connect to... If you are just trying
    to use an HTTP listener, the database is shipped w/ Apache which sits in the
    code tree of the database in $ORACLE_HOME/Apache.  The other way, and the way I
    THINK you're talking about, is through XML DB to get to the XML DB Repository...

    In Oracle9i RELEASE 2, Oracle has implemented the "Protocol Server" (which
    provides FTP, HTTP and WebDAV connection capabilities into the database) in the
    XML DB Repository.  In order to configure the protocol server, you use XML DB
    APIs to update the XML DB configuration file, /sys/xdbconfig.xml.  The reason
    you use APIs to update this file is because it doesn't live on your OS or in the
    $ORACE_HOME tree, it resides INSIDE the database in the XML DB Repository.  To
    see this config, submit the following in sql*plus:
    SQL> connect system/blahblah

    SQL> set long 100000
    SQL> set lines 120
    SQL> select dbms_xdb.cfg_get().getClobVal()
      2    from dual;

    <xdbconfig xmlns="http: //" xmlns:xsi="http:
    //" xsi:schemaLocation="http:
    //                                     http:
          <common> *cut for brevity * </common>
            <server-name>XDB HTTP Server</server-name>
            <servlet-realm>Basic realm=&quot;XDB&quot;</servlet-realm>
            <webappconfig> * cut for brevity * </webappconfig>

    This SHOWS YOU what your ftp and http configuration is.  Specifically,
    /xdbconfig/sysconfig/protocolconfig/httpconfig/http-port/text() is the HTTP port
    your protocol server is listening on :-).  You can try to connect in a web
    browser by specifying the hostname of your database server along w/ the port of
    your protocol server's http setting, i.e.  This
    will prompt me for a username/password (it's a DATABASE, after all ;-)), and
    once I successfully authenticate I'm connected to the XML DB Repository.

    To edit this configuration, you call an XML DB API:


    You pass the new xdbconfig.xml file TO this procedure, which updates the
    configuration.  This may be a bit daunting if you're not used to using Oracle's
    XMLType, so here's an example of using this call to update the FTP & HTTP ports
    of the protocol server:

                            '/xdbconfig/descendant::ftp-port/text()', '2121'),
                  '/xdbconfig/descendant::http-port/text()', '19090'));

    This updates the FTP port to 2121 and the HTTP port to 19090.  For more
    information on the database's protocol server, the FTP, HTTP and/or WebDAV
    connection settings, XML DB, etc... see the XML Database Developer's Guide in
    the Oracle9i Release2 documentation set (available on TechNet (  
    In THAT document, Chapter 19 and Appendix A are YOUR friends :-).  I hope this
    has helped, good luck!
    LVL 9

    Expert Comment

    You could also do :


     v_cfg xmltype;


     select     updateXML(


                             '/xdbconfig/descendant::ftp-port/text()', '2121'),

                             '/xdbconfig/descendant::http-port/text()', '19090')

       into v_cfg

       from dual;




    This will ensure that the HTTP ports and FTP ports become 19090 and 2121 respectively instead of 8080 and 2100. By doing this the conflict with tomcat should be resolved.

    Hope this helps!
    LVL 9

    Accepted Solution


    Author Comment

    Please allow me sometime to digest. I think the information you provided is very helpful.
    By the way, I have temporarily solved the problem (w/o understanding why :)) by restart my Apache server. The Oracle listener status now does NOT have the entry for http, which allows me to start Tomcat w/o a problem. Of course, you deserve all the points being awarded to this question.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Join & Write a Comment

    Truncate is a DDL Command where as Delete is a DML Command. Both will delete data from table, but what is the difference between these below statements truncate table <table_name> ?? delete from <table_name> ?? The first command cannot be …
    Note: this article covers simple compression. Oracle introduced in version 11g release 2 a new feature called Advanced Compression which is not covered here. General principle of Oracle compression Oracle compression is a way of reducing the d…
    Via a live example show how to connect to RMAN, make basic configuration settings changes and then take a backup of a demo database
    This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.

    745 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    14 Experts available now in Live!

    Get 1:1 Help Now