How To Create Virtual Host Specific Application Locations - Using PL/SQL DADs as Example
(Doc ID 312693.1)
Last updated on APRIL 07, 2022
Applies to:Oracle HTTP Server - Version 126.96.36.199 to 10.1.2.3.0 [Release AS10g to AS10gR2]
Oracle HTTP Server - Version 188.8.131.52.0 and later
Information in this document applies to any platform.
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.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!