Contents

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Related Documents
• Conventions
• Third-Party License Information

1 Oracle Application Express Installation Overview

• 1.1 Overview of the Installation Process
• 1.2 Upgrading from a Previous Version of Oracle Application Express
• 1.3 About the Oracle Application Express Runtime Environment
• 1.4 About Choosing an HTTP Server
  • 1.4.1 About Oracle HTTP Server and mod_plsql
  • 1.4.2 About the Embedded PL/SQL Gateway
  • 1.4.3 Selecting an HTTP Server in an Oracle RAC Environment
• 1.5 Available Installation Scenarios
  • 1.5.1 Scenario 1: Downloading from OTN and Configuring the Embedded PL/SQL Gateway
  • 1.5.2 Scenario 2: Downloading from OTN and Configuring Oracle HTTP Server
  • 1.5.3 Scenario 3: Installing from the Database and Configure the Embedded PL/SQL Gateway
  • 1.5.4 Scenario 4: Installing from the Database and Configure Oracle HTTP Server

2 Oracle Application Express Installation Requirements

• 2.1 Oracle Database Requirement
  • 2.1.1 Oracle JVM Requirement
  • 2.1.2 Checking the shared_pool_size of the Target Database
• 2.2 Browser Requirement
• 2.3 HTTP Server Requirements
• 2.4 Disk Space Requirement
• 2.5 Oracle XML DB Requirement
• 2.6 Oracle Text Requirement
• 2.7 PL/SQL Web Toolkit

3 Downloading from Oracle Technology Network

• 3.1 Recommended Pre-installation Tasks
• 3.2 Choosing an HTTP Server
• 3.3 Downloading from OTN and Configuring the Embedded PL/SQL Gateway
  • 3.3.1 Install the Oracle Database and Complete Pre-installation Tasks
  • 3.3.2 Download and Install Oracle Application Express
  • 3.3.3 Change the Password for the ADMIN Account
  • 3.3.4 Restart Processes
  • 3.3.5 Configure the Embedded PL/SQL Gateway
  • 3.3.6 Enable Network Services in Oracle Database 11g
  • 3.3.7 Enable Indexing of Online Help in Oracle Database 11gR2 and Higher
  • 3.3.8 Security Considerations
  • 3.3.9 About Running Oracle Application Express in Other Languages
  • 3.3.10 About Managing JOB_QUEUE_PROCESSES
  • 3.3.11 Configuring the SHARED_SERVERS Parameter
  • 3.3.12 Create a Workspace and Add Oracle Application Express Users
• 3.4 Downloading from OTN and Configuring Oracle HTTP Server
  • 3.4.1 Install the Oracle Database and Complete Pre-installation Tasks
  • 3.4.2 Download and Install Oracle Application Express
  • 3.4.3 Change the Password for the ADMIN Account
  • 3.4.4 Restart Processes
  • 3.4.5 Configure Oracle HTTP Server Distributed with Oracle Database 11g or Oracle Application Server 10g
  • 3.4.6 Enable Network Services in Oracle Database 11g
  • 3.4.7 Enable Indexing of Online Help in Oracle Database 11gR2 and Higher
  • 3.4.8 Security Considerations
  • 3.4.9 About Running Oracle Application Express in Other Languages
  • 3.4.10 About Managing JOB_QUEUE_PROCESSES
  • 3.4.11 About Obfuscating PlsqlDatabasePassword Parameter
  • 3.4.12 Create a Workspace and Add Oracle Application Express Users
• 3.5 Post Installation Tasks for Upgrade Installations
  • 3.5.1 Remove Prior Oracle Application Express Installations
  • 3.5.2 Fix Invalid ACL in Oracle Database 11g
• 3.6 About the Oracle Application Express Runtime Environment
  • 3.6.1 Converting a Runtime Environment to a Full Development Environment
  • 3.6.2 Converting a Full Development Environment to a Runtime Environment

4 Configuration Tasks When Installing from the Database

• 4.1 About Patching Oracle Application Express
• 4.2 Recommended Pre-installation Tasks
• 4.3 Choosing an HTTP Server
• 4.4 Installing from the Database and Configure the Embedded PL/SQL Gateway
  • 4.4.1 Install the Oracle Database and Complete Pre-installation Tasks
  • 4.4.2 Configure the Embedded PL/SQL Gateway
  • 4.4.3 Enable Network Services in Oracle Database 11g
  • 4.4.4 Enable Indexing of Online Help in Oracle Database 11gR2 and Higher
  • 4.4.5 Security Considerations
  • 4.4.6 About Running Oracle Application Express in Other Languages
  • 4.4.7 About Managing JOB_QUEUE_PROCESSES
  • 4.4.8 Configuring the SHARED_SERVERS Parameter
  • 4.4.9 Create a Workspace and Add Oracle Application Express Users
