Installation of Oracle HTTP Server for APEX [message #275948] |
Tue, 23 October 2007 08:34 |
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 |
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
|
|
|
|