This content has been marked as final. Show 24 replies
not sure that I fully understand your requirements.
Thus I have a few questions:
1) Is this question related to Oracle Express Edition (XE) or the "standard" HTML DB?
If it is standard HTML DB, then it might be better to post the question here: Oracle Application Express (APEX)
2) So you have one server (e.g. DBServer) where you run an Oracle 126.96.36.199
3) You have another server (e.g. Appserver) where you run another Apache. Is this Apache part of another Oracle installation or is it a standalone Apache? If so, which version?
Thanks for replying Dietmar,
1) It relates to the XE version of HTML DB. Is there a difference?
3) Yes. The Apache would be standalone. Not sure of version, but recent.
yes, it does make a difference.
Oracle XE comes with the embedded plsql gateway (in the database DBMS_EPG) and the "usual" HTML DB installation uses an Oracle Apache with mod_plsql.
I would suggest using your Apache as a proxy to your XE installation.
Make sure that in your httpd.conf the following modules are loaded:
LoadModule proxy_module modules/mod_proxy.soThen add the following lines to your httpd.conf:
LoadModule proxy_connect_module modules/mod_proxy_connect.so
LoadModule proxy_http_module modules/mod_proxy_http.so
SetEnv force-proxy-request-1.0 1where you replace
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
ProxyPass /sys http://127.0.0.1:8080/sys
ProxyPassReverse /sys http://127.0.0.1:8080/sys
127.0.0.1with the name or ip address of your XE installation. 8080 is the default http port of your XE installation.
Then you could access HTML DB/XE using the url http://appserver/htmldb.
I am still a bit confused.
You say that you want instructions for XE and you say that you are running Oracle 188.8.131.52.
But these are different versions! Oracle XE uses a restricted version of Oracle 10.2.0.1.
What exactly is your configuration?
Thanks again Dietmar,
We are considering to different set-ups.
1) Using Oracle 9i on one server and the standalone http server on another.
(Do you know which server would require the install of HTMLDB)
2) Using XE on a dedicated server.
(In this scenario, could you help with the http configuration using DBMS_EPG
for making the new application visible by others, ie. publishing the app.
This is very new to me ).
those are really two separate things. It always helps a lot if you give us as much detail about your requirements as possible :).
1) Using Oracle 9i on one server and the standaloneWell, you need to install HTML DB into the database, at least Oracle Version 184.108.40.206.
http server on another.
(Do you know which server would require the
the install of HTMLDB)
To access HTML DB, you need a pl/sql gateway. This can be either on the same machine as the database or on a different server.
You cannot run it on a standalone Apache server, you would have to use the Oracle Apache server that is installed with the 9i database or from the 10g / 10gR2 companion CD.
This one includes the pl/sql gateway (Apache module mod_plsql).
If you really need to use the standalone Apache server as the main entry point for your users you could still configure this one to be a proxy to your Oracle Apache on the database server or somewhere else.
2) Using XE on a dedicated server.Well, once you installed XE on a dedicated server it is fully functional out of the box. No further configuration is needed after the install (if you stay with the default ports). It is accessible from the network, no DBMS_EPG configuration needed.
(In this scenario, could you help with the http
tp configuration using DBMS_EPG
for making the new application visible by others,
s, ie. publishing the app.
This is very new to me ).
As detailed in the previous post you could install XE on a dedicated server and use the standalone Apache server as a proxy to the XE server.
Hope this helps,
P.S.: I am not sure about the licensing implications if you separate the Http server from the database server.
I can't thank you enough Dietmar,
I have just proven that I do not have to configure the XE database on it's dedicated server. I connected to the new app, across the network just fine.
Also, your advice on the various set-ups has been invaluable.
you're welcome :).
Enjoy the ride with XE,
Tim - as Dietmar mentioned, you may want to check out the licensing implications of running the HTTP Server on a machine other than what the database is licensed for.
Ok is that configuration in free licence: Szandalone Apache and Oracle XE (on different PC's)?
Ok is that configuration in free licence: SzandaloneSure! The OP was asking for a configuration where he used the Oracle Apache (with mod_plsql !) as the middle tier to connect to the 220.127.116.11 Oracle db on the backend (via sqlnet). This is Oracle software which needs to be licensed per machine or named user.
Apache and Oracle XE (on different PC's)?
In your case the only "Oracle" software would be XE and the standalone Apache serves basically as a true proxy. That's fine (and free :).
Ok so suggestions from Daust_de topic (to configure Appache) are corect and all we need to make it work?
There has been a change of tack at my project.
They would like to use HTML_DB installed on the 18.104.22.168 database, and use Apache on another server to access the HTML_DB application. Is this possible using the Apache webserver that comes with Oracle, without having to install a database.
Their concern is - not to add too much to the load already on the database server.
I was also confused by your earlier note. Is it possble to configure it so the plsql gateway is on the server with Apache and not have any http server running on the database server ?
What are the licensing issues using HTML_DB and Apache from Oracle on two separate servers ?
That's a lot of questions - sorry.