Should DBAs be overly concerned about Oracle Application Express (APEX)? The answer to this question is YES! APEX is used for rapid application development (RAD) to create web enabled applications that run against an Oracle database.
The three main reasons that DBAs need to be concerned are first, it must be installed into the database, http server access to the database must be enabled for APEX based applications to run and there are several privileges granted to the workspace administrator accounts that the DBA should be aware of. Not to mention, that the DBA needs to be aware of space requirements for each of the workspaces that support the applications designed using Oracle Application Express.
Choosing the HTTP Server Access
The first decision to make is to determine the kind of HTTP Server Access. The installation steps vary depending on which access method is chosen.
Application Express has three options (if installed into an Oracle 11g database) for configuring the required HTTP Server Access to the database; the Oracle HTTP Server with mod_plsql, the Oracle Application Express Listener or the Embedded PL/SQL Gateway. All of these methods are used to establish communications between the web server and the APEX objects in the database using a SQL*Net connection.
Read the full article at Database Journal:
Oracle Application Express - A DBA Perspective to
learn how to install and configure Oracle Application Express.
Back to DBAsupport.com
