How To Create Virtual Host Specific Application Locations - Using PL/SQL DADs as Example (Doc ID 312693.1)

Last updated on APRIL 09, 2024

Applies to:

Goal

Describe steps necessary to create PL/SQL DADs that are specific to a 
virtual host to be used with an version of the Oracle HTTP Server (which
contains mod_plsql).  This should work with any version which 
allows apache-based configuration within a dads.conf  container.
There may be many ways to configure the same or slightly different 
functionality, but the below steps offer the most straight forward approach
without re-arranging or confusing the overall configuration.

The reason this is important for administrators is because there may be two 
separate applications which may be differentiated by the virtual names,
yet it is not desired to have one application user access the other(s). The
mod_plsql module and locations associated are by default available to the
server-wide configuration.

These same steps can be applied towards any module location, where it is desired
to make a location specific to a VirtualHost. Please read and understand all the 
options before following. These instructions outline the steps performed to 
test this configuration, while other options may still exist.


Example Desired Functionality:
------------------------------

VirtualHost 1 : www.yourname.com
PL/SQL DAD 1  : /pls/only-www
Valid URL     : "http://www.yourname.com/pls/only-www/<anyPackage.procedure>"

VirtualHost 2 : www2.yourname.com
PL/SQL DAD 2  : /pls/only-www2
Valid URL     : http://www2.yourname.com/pls/only-www2/<anyPackage.procedure>

Goals:
1. If wrong virtual host is used, or if a DAD already associated to a specific
virtual host is requested, then it should redirect to a custom error page
for desired user interface.

2. Keep integrity of original installation, keeping current configuration in place, 
only adding to it to provide specific functionality.

Solution