Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Ok, so i have Oracle 10g XE running on my windows machine. It has stored pl/sql procedures which generate HTML pages. So I have my DAD configured to listen to localhost at port 80. So i can access those pages. What i need to know is how to open this pages to public. I found a ton of manuals on how to do it with apache server, but how do i do it with the HTTP server that comes with Oracle XE?

share|improve this question

migrated from Jun 3 '11 at 17:20

This question came from our site for pro webmasters.

I would STRONGLY advise against opening up the Oracle XE web server "to the public". Take the time to write an application layer with SQL injection checks and the like, and keep access to your Oracle server limited to a small list of authorized hosts that you know and trust.
Opening up the Oracle XE web server to the public means anyone stumbling around on the internet will have access to anything running on that web server, which includes some administrative functions that you probably don't want them to have access to.

Having said all that, the magic invocation exec dbms_xdb.setListenerLocalAccess(false); (as the sys user) should remove the "local-access-only" restriction.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.