Table of Contents

• Title and Copyright Information
• Preface
  • Audience
  • Documentation Accessibility
  • Diversity and Inclusion
  • Related Documents
  • Conventions
  • Third-Party License Information
• 1 Changes in Release 22.1 for Oracle APEX Installation Guide
• 2 Oracle APEX Installation Requirements
  • 2.1 Oracle Database Requirements
    • 2.1.1 Checking the MEMORY_TARGET of the Target Database
    • 2.1.2 Checking the WORKAREA_SIZE_POLICY of the Target Database
  • 2.2 Browser Requirements
  • 2.3 Web Server Requirements
  • 2.4 Disk Space Requirement
  • 2.5 Oracle XML DB Requirement
• 3 Oracle APEX Installation Overview
  • 3.1 About Oracle APEX Architecture
  • 3.2 About Accessing Oracle APEX in Oracle Cloud
  • 3.3 Understanding the Installation Process
    • 3.3.1 About Planning Your Installation
    • 3.3.2 About Patch Sets
    • 3.3.3 About the Installation Scripts
    • 3.3.4 About Accessing Oracle APEX
    • 3.3.5 Requesting a Workspace from the Sign In Dialog
    • 3.3.6 Resetting Your Password from the Sign In Page
    • 3.3.7 Recovering Your Workspace Name
  • 3.4 About the Oracle APEX Runtime Environment
• 4 Upgrading from a Previous Oracle APEX Release
  • 4.1 About Release Numbering Conventions
  • 4.2 Sample Upgrade Scenarios
  • 4.3 Viewing the Oracle APEX Release Number
  • 4.4 Viewing the Oracle REST Data Services Release Number
  • 4.5 About Installing an Oracle APEX Release Included with the Oracle Database
  • 4.6 About Upgrading Existing Applications
  • 4.7 About Testing Requirements
  • 4.8 About Cleaning Up Your Environment
  • 4.9 About Reverting to a Previous Release
• 5 Utilizing the Multitenant Architecture in Oracle Database 12c or Later
  • 5.1 Understanding the Installation Choices
  • 5.2 Installing Oracle APEX into an Application Container
    • 5.2.1 About Application Containers
    • 5.2.2 Creating an Application Container
    • 5.2.3 Installing or Upgrading Oracle APEX in an Application Container
    • 5.2.4 Verifying the Application Container Installation
    • 5.2.5 Creating an Application Seed
    • 5.2.6 Creating an Application PDB from the Application Root Seed
    • 5.2.7 Configure HTTP Access to the Application PDB
  • 5.3 Installing Oracle APEX into Different PDBs
    • 5.3.1 Uninstalling Oracle APEX from a CDB
    • 5.3.2 Installing Oracle APEX Locally in a PDB
    • 5.3.3 Installing Oracle APEX into a CDB
  • 5.4 Plugging in a PDB When Oracle APEX Is Installed in the Root Container
    • 5.4.1 Scenario 1: Plug-in Non-CDB with Oracle APEX
    • 5.4.2 Scenario 2: Plug-in PDB with a Common APEX from Another CDB
    • 5.4.3 Scenario 3: Plug-in PDB with a Local Oracle APEX from Another CDB
    • 5.4.4 Scenario 4: Plug-in Non-CDB or PDB with No Oracle APEX
    • 5.4.5 Working with Incompatible Oracle APEX Versions
      • 5.4.5.1 Patching or Upgrading Oracle APEX in a CDB
      • 5.4.5.2 Patching or Upgrading Oracle APEX in a PDB
        • 5.4.5.2.1 Patching Oracle APEX in a PDB
        • 5.4.5.2.2 Upgrading Oracle APEX in a PDB
  • 5.5 Plugging in a PDB When Oracle APEX Is Not in the Root Container of the Target CDB
    • 5.5.1 Scenario 1: Plug-in a Non-CDB or PDB with Locally Installed APEX
    • 5.5.2 Scenario 2: Plug-in PDB with Common Oracle APEX from Another CDB
    • 5.5.3 Scenario 3: Plug-in PDB with a Local Oracle APEX from Another CDB
    • 5.5.4 Scenario 4: Plug-in a Non-CDB or PDB with No Oracle APEX
