Table of Contents

• Title and Copyright Information
• Preface
  • Audience
  • Related Documents
  • Conventions
  • Third-Party License Information
• Changes in this Release
• Oracle APEX Installation Requirements
  • Oracle Database Requirements
    • Checking the Memory Settings of the Target Database
    • Checking the WORKAREA_SIZE_POLICY of the Target Database
    • Installing APEX in Databases where Database Vault is Enabled
  • Browser Requirements
  • Web Server Requirements
  • SQLcl Requirements
  • Disk Space Requirement
  • Oracle XML DB Requirement
• APEX Installation Overview
  • About APEX Architecture
  • About Accessing APEX in Oracle Cloud
  • Understanding the Installation Process
    • About Planning Your Installation
    • About Patch Sets
    • About the Installation Scripts
    • About Accessing APEX
    • Requesting a Workspace from the Sign In Dialog
    • Resetting Your Password from the Sign In Page
    • Recovering Your Workspace Name
  • About the APEX Runtime Environment
  • About APEX Database Accounts
• Upgrading from a Previous APEX Release
  • About Release Numbering Conventions
  • Sample Upgrade Scenarios
  • Viewing the APEX Release Number
  • Viewing the Oracle REST Data Services Release Number
  • About Installing an APEX Release Included with the Oracle Database
  • About Upgrading Existing Applications
  • About Testing Requirements
  • About Cleaning Up Your Environment
  • About Reverting to a Previous Release
  • Viewing Install and Upgrade Logs
• Utilizing Multitenant Architecture
  • Understanding the Installation Choices
  • Installing APEX into an Application Container
    • About Application Containers
    • Creating an Application Container
    • Installing or Upgrading APEX in an Application Container
    • Verifying the Application Container Installation
    • Creating an Application Seed
    • Creating an Application PDB from the Application Root Seed
    • Configure HTTP Access to the Application PDB
  • Installing APEX into Different PDBs
    • Uninstalling APEX from a CDB
    • Installing APEX Locally in a PDB
    • Installing APEX into a CDB
  • Plugging in a PDB When APEX Is Installed in the Root Container
    • Scenario 1: Plug-in Non-CDB with APEX
    • Scenario 2: Plug-in PDB with a Common APEX from Another CDB
    • Scenario 3: Plug-in PDB with a Local APEX from Another CDB
    • Scenario 4: Plug-in Non-CDB or PDB with No APEX
    • Working with Incompatible APEX Versions
      • Patching or Upgrading APEX in a CDB
      • Patching or Upgrading APEX in a PDB
        • Patching APEX in a PDB
        • Upgrading APEX in a PDB
  • Plugging in a PDB When APEX Is Not in the Root Container of the Target CDB
    • Scenario 1: Plug-in a Non-CDB or PDB with Locally Installed APEX
    • Scenario 2: Plug-in PDB with Common APEX from Another CDB
    • Scenario 3: Plug-in PDB with a Local APEX from Another CDB
    • Scenario 4: Plug-in a Non-CDB or PDB with No APEX
• Installing and Configuring Oracle REST Data Services and Oracle APEX
  • Performing Pre-installation Tasks for APEX
  • About SQLcl Support
  • Downloading and Installing Oracle REST Data Services (ORDS)
    • Downloading Oracle REST Data Services
    • About Configuring Oracle REST Data Services Behind a Reverse Proxy or Load Balancer
    • Web Server HTTP POST Request Limits
  • Configuring Oracle REST Data Services
    • Configuring PL/SQL Gateway Mode in ORDS Configuration
    • Managing Static Resources (Images)
      • Copying the Images Directory
      • Using a Static Resources CDN
    • Validating the Oracle REST Data Services Installation
    • Configuring Static File Support
    • Securing Oracle REST Data Service
  • Downloading and Installing Oracle APEX
    • Installing APEX
    • Creating or Updating Your Instance Administration Account
      • What Is an Instance Administrator?
      • About apxchpwd.sql
      • Running apxchpwd.sql
    • Restarting Processes
    • Configuring the APEX_PUBLIC_USER Account
      • About the APEX_PUBLIC_USER Account
      • Changing the Password for the APEX_PUBLIC_USER Account
      • About Password Expiration in Oracle Database
    • Configuring the APEX_PUBLIC_ROUTER Account
      • About Sessions Per User in Oracle AI Database
  • Enabling Network Services in Oracle Database
    • When and Why Network Services Must be Enabled
    • Granting Connect Privileges
    • Troubleshooting an Invalid ACL Error
  • Performing Security Tasks
  • Controlling the Number of Concurrent Jobs
    • About Managing the Number of Concurrent Jobs
    • Viewing the Number of JOB_QUEUE_PROCESSES
      • Viewing JOB_QUEUE_PROCESSES in the Installation Log File
      • Viewing JOB_QUEUE_PROCESSES in APEX
      • Viewing JOB_QUEUE_PROCESSES from SQLcl
    • Changing the Number of JOB_QUEUE_PROCESSES
  • About Running APEX in Other Languages
  • Installing Translated Versions of APEX
    • About Installing Translated Versions of APEX
    • Installing a Translated Version of APEX
  • Creating a Workspace and Adding APEX Users
    • About Workspaces and Users
    • Signing In To Administration Services
    • Creating a Workspace Manually
    • Creating APEX Users
    • Signing In to Your Workspace
  • Performing Post Installation Tasks for Upgrade Installations
    • Verifying Successful Completion of Upgrade Phase 4
    • About Removing Prior APEX Installations
    • Verifying if a Prior Installation Exists
    • Removing Schemas and SYS Objects from Prior Installations
    • Removing Schemas from Prior Installations in a CDB
    • Fixing Invalid ACL
  • About Performance Optimization Tasks
  • Converting Between Runtime and Full Development Environments
    • About Runtime and Full Development Environments
    • Converting a Runtime Environment to a Full Development Environment
    • Converting a Full Development Environment to a Runtime Environment
