• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 923
  • Last Modified:

Oracle listener: add HTTP method

How can I setup the Oracle listener to also support HTTP connections? I am running LSNRCTL, then type STATUS and see:

Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=nanjing.local)(PORT=1521)))

In addition, I would like to have:

  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=GROOVY-LAP)
    (PORT=8080))(Presentation=HTTP)(Session=RAW))

This is so I can connect to Oracle with WebDAV, and use the HTTP methods to query the database.
0
avernet
Asked:
avernet
  • 2
1 Solution
 
konektorCommented:
you cannot configure listener to "http server"

http://download.oracle.com/docs/cd/B19306_01/server.102/b14220/dist_pro.htm#sthref1771

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

http://download.oracle.com/docs/cd/B19306_01/network.102/b14212/architecture.htm#i1044756

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

http://download-uk.oracle.com/docs/cd/B19306_01/server.102/b14190/toc.htm
0
 
avernetAuthor Commented:
konektor,

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.

http://www.oracle.com/technology/oramag/oracle/05-may/o35xml.html

Alex
0
 
avernetAuthor Commented:
Here is the answer: edit listener.ora and add the 2 following lines changing the host name as appropriate:
 (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=GROOVY-LAP)(PORT=8889))(Presentation=HTTP)(Session=RAW)) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=GROOVY-LAP)(PORT=2100))(Presentation=FTP)(Session=RAW))

For a full config, see:

http://www.oracle.com/technology/oramag/oracle/05-may/listener_status.txt

Alex
0
 
Vee_ModCommented:
Closed, 125 points refunded.
Vee_Mod
Community Support Moderator
0

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now