Oracle listener: add HTTP method

Posted on 2007-10-15
Last Modified: 2013-12-19
How can I setup the Oracle listener to also support HTTP connections? I am running LSNRCTL, then type STATUS and see:

Listening Endpoints Summary...

In addition, I would like to have:


This is so I can connect to Oracle with WebDAV, and use the HTTP methods to query the database.
Question by:avernet
    LVL 9

    Expert Comment

    you cannot configure listener to "http server"

    The Listener

    When an instance starts, a listener process establishes a communication pathway to Oracle. When a user process makes a connection request, the listener determines whether it should use a shared server dispatcher process or a dedicated server process and establishes an appropriate connection.

    The listener also establishes a communication pathway between databases. When multiple databases or instances run on one computer, as in Real Application Clusters, service names enable instances to register automatically with other listeners on the same computer. A service name can identify multiple instances, and an instance can belong to multiple services. Clients connecting to a service do not have to specify which instance they require.

    see also listener architecture

    if you need to listen to http requests, you shoul use http server
    LVL 1

    Author Comment


    You can use the Oracle HTTP server, which essentially Apache HTTPD. But to use XML DB, I think you need to have the Oracle listener listen for HTTP and FTP connections. See the article below, search for "Listening Endpoints Summary", and you will see that the Oracle listener is listens for HTTP and FTP connections.

    LVL 1

    Accepted Solution

    Here is the answer: edit listener.ora and add the 2 following lines changing the host name as appropriate:

    For a full config, see:

    LVL 1

    Expert Comment

    Closed, 125 points refunded.
    Community Support Moderator

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Looking for New Ways to Advertise?

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

    Configuring and using Oracle Database Gateway for ODBC Introduction First, a brief summary of what a Database Gateway is.  A Gateway is a set of driver agents and configurations that allow an Oracle database to communicate with other platforms…
    Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
    This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.
    This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.

    737 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

    16 Experts available now in Live!

    Get 1:1 Help Now