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 for Oracle Database 12c

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 Upgrading to Application Express Release 4.2.1 or Later
• 1.4 About the Oracle Application Express Runtime Environment
• 1.5 About Choosing a Web Listener
  • 1.5.1 About Oracle REST Data Services and Oracle HTTP Server with mod_plsql
  • 1.5.2 About the Embedded PL/SQL Gateway
  • 1.5.3 Selecting a Web Listener in an Oracle RAC Environment
• 1.6 Available Installation Scenarios
  • 1.6.1 Installing from the Database and Configuring Oracle REST Data Services
  • 1.6.2 Installing from the Database and Configuring the Embedded PL/SQL Gateway
  • 1.6.3 Installing from the Database and Configuring the Oracle HTTP Server

2 Oracle Application Express Installation Requirements

• 2.1 Oracle Database Requirements
  • 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 Utilizing the Multitenant Architecture

• 3.1 Understanding Installation Choices in Oracle Database 12c
  • 3.1.1 Uninstalling Application Express from a CDB
  • 3.1.2 Installing Application Express Locally in a PDB
  • 3.1.3 Reinstalling Application Express into a CDB
• 3.2 Plugging in a PDB When Application Express is Installed in the Root Container
  • 3.2.1 Scenario 1: Plug-in Non-CDB with Oracle Application Express
  • 3.2.2 Scenario 2: Plug-in PDB with a Common Application Express from Another CDB
  • 3.2.3 Scenario 3: Plug-in PDB with a Local Application Express from Another CDB
  • 3.2.4 Scenario 4: Plug-in Non-CDB or PDB with No Application Express
  • 3.2.5 About Incompatible Application Express Versions
• 3.3 Plugging in a PDB When Application Express Is Not in the Root Container of the Target CDB
  • 3.3.1 Scenario 1: Plug-in a Non-CDB with Application Express
  • 3.3.2 Scenario 2: Plug-in PDB with Common Application Express from Another CDB
  • 3.3.3 Scenario 3: Plug-in PDB with a Local Application Express from Another CDB
  • 3.3.4 Scenario 4: Plug-in a Non-CDB or PDB with No Application Express

4 Configuration Tasks When Installing from the Database

• 4.1 About Patching Oracle Application Express
• 4.2 Recommended Pre-installation Tasks
• 4.3 Choosing a Web Listener
• 4.4 Installing from the Database and Configuring Oracle REST Data Services
  • 4.4.1 Install the Oracle Database and Complete Preinstallation Tasks
  • 4.4.2 Download and Install Oracle REST Data Services
  • 4.4.3 Configure RESTful Services
  • 4.4.4 Enable Network Services in Oracle Database 12c
  • 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 Create a Workspace and Add Oracle Application Express Users
• 4.5 Installing from the Database and Configuring the Embedded PL/SQL Gateway
  • 4.5.1 Install the Oracle Database and Complete Pre-installation Tasks
  • 4.5.2 Load Resources in the XDB Repository
  • 4.5.3 Configure the Embedded PL/SQL Gateway
  • 4.5.4 Enable Network Services in Oracle Database 12c
  • 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 Configuring the SHARED_SERVERS Parameter
  • 4.5.9 Create a Workspace and Add Oracle Application Express Users
• 4.6 Installing from the Database and Configuring the Oracle HTTP Server
  • 4.6.1 Install the Oracle Database and Complete Pre-installation Tasks
  • 4.6.2 Configure Oracle HTTP Server Distributed with Oracle Database 12c
  • 4.6.3 Enable Network Services in Oracle Database 12c
  • 4.6.4 Security Considerations
  • 4.6.5 About Running Oracle Application Express in Other Languages
  • 4.6.6 About Managing JOB_QUEUE_PROCESSES
  • 4.6.7 About Obfuscating PlsqlDatabasePassword Parameter
  • 4.6.8 Create a Workspace and Add Oracle Application Express Users
• 4.7 Post Installation Tasks for Upgrade Installations
  • 4.7.1 Remove Prior Oracle Application Express Installations
  • 4.7.2 Fix Invalid ACL in Oracle Database 11g Release 1 (11.1) and Later
• 4.8 About the Oracle Application Express Runtime Environment
  • 4.8.1 Convert a Runtime Environment to a Full Development Environment - Oracle Database 12c Non-CDB
  • 4.8.2 Convert a Runtime Environment to a Full Development Environment - Oracle Database 12c Multitenant Architecture
  • 4.8.3 Convert a Full Development Environment to a Runtime Environment - Oracle Database 12c Non-CDB
  • 4.8.4 Convert a Full Development Environment to a Runtime Environment - Oracle Database 12c Multitenant Architecture

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 Removing Oracle Application Express from the Database
• A.4 Images Displaying Incorrectly in Oracle Application Express
• A.5 Page Protection Violation

Index