BC remote Oracle DBA - Call (800) 766-1884  
Oracle Consulting Oracle Training Development

Remote DBA

Remote DBA Plans  

Remote DBA Service

Remote DBA RAC

   
Remote DBA Oracle Home
Remote DBA Oracle Training
Remote DBA SQL Tuning Consulting
Remote DBA Oracle Tuning Consulting
Remote DBA Data Warehouse Consulting
Remote DBA Oracle Project Management
Remote DBA Oracle Security Assessment
Remote DBA Unix Consulting
Burleson Books
Burleson Articles
Burleson Web Courses
Burleson Qualifications
Oracle Links
Remote DBA Oracle Monitoring
Remote DBA Support Benefits
Remote DBA Plans & Prices
Our Automation Strategy
What We Monitor
Oracle Apps Support
Print Our Brochure
Contact Us (e-mail)
Oracle Job Opportunities
Oracle Consulting Prices





   

 

 

 

Remote DBA services

Remote DBA Support

Remote DBA RAC

Remote DBA Reasons

Remote Oracle Tuning

Remote DBA Links

Oracle DBA Support

Oracle DBA Forum

Oracle Disaster

Oracle Training

Oracle Tuning

Oracle Training

 Remote DBA SQL Server

Remote MSSQL Consulting

Oracle DBA Hosting

Oracle License Negotiation

 

 


 

 

 

 

   
  Oracle Tips by Burleson

Database Access Descriptor

The DAD is a set of instructions for Oracle HTTP Server and the mod_plsqlextension module.  Together, they will use the information in the DAD for connections to the database.

Please note that the HTML DB documentation refers to a file named marvel.conf in many places.  For the purposes of this book, any time the documentation mentions editing the marvel.conf, this reference will apply to the dads.conf file.

The name of the configuration file is dads.confand is located in the following directory:

            Windows: ORACLE_HOME\Apache\modplsql\conf

            Linux: ORACLE_HOME/Apache/modplsql/conf

The following is an example of a dads.conf file:

Alias /i/ "c:\oracle\product\10.2.0\ohs\Apache\Apache\images/"
<Location /pls/hdb20>
    SetHandler pls_handler
    Order deny,allow
    Allow from all
    AllowOverride                  None
    PlsqlDatabaseUsername          HTMLDB_PUBLIC_USER
    PlsqlDatabasePassword          htmldb
    PlsqlDatabaseConnectString     localhost:1522:hdb20
ServiceNameFormat
    PlsqlAuthenticationMode        Basic
    PlsqlDefaultPage               htmldb
    PlsqlDocumentTablename
         wwv_flow_file_objects$
    PlsqlDocumentPath              docs
    PlsqlDocumentProcedure        
wwv_flow_file_mgr.process_download
    PlsqlNLSLanguage               AMERICAN_AMERICA.AL32UTF8
</Location>
 

When configuring the DAD on Linux, the only change to the DAD in the above example is for the location of the images virtual directory as shown here.

Alias /i/ "/u01/app/oracle/product/10.2.0/ohs/Apache/Apache/images/"

A few of the items in the DAD configuration are explained in Table 2.3 below, but it is a good idea to read the dads.README file located in the same directory as the dads.conf configuration file.  It will explain all the configuration parameters in greater detail.

PARAMETER

DESCRIPTION

Alias

This is set to /i/ and references the location where you installed the images earlier in this chapter.  When HTML is rendered to your browser this is the virtual directory for the location of images, cascading style sheets, java scripts, etc.

<Location /pls/hdb20>

This is the name of the virtual path that will be used to access your HTML DB web application.

PlsqlDatabaseConnectString

This is in the format of server.domain:port:sid.  Here we used the name httpserver, but if you have a local database you can use localhost for the server.domain part.  Then provide the port number the database is listening on and service name (sid).  If your database is on a server you may need your Remote DBA to provide you with the necessary information.

PlsqlDatabaseUsername

This is the username that will be used by the mod_plsqlextension module for connecting to the database.  Every connection, regardless of the login id and password provided will be connected to the database with this username.

PlsqlDatabasePassword

This should be set to the same password as was provided during the installation of HTML DB.  It is the password given to the schema owners of the HTML DB objects and HTMLDB_PUBLIC_USER.

Table 2.3:  Example DAD configuration parameters and their descriptions

REMEMBER: After configuring the DAD, the HTTP Server process must be restarted as described in Chapter 1.


The above book excerpt is from:

Easy HTML-DB Oracle Application Express

Create Dynamic Web Pages with OAE

ISBN 0-9761573-1-4   

Michael Cunningham & Kent Crotty

http://www.rampant-books.com/book_2005_2_html_db.htm

Remote DBA Service
 

Oracle Tuning Book

 

Advance SQL Tuning Book 

BC Oracle support

Oracle books by Rampant

Oracle monitoring software

 

 

 

 

 

 

BC Remote Oracle Support

Remote DBA

Remote DBA Services

Copyright © 1996 -  2013 by Burleson. All rights reserved.

Oracle® is the registered trademark of Oracle Corporation.