Current Position:Home > APEX and Oracle HTTP server

APEX and Oracle HTTP server

Update:12-10Source: network consolidation
Advertisement
Scenario
We are considering using APEX with Oracle 10g. However, we don't have Oracle application server.At the same time we do not want to use the Oracle HTTP server(OHS) on the database server. The propsed application intend to use by approx. 5000 users
Questions
As APEX requires just OHS and mod_plsql plugin,
1. Can we install just Oracle HTTP server and mod_plsql on standalone server? Which CD need to be used?
2. Can OHS can be licensed separately as Oracle Internet application server(Enterprise Edition) based on processor licensing is expensive and not affordable.However, there are other options like Standard Edition and Standard Edition One as well but do not require any other options except OHS and mod_plsql plugin.Hence, what is the cost effective option to have OHS and mod_plsql as a middle tier component to deploy APEX applications
Thanks in advance

The Best Answer

Advertisement
All,
I'm by no means a security expert, but I don't think this is a best practice. I think the best practice is to use two HTTP servers: one in the DMZ and one on the DB server. The one in the DMZ can be a standard Apache install - it acts as a proxy server and does not need mod_plsql. The second should be OHS. This configuration allows you to block ports that are usually used to communicate with the DB from the server in the DMZ.
Did I get that right or am I way off?
Regards,
Dan
http://danielmcghan.us
http://sourceforge.net/projects/tapigen
http://sourceforge.net/projects/plrecur
You can reward this reply by marking it as either Helpful or Correct ;-)
  • Error starting up ApEx's Oracle HTTP server Update:12-10

    Hello. I have just configured a brand new Oracle HTTP server on a brand new ApEx database. When I try to start the server, it doesn't start and I see errors in the log files. dads.conf in Apache/modplsql/conf directory: Alias /i/ "/u01/app/oracle/pro

  • APEX and Oracle HTTP server Update:12-10

    Scenario We are considering using APEX with Oracle 10g. However, we don't have Oracle application server.At the same time we do not want to use the Oracle HTTP server(OHS) on the database server. The propsed application intend to use by approx. 5000

  • APEX without Oracle HTTP Server 10gR2 Update:11-30

    Guys, I know that you can run APEX in Oracle XE without requiring to install an HTTP server. But I have heard that the same is now true if you are using Oracle 10gR2. Is this the case and if it is can you answer the following questions : a) How is it

  • Apex Listener vs. Oracle Application Server... advantages? Update:10-11

    Are there advantages to installing Apex Listener over using an existing Oracle Application Server instance to serve Apex applications? We have an existing application server instance in production. Would introducing Apex Listener and the extra overhe

  • Where is the Oracle Application Server for Apex 3.2.1? Update:10-11

    Hi, I feel ashamed asking this, but I want to know where to download the Application Server for Apex 3.2.1. Apex is installed in a DataBase 10gR1 and the O.S. where I will install the Application Server is RedHat I think it is here http://www.oracle.