8i | 9i | 10g | 11g | 12c | 13c | 18c | 19c | 21c | 23c | Misc | PL/SQL | SQL | RAC | WebLogic | Linux
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.
$FR_INST/config/OHS/ohs1/mod_plsql/dads.conf
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 </Location>
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 </Location>
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.
- http://myserver:7001/em
Perform the following operations.
- In the tree on the left, expand the "Web Tier" node and click on the "ohs1" node.
- In the right-hand pane, click on the "Oracle HTTP Server" dropdown in the top-left.
- Select "Administration > Advanced Configuration".
- In the "Select File" dropdown list, select "dads.conf" and click the "Go" button.
- Edit the contents of the "dads.conf" file as specified in the previous section. When finished, click the "Apply" Button. Changes will not take effect until you restart Apache.
- In the right-hand pane, click on the "Oracle HTTP Server" dropdown in the top-left.
- Select "Control > Restart" and click the "Restart" button on the subsequent confirmation popup.
- Once the restart is complete, click the "Close" button.
The change is now complete.
For more information see:
Hope this helps. Regards Tim...