Contents

Title and Copyright Information

Preface

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

Changes in This Release

• Changes in Oracle Application Express Release 4.2

1 Oracle Application Express Installation Overview

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

2 Oracle Application Express Installation Requirements

• 2.1 Oracle Database Requirement
  • 2.1.1 Checking the shared_pool_size of the Target Database
• 2.2 Browser Requirements
• 2.3 Web Listener Requirements
• 2.4 Disk Space Requirement
• 2.5 Oracle XML DB Requirement
• 2.6 PL/SQL Web Toolkit

3 Downloading from Oracle Technology Network

• 3.1 Recommended Pre-installation Tasks
• 3.2 Choosing a Web Listener
• 3.3 Downloading from OTN and Configuring Oracle Application Express Listener
  • 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 APEX_PUBLIC_USER Account
  • 3.3.6 Download and Install Oracle Application Express Listener
  • 3.3.7 Configure RESTful Services
  • 3.3.8 Enable Network Services in Oracle Database 11g
  • 3.3.9 Security Considerations
  • 3.3.10 About Managing JOB_QUEUE_PROCESSES
  • 3.3.11 About Developing Oracle Application Express in Other Languages
  • 3.3.12 Create a Workspace and Add Oracle Application Express Users
• 3.4 Downloading from OTN and Configuring the Embedded PL/SQL Gateway
  • 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 Configure the Embedded PL/SQL Gateway
  • 3.4.5 Enable Network Services in Oracle Database 11g
  • 3.4.6 Security Considerations
  • 3.4.7 About Managing JOB_QUEUE_PROCESSES
  • 3.4.8 About Running Oracle Application Express in Other Languages
  • 3.4.9 Configuring the SHARED_SERVERS Parameter
  • 3.4.10 Create a Workspace and Add Oracle Application Express Users
• 3.5 Downloading from OTN and Configuring Oracle HTTP Server
  • 3.5.1 Install the Oracle Database and Complete Pre-installation Tasks
  • 3.5.2 Download and Install Oracle Application Express
  • 3.5.3 Change the Password for the ADMIN Account
  • 3.5.4 Restart Processes
  • 3.5.5 Configure Oracle HTTP Server Distributed with Oracle Database 11g or Oracle Application Server 10g
  • 3.5.6 Enable Network Services in Oracle Database 11g
  • 3.5.7 Security Considerations
  • 3.5.8 About Managing JOB_QUEUE_PROCESSES
  • 3.5.9 About Running Oracle Application Express in Other Languages
  • 3.5.10 About Obfuscating PlsqlDatabasePassword Parameter
  • 3.5.11 Create a Workspace and Add Oracle Application Express Users
• 3.6 Post Installation Tasks for Upgrade Installations
  • 3.6.1 Remove Prior Oracle Application Express Installations
  • 3.6.2 Fix Invalid ACL in Oracle Database 11g
• 3.7 Performance Optimization Tasks
• 3.8 About the Oracle Application Express Runtime Environment
  • 3.8.1 Converting a Runtime Environment to a Full Development Environment
  • 3.8.2 Converting 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 Page Protection Violation

Index