Home » Developer & Programmer » Application Express, ORDS & MOD_PLSQL » Installation of Oracle HTTP Server for APEX
Installation of Oracle HTTP Server for APEX [message #275948] Tue, 23 October 2007 08:34 Go to next message
oraclechick
Messages: 33
Registered: February 2006
Member
Hi,

I have 2 Oracle 10g test databases on the same machine (Windows) and in the same Oracle Database Home. I want to install ILM Assistant in those 2 databases. For ILM Assistant, I also have to install Oracle Application Express for each database.
My question is, do I also have to install Oracle HTTP Server twice, for each APEX, or can both make use of one HTTP server?
If only 1 HTTP server can be used for more than one APEX, how do I configure the dads.conf file?
If I need to install HTTP server for every APEX, does each HTTP server have to be in a different Oracle Home (since they are all on the same machine)?
Thanks!
Re: Installation of Oracle HTTP Server for APEX [message #276004 is a reply to message #275948] Tue, 23 October 2007 11:11 Go to previous messageGo to next message
patrick_wolf
Messages: 11
Registered: August 2007
Location: Vienna, Austria
Junior Member
Hi,

you don't have to install two HTTP servers. You can use two DAD configurations to access the different databases.

1) Just copy the existing configuration

<Location /pls/apex>
Order deny,allow
...
PlsqlDatabaseConnectString host:port:service_name ServiceNameFormat
...
</Location>

2) change the text next to the <location ...>

for example to <Location /pls/prod/apex>

That's the URL you have to use to access your 2nd APEX instance. The web-server uses this URL to identify which DAD configuration it should take, so that it knows which database connect string it has to use.

3) Change the parameter

PlsqlDatabaseConnectString

to your other database.

Hope that helps
Patrick
----------------------------------------------------------------------------------------------------
My APEX Blog: http://inside-apex.blogspot.com
The ApexLib Framework: http://apexlib.sourceforge.net
The APEX Builder Plugin: http://sourceforge.net/projects/apexplugin/

[Updated on: Tue, 23 October 2007 11:12]

Report message to a moderator

Re: Installation of Oracle HTTP Server for APEX [message #276242 is a reply to message #276004] Wed, 24 October 2007 08:43 Go to previous message
oraclechick
Messages: 33
Registered: February 2006
Member
Thanks Patrick! I've got it working!
Previous Topic: data insertion through web page
Next Topic: Installation of Oracle HTTP Server on Solaris 10
Goto Forum:
  


Current Time: Thu Mar 28 10:49:29 CDT 2024