• 6 Installing and Configuring Oracle APEX and Oracle REST Data Services
  • 6.1 Performing Pre-installation Tasks for Oracle APEX
  • 6.2 About SQLcl Support
  • 6.3 Downloading and Installing Oracle APEX
    • 6.3.1 Installing Oracle APEX
    • 6.3.2 Creating or Updating Your Instance Administration Account
      • 6.3.2.1 What Is an Instance Administrator?
      • 6.3.2.2 About apxchpwd.sql
      • 6.3.2.3 Running apxchpwd.sql
    • 6.3.3 Restarting Processes
    • 6.3.4 Configuring the APEX_PUBLIC_USER Account
      • 6.3.4.1 About the APEX_PUBLIC_USER Account
      • 6.3.4.2 Unlocking the APEX_PUBLIC_USER Account
      • 6.3.4.3 Changing the Password for the APEX_PUBLIC_USER Account
      • 6.3.4.4 About Password Expiration in Oracle Database 11g and Later
    • 6.3.5 Configuring RESTful Services
  • 6.4 Downloading and Installing Oracle REST Data Services
    • 6.4.1 Downloading Oracle REST Data Services
    • 6.4.2 About Configuring Oracle REST Data Services Behind a Reverse Proxy or Load Balancer
    • 6.4.3 Web Server HTTP POST Request Limits
  • 6.5 Configuring Oracle REST Data Services
    • 6.5.1 Copying the Images Directory
    • 6.5.2 Validating the Oracle REST Data Services Installation
    • 6.5.3 Configuring Static File Support
    • 6.5.4 Securing Oracle REST Data Service
  • 6.6 Enabling Network Services in Oracle Database
    • 6.6.1 When and Why Network Services Must be Enabled
    • 6.6.2 Granting Connect Privileges in Oracle Database 12c or Later
    • 6.6.3 Troubleshooting an Invalid ACL Error
  • 6.7 Performing Security Tasks
  • 6.8 Controlling the Number of Concurrent Jobs
    • 6.8.1 About Managing the Number of Concurrent Jobs
    • 6.8.2 Viewing the Number of JOB_QUEUE_PROCESSES
      • 6.8.2.1 Viewing JOB_QUEUE_PROCESSES in the Installation Log File
      • 6.8.2.2 Viewing JOB_QUEUE_PROCESSES in Oracle APEX
      • 6.8.2.3 Viewing JOB_QUEUE_PROCESSES from SQL*Plus
    • 6.8.3 Changing the Number of JOB_QUEUE_PROCESSES
  • 6.9 About Running Oracle APEX in Other Languages
  • 6.10 Installing Translated Versions of Oracle APEX
    • 6.10.1 About Installing Translated Versions of Oracle APEX
    • 6.10.2 Installing a Translated Version of Oracle APEX
  • 6.11 Creating a Workspace and Adding Oracle APEX Users
    • 6.11.1 About Workspaces and Users
    • 6.11.2 Signing In To Administration Services
    • 6.11.3 Creating a Workspace Manually
    • 6.11.4 Creating Oracle APEX Users
    • 6.11.5 Signing In to Your Workspace
  • 6.12 Performing Post Installation Tasks for Upgrade Installations
    • 6.12.1 About Removing Prior Oracle APEX Installations
    • 6.12.2 Verifying if a Prior Installation Exists
    • 6.12.3 Removing Schemas and SYS Objects from Prior Installations
    • 6.12.4 Removing Schemas from Prior Installations in a CDB
    • 6.12.5 Fixing Invalid ACL
  • 6.13 About Performance Optimization Tasks
  • 6.14 Converting Between Runtime and Full Development Environments
    • 6.14.1 About Runtime and Full Development Environments
    • 6.14.2 Converting a Runtime Environment to a Full Development Environment
    • 6.14.3 Converting a Full Development Environment to a Runtime Environment
