1 2 Previous Next 24 Replies Latest reply on Jan 17, 2007 9:17 PM by 392393

    Existing http server

    454652
      I am currently working on a contract where the management are very keen to use HTMLDB but they want to use their existing http server. It runs on another server to the Oracle server, which is running Oracle version 9.2.0.5.

      I have downloaded the HowTo document on configuring the 9i Apache server for HTMLDB, but this is not really what I need.

      Can anyone advise me on what I need to do to configure the existing http server, on the other machine, to work with HTMLDB and Oracle 9i. ?
        • 1. Re: Existing http server
          Dietmar Aust
          Tim,

          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 9.2.0.5

          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?

          ~dietmar.
          • 2. Re: Existing http server
            454652
            Thanks for replying Dietmar,

            1) It relates to the XE version of HTML DB. Is there a difference?

            2) Yes

            3) Yes. The Apache would be standalone. Not sure of version, but recent.
            • 3. Re: Existing http server
              Dietmar Aust
              Hi Tim,

              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.so
              LoadModule proxy_connect_module modules/mod_proxy_connect.so
              LoadModule proxy_http_module modules/mod_proxy_http.so
              Then add the following lines to your httpd.conf:
              SetEnv force-proxy-request-1.0 1

              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
              where you replace
              127.0.0.1
              with 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.

              ~dietmar.
              • 4. Re: Existing http server
                Dietmar Aust
                Tim,

                I am still a bit confused.

                You say that you want instructions for XE and you say that you are running Oracle 9.2.0.5.

                But these are different versions! Oracle XE uses a restricted version of Oracle 10.2.0.1.
                What exactly is your configuration?

                ~dietmar.
                • 5. Re: Existing http server
                  454652
                  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 ).
                  • 6. Re: Existing http server
                    Dietmar Aust
                    Tim,

                    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 standalone
                    http server on another.
                    (Do you know which server would require the
                    the install of HTMLDB)
                    Well, you need to install HTML DB into the database, at least Oracle Version 9.2.0.3.
                    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.
                    (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 ).
                    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.

                    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,
                    ~dietmar.

                    P.S.: I am not sure about the licensing implications if you separate the Http server from the database server.
                    • 7. Re: Existing http server
                      454652
                      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.

                      Thanks again.
                      • 8. Re: Existing http server
                        Dietmar Aust
                        Tim,

                        you're welcome :).

                        Enjoy the ride with XE,
                        ~Dietmar.
                        • 9. Re: Existing http server
                          241066
                          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.
                          • 10. Re: Existing http server
                            Funky
                            Ok is that configuration in free licence: Szandalone Apache and Oracle XE (on different PC's)?

                            THX!
                            • 11. Re: Existing http server
                              Dietmar Aust
                              Ok is that configuration in free licence: Szandalone
                              Apache and Oracle XE (on different PC's)?
                              Sure! The OP was asking for a configuration where he used the Oracle Apache (with mod_plsql !) as the middle tier to connect to the 9.2.0.5 Oracle db on the backend (via sqlnet). This is Oracle software which needs to be licensed per machine or named user.

                              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 :).

                              ~Dietmar.
                              • 12. Re: Existing http server
                                Funky
                                Ok so suggestions from Daust_de topic (to configure Appache) are corect and all we need to make it work?
                                • 13. Re: Existing http server
                                  Dietmar Aust
                                  Damir,

                                  yes, the instructions here: Existing http server

                                  are complete for using a standalone Apache (1.3.x or 2.x) as a proxy to XE.

                                  We have figured it out in this thread: Re: Change Database Homepage Port

                                  ~Dietmar.
                                  • 14. Re: Existing http server
                                    454652
                                    Dietmar,

                                    There has been a change of tack at my project.

                                    They would like to use HTML_DB installed on the 9.2.0.5 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.

                                    Thanks.
                                    1 2 Previous Next