8i | 9i | 10g | 11g | 12c | 13c | 18c | 19c | 21c | 23ai | Misc | PL/SQL | SQL | RAC | WebLogic | Linux

Home » Articles » 11g » Here

WebLogic : Database Access Descriptor (DAD) Configuration

The Oracle HTTP Server, which forms the WebLogic Web Tier, is capable of supporting Database Access Descriptors (DADs). This article describes how they can be set up manually and using Enterprise Manager.

Manual DAD Setup

DADs are configured in the "dads.conf" file, which can be found in the following location in the WebLogic web tier.


You can amend or add entries to the file by copying an existing entry. Typically there are two types of DAD. The first type are those without a password for use with web services. Here is an example of one of those.

<Location /mydad>
    Header set X-UA-Compatible ?IE=EmulateIE8?
    SetHandler pls_handler
    Order allow,deny
    Allow from All
    PlsqlAuthenticationMode Basic
    PlsqlDatabaseConnectString mydb TNSFormat

The second type are those with a database connection, for use with applications that require a permanent connection, like APEX. Here is an example of those.

<Location /apex>
   Order deny,allow
   PlsqlDocumentPath docs
   AllowOverride None
   PlsqlDocumentProcedure         wwv_flow_file_mgr.process_download
   PlsqlDatabaseConnectString     mydb TNSFormat
   PlsqlNLSLanguage               AMERICAN_AMERICA.AL32UTF8
   PlsqlAuthenticationMode        Basic
   SetHandler                     pls_handler
   PlsqlDocumentTablename         wwv_flow_file_objects$
   PlsqlDatabaseUsername          APEX_PUBLIC_USER
   PlsqlDefaultPage               apex
   PlsqlDatabasePassword          mypassword
   PlsqlRequestValidationFunction wwv_flow_epg_include_modules.authorize
   Allow from all

Once you've amended and saved the file, you will need to restart Apache. Remember, if you want it to be a graceful restart, don't stop and start it.

# Graceful restart.
$FR_INST/bin/opmnctl restartproc process-type=OHS

# Hard restart
$FR_INST/bin/opmnctl stopproc process-type=OHS
$FR_INST/bin/opmnctl startproc process-type=OHS 

The DAD should now be available from *any* URL pointing to the web tier.

Enterprise Manager DAD Setup

To create a DAD from Enterprise Manager, first log on to the Enterprise Manager console using a URL like the following.

Perform the following operations.

The change is now complete.

For more information see:

Hope this helps. Regards Tim...

Back to the Top.