Tuesday, October 16, 2007

Setting up the Oracle listener for HTTP, WebDAV, and FTP

Oracle provides a facility for the data you have in your database to be exposed as XML documents that you can access through simple URLs. For this facility to be enabled, the first thing you will need to do is to setup the Oracle listener. Edit your C:\oracle\product\10.2.0\db_1\NETWORK\ADMIN\listener.ora (or equivalent on your system) and setup the listener to look as the follows. Note that nanjing.local is my host name; change this as appropriate.
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
(ADDRESS = (PROTOCOL = TCP)(HOST = nanjing.local)(PORT = 1521))
)
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)
(HOST=nanjing.local)(PORT=8889))
(Presentation=HTTP)(Session=RAW))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)
(HOST=nanjing.local)(PORT=2100))
(Presentation=FTP)(Session=RAW))
)
Now you should be able to access http://localhost:8889/ with your web browser and with WebDAV. Stay tuned for more you can do from this URL.