Sitemap

Amicuk Programming Answers

APEX and Oracle HTTP server

2015-12-10   Views:516

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

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 replay 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 ;-)

Go to See the other 5 answers

Error starting up ApEx's Oracle HTTP server

Category:DefaultRelease time:2015-12-10Views:130

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[More]

APEX and Oracle HTTP server

Category:DefaultRelease time:2015-12-10Views:130

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[More]

APEX without Oracle HTTP Server 10gR2

Category:DefaultRelease time:-0001-11-30Views:130

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[More]

Apex Listener vs. Oracle Application Server... advantages?

Category:DefaultRelease time:2015-10-11Views:130

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[More]

Where is the Oracle Application Server for Apex 3.2.1?

Category:DefaultRelease time:2015-10-11Views:130

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.[More]

Oracle application server 10g and apex

Category:DefaultRelease time:2015-10-11Views:130

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[More]

Apex Installation On Oracle App Server Apache

Category:DefaultRelease time:-0001-11-30Views:130

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[More]

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

Category:DefaultRelease time:-0001-11-30Views:130

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[More]

Down Time for  Installing APEX 4.2.1 and oracle HTTP server?

Category:DefaultRelease time:-0001-11-30Views:130

Hi, all: I plan to install APEX 4.2.1 and oracle HTTP server on 10.2.0.4 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[More]

Do we need Oracle HTTP server to host Oracle Apex ?

Category:DefaultRelease time:-0001-11-30Views:130

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[More]

Installing Apex 4 on Oracle 11.2.0.3 with Oracle HTTP Server on WINDOWS

Category:DefaultRelease time:-0001-11-30Views:130

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[More]

Hot
My old pc quit working. Got a brand new pc and downloaded iTunes to backup my iPod touch. I got a message the iTunes will delete everything off my ipodtouch. I do not want all my songs deleted or my aps. So I had to stop sync and canceled my iPods up [More]
Write in English, passed the information written in Korean, not going to work well. Please read and interpreted 안녕하세요 저는 한국에 살고 있는 19살 고등학교에 다니고 있는 여학생입니다. 힘들게 부모님 설득하여 1년동안 모은 저의 용돈으로 아이팟 터치를 구매하였는데. 아이팟터치를 사고 1년도 안되서 리퍼만 3번을 받았습니다. 제가 2010년 2월달에 아이 [More]
I have a mac mini 2009, I am considering selling and getting an ATV2 to use, as I only use for streaming. Is the new interface for ATV2 the same as Front Row?I've got three new Apple TVs and the experience is MUCH better than Front Row. The UI is a b [More]
I have an electric drum kit that i would like to hook up to logic express and use the drum pads to trigger the sound fonts that are one logic already. is this possible? i can get a midi to usb interface to hook it up into logic, but then what? is the [More]
An icon that looks like a telephone sending messages to aliens in outer space just appeared on my menubar. When I click it, it has two menu items, the second is a link to "Open Network Preferences..." and the first is a disabled item that reads, [More]
Hi All, Does anyone know if it is possible to download Archivelink documents in mass? Say for example All documents of a particular ArchiveLink doc type... Thanks, NeilHi Neil, there is no standard functionality available for mass download. For a cus [More]
Dear Guru, I have one scenario where an employee; employee group have been wrongly assigned during Hiring PA40. The user has entered and assigned the employee group as Contract - Local instead of Contract - Foreigner in the Employee group field. Plea [More]
Here again Friends with an error message disallowing communication two serial interfaces. The interface and the line is up as you can see from the sh ip int s1/0 command but could not ping the second device because of this error. Serial1/0 is up, lin [More]
Hi, When we create user defined routine in lsmw. it ask for input parameter and out put parameter. after that it will create one  subroutine. But how to map input parameter  of sub routine with source field. thanks, JigarHi Jigar, when you have selec [More]
I have a one line conky that displays my Cpu usage, but I find in fairly annoying that evertime my Cpu item updates it shoves everything after it to the right or pulls it back to the left.  Was wondering in anyone knows of a way to insert a placehold [More]