5 Replies Latest reply: Dec 6, 2012 3:31 AM by user525629 RSS

    Oracle APEX 4.2 and Oracle 11g HTTP Server

    user525629
      Hi All,

      We are having Oracle APEX 3.1 version on Oracle 10g Database and Oracle 10g HTTP Server as web server in our organization.

      Now we are planning to upgrade the database to Oracle 11g and APEX to 4.2 version.

      My question is whether Oracle 10G HTTP server need to upgrade to Oracle 11G HTTP server for APEX 4.1 on Oracle 11g database? Or Can I keep Oracle 10G HTTP Server as it is?

      Any kind of help is appreciated.

      Lakshmi
        • 1. Re: Oracle APEX 4.2 and Oracle 11g HTTP Server
          Kiran Pawar
          Hello Lakshmi,

          >
          user525629 wrote:
          We are having Oracle APEX 3.1 version on Oracle 10g Database and Oracle 10g HTTP Server as web server in our organization.

          Now we are planning to upgrade the database to Oracle 11g and APEX to 4.2 version.

          My question is whether Oracle 10G HTTP server need to upgrade to Oracle 11G HTTP server for APEX 4.1 on Oracle 11g database? Or Can I keep Oracle 10G HTTP Server as it is?
          >

          The answer is:

          The following products include appropriate versions of HTTP Server and mod_plsql:

          1) Oracle Database 10g Companion CD Release 2

          2) Oracle Database 11g Release 1 or 2

          in the APEX 4.2 Installation Guide [url http://docs.oracle.com/cd/E37097_01/doc/install.42/e35123/pre_require.htm#CFHIIJBE]HTTP Server Requirements

          Refer: [url http://docs.oracle.com/cd/E37097_01/doc/install.42/e35123/toc.htm]Oracle® Application Express Installation Guide Release 4.2 Part Number E35123-03

          Hope it helps!
          Regards,
          Kiran
          • 2. Re: Oracle APEX 4.2 and Oracle 11g HTTP Server
            user525629
            Thanks Kiran for your reply.

            I got your point but in our case HTTP Server and Oracle Database (APEX) running on different machines.

            Oracle HTTP Server running on a Windows 2003 server and Oracle Database running on Sun Solaris machine.

            So do i need to change Oracle 10g HTTP Server? do i need to install Oracle 11g HTTP SErver?

            Please let me know if my question is not clear.

            Thanks in Advance.
            • 3. Re: Oracle APEX 4.2 and Oracle 11g HTTP Server
              Kiran Pawar
              Hello Lakshmi,

              >
              I got your point but in our case HTTP Server and Oracle Database (APEX) running on different machines.

              Oracle HTTP Server running on a Windows 2003 server and Oracle Database running on Sun Solaris machine.

              So do i need to change Oracle 10g HTTP Server? do i need to install Oracle 11g HTTP SErver?

              Please let me know if my question is not clear.
              >

              <ul><li>
              I got your point but in our case HTTP Server and Oracle Database (APEX) running on different machines.
              Did I missed something?
              You should have mentioned this additional information in the original question itself.
              </li>
              <li>
              Oracle HTTP Server running on a Windows 2003 server and Oracle Database running on Sun Solaris machine.
              As long as [url http://docs.oracle.com/cd/E37097_01/doc/install.42/e35123/otn_install.htm#BHAFJJDA]dads.conf is configured correctly there should not be a problem with this.
              From Original question:
              We are having Oracle APEX 3.1 version on Oracle 10g Database and Oracle 10g HTTP Server as web server in our organization.
              How did this setup of APEX worked?(i.e. on different machines)
              If you still have doubt about this you can do the setup and find out before upgrading.
              </li>
              <li>
              So do i need to change Oracle 10g HTTP Server? do i need to install Oracle 11g HTTP SErver?
              This question is answered in the above post. As long as you fulfill the [url http://docs.oracle.com/cd/E37097_01/doc/install.42/e35123/pre_require.htm#CFHIIJBE]HTTP Server Requirements for APEX 4.2 (Also we are discussing this long about only Oracle 10g HTTP Server but which version?)
              </li></ul>

              Hope now I am more clear!
              Regards,
              Kiran
              • 4. Re: Oracle APEX 4.2 and Oracle 11g HTTP Server
                Patrick Wolf-Oracle
                Hi Lakshmi,

                you can still use Oracle 10G HTTP server with APEX 4.2, there is no need to upgrade.
                But you might want to read http://joelkallman.blogspot.co.uk/2008/01/oracle-http-server-apache-20-and.html about reasons why it's a good idea to upgrade to OHS 11G.

                Regards
                Patrick
                -----------
                My Blog: http://www.inside-oracle-apex.com
                APEX Plug-Ins: http://apex.oracle.com/plugins
                Twitter: http://www.twitter.com/patrickwolf
                • 5. Re: Oracle APEX 4.2 and Oracle 11g HTTP Server
                  user525629
                  Hi Patrick/Kiran,

                  Thanks for your reply.

                  Partric: I will go through the blog you mentioned and will decide whether to upgrade for Oracle 10G or not.

                  Regards,
                  Lakshmi