APEX and Oracle HTTP server

December 10 304
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
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
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?
You can reward this reply by marking it as either Helpful or Correct ;-)
Error starting up ApEx's Oracle HTTP server

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

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

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?

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?

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.

Oracle application server 10g and apex

Hi allm Can someone show me a guide on how to use Oracle Application Server 10g with APEX. I'm currently using Oracle HTTP Server but decided to use OAS instead so that I can use the Report Server and the Oracle BI Publisher for the reports. I'm curr

Apex Installation On Oracle App Server Apache

Installation using an existing Apache server like on the Oracle Apps Server can be done as a replacement for the Apache that is installed with Apex but may require the installation of mod_plsql into Apache. If you need to do this, use the documentati

Can I use Oracle Report Server to print from APEX? How?

Hello, we have Oracle Application server, Oracle Report server and now we just installed APEX and doing a pilot project. Since we don't have BI Publisher, how can we use our Oracle Report server to print from apex report? Can it be done and if yes wh

Down Time for  Installing APEX 4.2.1 and oracle HTTP server?

Hi, all: I plan to install APEX 4.2.1 and oracle HTTP server on database. Is there any down time required during installation? I mean during installation, do I need to block users from accessing the database? Can they do their normal data en

Do we need Oracle HTTP server to host Oracle Apex ?

We are completely new to this Oracle Apex. Wanted to know the licensing part of it , before we get into it. I guess Oracle Apex is free as it comes with the Oracle database license. 1) Do we need some kind of HTTP server to host the Apex on the brows

Installing Apex 4 on Oracle with Oracle HTTP Server on WINDOWS

Has someone put together a cookbook on installing the above? I have tried following the documentation; but it is in dire need of updating. I have become quite confused as to how to piece together alll of the parts. Seemed much easier in 10.2... TIA!V

Can apex work without the oracle applications server? How?

My question is just what the title says. Can apex work without the Oracle applications server? I've heard it needs a web server to work but not necessarly the oracle applications server. Is it true? With ONLY apache installed can apex work on top of

Memory issues in oracle apex server ( Oracle HTTP Server )

Dear All, I want to resolve the memory problems in the oracle Apex . I have gone through some other forum thread , they are asked to change the memory in JAVA_OPT. Can you some one please help mr to resolve this issue ? Regards Dhanush.RSBH wrote: I

Oracle HTTP server with multiples apex instances

It is possible to have an Oracle HTTP server installed in a diferente machine, and apex Installed on databases there are in diferent machines? Or it would be necessary to install one HTTP server for each APEX instance? For instance: Machine 3 _______

How to configure Oracle HTTP server

Hi, I installed APEX 3.0 in Oracle database. I installed HTTP server from Oracle 10.2.0 database companion CD. The problem is I am not sure which conf file I need to modify as in the installation document, it only shows steps for how to conf

Can Oracle HTTP Server 2.0 be installed with Oracle App Server

Or I guess a related question is what version of apache comes with the latest App Server Patch Set ( We are running OAS and we are having issues with URLs that end in a number but which have query parameters at the end. E.g. ht

Virtual Directory Change from Oracle HTTP Server to Embedded PL/SQL Gateway

We finally upgraded from htmldb 1.6 to ApEx 3.1.2 late last year. This was in conjunction with setting up a new server and installing Oracle 11g DB, while our production DB is still 10g. During this install, I opted for the Embedded PL/SQL Gateway, w

Why i can't access apex on the unix server.

hi I have created an Apex successfully, and SQL> SELECT STATUS FROM DBA_REGISTRY WHERE COMP_ID = 'APEX'; STATUS VALID I can connect to to see the 'Oracle HTTP Server - Welcome ' page, however I can't connect http://192.168.3

Create PDF report with APEX and Oracle 11g doesn't work

Hi everyone, I have a problem with the downloading of PDF reports from APEX with Oracle 11g. When I try to download a PDF, Acrobat Reader says it can not open the file. I have done the same test in an environment with APEX and Oracle 10g and it works

Can you run Embedded PL/SQL Gateway and Oracle HTTP Server at the same time

Hi, I know this will sound a bit odd but their is a business case for asking this. Can you run APEX via the Embedded PL/SQL Gateway and the Oracle HTTP Server at the same time? Would their be any security/stability/etc issues I'd need to worry about?