Creating a mod_plsql DAD
If OHS/mod_plsql is part of the Oracle Application Server product, it is recommended that you use Oracle® Enterprise Manager (OEM) to create a DAD. Otherwise, perform the following steps to create a DAD:
1. Edit the DAD configuration file
2. Add a DAD where the DAD has the following format:
- The Oracle HTTP Server
<Location>directive which defines a virtual path used to access the PL/SQL Web Application.
- This directive begins enclosing a group of directives that apply to the named Location.
- For example, the directive
<Location /myapp>defines a virtual path called
/myappthat will be used to invoke a PL/SQL Web Application through a URL like
- Note: Older versions of mod_plsql were always mounted on a virtual path with a prefix of
/pls. This restriction is removed in newer versions but might still be a restriction imposed by some older PL/SQL applications.
- The Oracle HTTP Server
SetHandlerdirective which directs Oracle HTTP Server to enable mod_plsql to handle the request for the virtual path defined by the named Location
- Additional Oracle HTTP Server directives that are allowed in the context of a
Typically, the following directives are used:
Order deny,allow Allow from all AllowOverride None
- One or more mod_plsql specific directives.
PlsqlDatabaseUsername scott PlsqlDatabasePassword tiger PlsqlDatabaseConnectString orcl PlsqlAuthenticationMode Basic
- Closing </Location>
- An Oracle HTTP Server </Location> directive which closes the group of directives for the named Location, and defines a single DAD.
3. Save the edits
4. Obfuscate the DAD password by running the
"dadTool.pl" script located in
%ORACLE_HOME%/Apache/modplsql/conf. For instructions on performing the obfuscation, please refer to %ORACLE_HOME%/Apache/modplsql/conf/dadTool.README
If OHS/mod_plsql is part of the Oracle Application Server product, then issue
%ORACLE_HOME%/dcm/bin/dcmctl updateConfig -ct ohs
5. Restart the Oracle HTTP Server (OHS) for the configuration to take effect.
You can create additional DADs by defining other uniquely named Locations in dads.conf.
Here is an example of a typical PL/SQL application DAD
code><Location /plsqlapp> SetHandler pls_handler Order deny,allow Allow from all AllowOverride None PlsqlDatabaseUsername scott PlsqlDatabasePassword tiger PlsqlDatabaseConnectString orcl PlsqlAuthenticationMode Basic PlsqlDefaultPage scott.home PlsqlDocumentTablename scott.wwdoc_document PlsqlDocumentPath docs PlsqlDocumentProcedure scott.wwdoc_process.process_download </Location>
Some more sample DAD's used by other PL/SQL Web applications are available at: Sample DAD's for mod_plsql