• Appendix A: Automating the APEX Installation Process
  • About apxsilentins.sql
  • Running apxsilentins.sql
• Appendix B: Maximizing Uptime During an APEX Upgrade
• Appendix C: APEX Installation Troubleshooting
  • Reviewing a Log of an Installation Session
  • Verifying the Validity of an APEX Installation
  • Cleaning Up After a Failed Installation
    • Reverting to a Previous Release After a Failed Upgrade Installation
      • Verifying If You Have a Previous Release of APEX
      • Reverting the Images Directory
      • Reverting to a Previous Release
        • Reverting to Release 1.5
        • Reverting to Release 1.6
        • Reverting to Release 2.0
        • Reverting to Release 2.2
        • Reverting to Release 3.0
        • Reverting to Release 3.1
        • Reverting to Release 3.2
        • Reverting to Release 4.0
        • Reverting to Release 4.1
        • Reverting to Release 4.2 in a non-CDB or PDB with Local APEX
        • Reverting to Release 4.2 in a CDB
        • Reverting to Release 5.0 in a non-CDB or PDB with Local APEX
        • Reverting to Release 5.0 in a CDB
        • Reverting to Release 5.1 in a non-CDB or PDB with Local APEX
        • Reverting to Release 5.1 in a CDB
        • Reverting to Release 18.1 in a non-CDB or PDB with Local APEX
        • Reverting to Release 18.1 in a CDB
        • Reverting to Release 18.2 in a non-CDB or PDB with Local APEX
        • Reverting to Release 18.2 in a CDB
        • Reverting to Release 19.1 in a non-CDB or PDB with Local APEX
        • Reverting to Release 19.1 in a CDB
        • Reverting to Release 19.2 in a non-CDB or PDB with Local APEX
        • Reverting to Release 19.2 in a CDB
        • Reverting to Release 20.1 in a non-CDB or PDB with Local APEX
        • Reverting to Release 20.1 in a CDB
        • Reverting to Release 20.2 in a non-CDB or PDB with Local APEX
        • Reverting to Release 20.2 in a CDB
        • Reverting to Release 21.1 in a non-CDB or PDB with Local APEX
        • Reverting to Release 21.1 in a CDB
        • Reverting to Release 21.2 in a non-CDB or PDB with Local APEX
        • Reverting to Release 21.2 in a CDB
        • Reverting to Release 22.1 in a non-CDB or PDB with Local APEX
        • Reverting to Release 22.1 in a CDB
        • Reverting to Release 22.2 in a non-CDB or PDB with Local APEX
        • Reverting to Release 22.2 in a CDB
        • Reverting to Release 23.1 in a non-CDB or PDB with Local APEX
        • Reverting to Release 23.1 in a CDB
        • Reverting to Release 23.2 in a non-CDB or PDB with Local APEX
        • Reverting to Release 23.2 in a CDB
        • Reverting to Release 24.1 in a non-CDB or PDB with Local APEX
        • Reverting to Release 24.1 in a CDB
        • Reverting to Release 24.2 in a non-CDB or PDB with Local APEX
        • Reverting to Release 24.2 in a CDB
        • Reverting to Release 26.1 in a non-CDB or PDB with Local APEX
        • Reverting to Release 26.1 in a CDB
        • Re-enabling the REST Administration Interface After Downgrading
      • Removing the APEX Release Schema
        • Removing the APEX Release 26.2 Schema from a Non-CDB
        • Removing the APEX Release 26.2 Schema from a CDB
    • Removing APEX from the Database
  • Restarting Phase 4 of an APEX Upgrade
  • About Images Displaying Incorrectly in APEX
  • About Page Protection Violation