Databases Reference
In-Depth Information
Disadvantages to installing on different machines are
•
Additional licensing may be required.
•
Increased network latency.
Okay, so now the OHS is installed (after you followed the Installation wizard), what now? Well,
assuming you already have your database and Oracle APEX installed, you need to configure the OHS to
be able to connect to your database, which we will cover in the next section.
Configuring the OHS
Since the OHS is based on the Apache HTTP Server, all of the configuration is done via configuration
files; there is no native GUI interface to the configuration, although there are various third-party tools
that will make this easier for you, such as ApacheConf (
http://www.apache-gui.com
) and WebMin
(
http://www.webmin.com/
).
As I mentioned, I'm a Unix guy and I think there's no better way to learn the different configuration
options available than by looking at the configuration files manually, although I have been known to use
GUIs from time to time (usually when I forget exactly what file a particular option is in).
So the first thing you need to do is configure the
mod plsql
handler to connect to your database. You
can do this by editing the
DADS.CONF
file (named after Database Access Descriptor) which is located in
$ORACLE HOME/ohs/modplsql/conf
(where
$ORACLE HOME
represents the directory you installed the OHS
into).
Listing 1-2 shows the typical contents of a basic
DADS.CONF
file.
Listing 1-2.
DADS.CONF File
# ============================================================================
# mod plsql DAD Configuration File
# ============================================================================
# 1. Please refer to dads.README for a description of this file
# ============================================================================
# Note: This file should typically be included in your plsql.conf file with
# the "include" directive.
# Hint: You can look at some sample DADs in the dads.README file
# ============================================================================
Alias /i/ "/home/ohs/apex4/images/"
<Location /pls/apex>
Order deny,allow
PlsqlDocumentPath docs
AllowOverride None
PlsqlDocumentProcedure wwv flow file mgr.process download
PlsqlDatabaseConnectString localhost:1521:dbtest ServiceNameFormat
PlsqlNLSLanguage AMERICAN AMERICA.AL32UTF8
PlsqlAuthenticationMode Basic
SetHandler pls handler
PlsqlDocumentTablename wwv flow file objects$
PlsqlDatabaseUsername APEX PUBLIC USER