• A Automating the Oracle APEX Installation Process
  • A.1 About apxsilentins.sql
  • A.2 Running apxsilentins.sql
• B Maximizing Uptime During an Oracle APEX Upgrade
• C Oracle APEX Installation Troubleshooting
  • C.1 Reviewing a Log of an Installation Session
  • C.2 Verifying the Validity of an Oracle APEX Installation
  • C.3 Cleaning Up After a Failed Installation
    • C.3.1 Reverting to a Previous Release After a Failed Upgrade Installation
      • C.3.1.1 Verifying If You Have a Previous Release of Oracle APEX
      • C.3.1.2 Reverting the Images Directory
      • C.3.1.3 Reverting to a Previous Release
        • C.3.1.3.1 Reverting to Release 1.5
        • C.3.1.3.2 Reverting to Release 1.6
        • C.3.1.3.3 Reverting to Release 2.0
        • C.3.1.3.4 Reverting to Release 2.2
        • C.3.1.3.5 Reverting to Release 3.0
        • C.3.1.3.6 Reverting to Release 3.1
        • C.3.1.3.7 Reverting to Release 3.2
        • C.3.1.3.8 Reverting to Release 4.0
        • C.3.1.3.9 Reverting to Release 4.1
        • C.3.1.3.10 Reverting to Release 4.2 in a non-CDB or PDB with Local APEX
        • C.3.1.3.11 Reverting to Release 4.2 in a CDB
        • C.3.1.3.12 Reverting to Release 5.0 in a non-CDB or PDB with Local APEX
        • C.3.1.3.13 Reverting to Release 5.0 in a CDB
        • C.3.1.3.14 Reverting to Release 5.1 in a non-CDB or PDB with Local APEX
        • C.3.1.3.15 Reverting to Release 5.1 in a CDB
        • C.3.1.3.16 Reverting to Release 18.1 in a non-CDB or PDB with Local APEX
        • C.3.1.3.17 Reverting to Release 18.1 in a CDB
        • C.3.1.3.18 Reverting to Release 18.2 in a non-CDB or PDB with Local APEX
        • C.3.1.3.19 Reverting to Release 18.2 in a CDB
        • C.3.1.3.20 Reverting to Release 19.1 in a non-CDB or PDB with Local APEX
        • C.3.1.3.21 Reverting to Release 19.1 in a CDB
        • C.3.1.3.22 Reverting to Release 19.2 in a non-CDB or PDB with Local APEX
        • C.3.1.3.23 Reverting to Release 19.2 in a CDB
        • C.3.1.3.24 Reverting to Release 20.1 in a non-CDB or PDB with Local APEX
        • C.3.1.3.25 Reverting to Release 20.1 in a CDB
        • C.3.1.3.26 Reverting to Release 20.2 in a non-CDB or PDB with Local APEX
        • C.3.1.3.27 Reverting to Release 20.2 in a CDB
        • C.3.1.3.28 Reverting to Release 21.1 in a non-CDB or PDB with Local APEX
        • C.3.1.3.29 Reverting to Release 21.1 in a CDB
        • C.3.1.3.30 Reverting to Release 21.2 in a non-CDB or PDB with Local APEX
        • C.3.1.3.31 Reverting to Release 21.2 in a CDB
        • C.3.1.3.32 Re-enabling the REST Administration Interface After Downgrading
      • C.3.1.4 Removing the Oracle APEX Release Schema
        • C.3.1.4.1 Removing the APEX Release 22.1 Schema from a Non-CDB
        • C.3.1.4.2 Removing the Oracle APEX Release 22.1 Schema from a CDB
    • C.3.2 Removing Oracle APEX from the Database
  • C.4 About Images Displaying Incorrectly in Oracle APEX
  • C.5 About Page Protection Violation
• D Upgrading Oracle APEX within Oracle Database Express Edition
  • D.1 Upgrading to the Latest Oracle APEX Release
• Index