This content has been marked as final. Show 37 replies
Login to the database with SYSDBA privileges.
SQL> exec dbms_xdb.sethttpport('8081');
Bounce the database or start-stop OracleServiceXE.(I am not sure if this is required)
Try accessing the new port.
The .url files in ORACLE_HOME have to be updated to keep your start-menu shortcuts working (they may still be pointing to 8080).
Thank you very much. Problem solved.
I change it to port 80.
Restart it isn't required.
I have done this with port 80.
When I go to
It works fine.
When I do this:
I get the text on the browser below, running on Windows 2000. How can I stop the directory being browser and redirect always to http://127.0.0.1/htmldb?
Index of /
Name Last modified Size
i/ Wed, 02 Nov 2005 01:00:00 GMT -
public/ Mon, 10 Oct 2005 10:00:00 GMT-
sys/ Mon, 10 Oct 2005 10:00:00 GMT
Run SQL Command Line, connect as system and write:
v_html := '<html><body>< a href="/htmldb">Home page< /a></body></html>';
result := dbms_xdb.createresource('/index.html',v_html);
Be careful doing this. We may use this page in the production version to display a welcome page, or perhaps even the license details. As such, the production release may attempt to change this page during the upgrade from beta. I doubt we will cater for situations where the page has been removed or changed from what we expect to find there.
perhaps it might be a good choice to have an standalone Apache server running in front of XE for several reasons.
You could then set up the standalone Apache running on port 80 as a proxy to XE running on port 8080.
You could then configure it the following way in the httpd.conf:
ProxyPass /htmldb http://127.0.0.1:8080/htmldb
ProxyPassReverse /htmldb http://127.0.0.1:8080/htmldb
ProxyPass /i http://127.0.0.1:8080/i
ProxyPassReverse /i http://127.0.0.1:8080/i
and the index.html in your Apache/htdocs directory could do a redirect to /htmldb.
It might be worth considering.
> You could then configure it the following way in the
> ProxyPass /htmldb http://127.0.0.1:8080/htmldb
> ProxyPassReverse /htmldb
> b http://127.0.0.1:8080/htmldb
> ProxyPass /i http://127.0.0.1:8080/i
> ProxyPassReverse /i http://127.0.0.1:8080/i
Dietmar, thanks for sharing this.
But WOW ! the response is at least 5 X s.l.o.w.e.r !!!
<img src="http://www.iamviet.com/forum/images/smilies/smilie_pop_eyes.gif" alt="" />
But WOW ! the response is at least 5 X s.l.o.w.e.r !!!Yeah, I was wondering how that passthrough technique would affect performance. Is there any other way to access XE schema's directly instead of through htmlDB/XDB - is it possible to run apache with mod_plsql?
I take it that would take a separate oracle home with a licenced version of the DB or appserver to achieve?
ok, so I just read up on dbms_epg, so that answers the first part...
I guess there's still the performance question though...
You can use DBPrism Servlet Engine mod_plsql emulation.
Latest version (CVS) works perfect with HTMLDB installed on XE, you can download a zip version from files section of Yahoo groups:
htmldb-11-08-05.zip is ready to use deployment for OC4J and Tomcat mapped as http://localhost:8888/htmldb/ for example.
You only need to download the HTMLDB static resources (http://localhost:8080/i) using wget or any download accelerator program and put them into the ORACLE_HOME/j2ee/home/default-web-app or into TOMCAT_HOME/webapps/ROOT for example.
Your performance will be enhanced using this configuration and you will have many other features provides by DBPrism.
Best regards, Marcelo.
I could reproduce the problem using the latest Apache 2 (2.0.55) and it was terribly slow.
Using Apache 1.3.33 it was REALLY FAST, no performance differences at all.
Don't know why it is so slow using Apache2, but Apache 1.3.33 works really well.
P.S.: I used both on Windows XP SP2, haven't checked on Linux
Message was edited by:
Thanks for the pointers on DBPrism Marcelo, I'll check it out.
Dietmar - I did a search on proxypass performance, and came up with a mention of a bug in Apache 2 from http://www.apacheweek.com/features/reverseproxies -
Check libxml2 is installed. If you have a version older than 2.5.10, then upgrade - there's a bug in earlier versions that can, in some particular cases, severely affect performance.
Not sure if thats it, but it could be the culprit.