• 4.5 Installing from the Database and Configure Oracle HTTP Server
  • 4.5.1 Install the Oracle Database and Complete Pre-installation Tasks
  • 4.5.2 Configure Oracle HTTP Server Distributed with Oracle Database 11g or Oracle Application Server 10g
  • 4.5.3 Enable Network Services in Oracle Database 11g
  • 4.5.4 Enable Indexing of Online Help in Oracle Database 11gR2 and Higher
  • 4.5.5 Security Considerations
  • 4.5.6 About Running Oracle Application Express in Other Languages
  • 4.5.7 About Managing JOB_QUEUE_PROCESSES
  • 4.5.8 About Obfuscating PlsqlDatabasePassword Parameter
  • 4.5.9 Create a Workspace and Add Oracle Application Express Users
• 4.6 Post Installation Tasks for Upgrade Installations
  • 4.6.1 Remove Prior Oracle Application Express Installations
  • 4.6.2 Fix Invalid ACL in Oracle Database 11g
• 4.7 About the Oracle Application Express Runtime Environment
  • 4.7.1 Convert a Runtime Environment to a Full Development Environment
  • 4.7.2 Convert a Full Development Environment to a Runtime Environment

A Oracle Application Express Troubleshooting

• A.1 Reviewing a Log of an Installation Session
• A.2 Verifying the Validity of an Oracle Application Express Installation
• A.3 Cleaning Up After a Failed Installation
  • A.3.1 Reverting to a Previous Release After a Failed Upgrade Installation
  • A.3.2 Removing Oracle Application Express from the Database
• A.4 Images Displaying Incorrectly in Oracle Application Express
• A.5 Online Help Not Working
  • A.5.1 Online Help Not Working When Using a Virtual Host
  • A.5.2 Problems Searching Online Help

B Configuring Oracle HTTP Server Distributed with Oracle9i Release 2

• B.1 Recommended Pre-installation Tasks
• B.2 Downloading from OTN and Configuring Oracle HTTP Server
  • B.2.1 Install the Oracle Database and Complete Pre-installation Tasks
  • B.2.2 Download and Install the Software
  • B.2.3 Change the Password for the ADMIN Account
  • B.2.4 Restart Processes
  • B.2.5 Configure Oracle HTTP Server
  • B.2.6 About Enabling Network Services in Oracle Database 11g
  • B.2.7 Security Considerations
  • B.2.8 About Running Oracle Application Express in Other Languages
  • B.2.9 About Managing JOB_QUEUE_PROCESSES
  • B.2.10 About Obfuscating PlsqlDatabasePassword Parameter
  • B.2.11 Create a Workspace and Add Oracle Application Express Users
• B.3 Install the Database and Configure Oracle HTTP Server
  • B.3.1 Install the Oracle Database and Complete Pre-installation Tasks
  • B.3.2 Configure Oracle HTTP Server Distributed with Oracle Database Release 9.0.3
  • B.3.3 About Enabling Network Services in Oracle Database 11g
  • B.3.4 Security Considerations
  • B.3.5 About Running Oracle Application Express in Other Languages
  • B.3.6 About Managing JOB_QUEUE_PROCESSES
  • B.3.7 About Obfuscating PlsqlDatabasePassword Parameter
  • B.3.8 Create a Workspace and Add Oracle Application Express Users

C Third-Party License

• C.1 Apache License

D Accessibility in Oracle Application Express

• D.1 General Violations
• D.2 Tips for Accessing Form Pages in Oracle Application Express
  • D.2.1 Understanding the Structure of a Page
  • D.2.2 Using the Tasks Links on a Page
  • D.2.3 Accessing Help Text
  • D.2.4 Dealing with Raised Validations
• D.3 Issues with Interactive Report Regions
• D.4 Accessing Interactive Report Regions Using a Keyboard
  • D.4.1 Searching an Interactive Report
  • D.4.2 Specifying Rows to Display
  • D.4.3 Managing Bulk Updates
  • D.4.4 Utilizing Drill Down Links
  • D.4.5 Editing Existing Filters

Index