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 24.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.1.3 Installing APEX in Databases where Database Vault is Enabled
  • 2.2 Browser Requirements
  • 2.3 Web Server Requirements
  • 2.4 Disk Space Requirement
  • 2.5 Oracle XML DB Requirement
• 3 APEX Installation Overview
  • 3.1 About APEX Architecture
  • 3.2 About Accessing 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 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 APEX Runtime Environment
• 4 Upgrading from a Previous APEX Release
  • 4.1 About Release Numbering Conventions
  • 4.2 Sample Upgrade Scenarios
  • 4.3 Viewing the APEX Release Number
  • 4.4 Viewing the Oracle REST Data Services Release Number
  • 4.5 About Installing an 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 Multitenant Architecture
  • 5.1 Understanding the Installation Choices
  • 5.2 Installing APEX into an Application Container
    • 5.2.1 About Application Containers
    • 5.2.2 Creating an Application Container
    • 5.2.3 Installing or Upgrading 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 APEX into Different PDBs
    • 5.3.1 Uninstalling APEX from a CDB
    • 5.3.2 Installing APEX Locally in a PDB
    • 5.3.3 Installing APEX into a CDB
  • 5.4 Plugging in a PDB When APEX Is Installed in the Root Container
    • 5.4.1 Scenario 1: Plug-in Non-CDB with 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 APEX from Another CDB
    • 5.4.4 Scenario 4: Plug-in Non-CDB or PDB with No APEX
    • 5.4.5 Working with Incompatible APEX Versions
      • 5.4.5.1 Patching or Upgrading APEX in a CDB
      • 5.4.5.2 Patching or Upgrading APEX in a PDB
        • 5.4.5.2.1 Patching APEX in a PDB
        • 5.4.5.2.2 Upgrading APEX in a PDB
  • 5.5 Plugging in a PDB When 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 APEX from Another CDB
    • 5.5.3 Scenario 3: Plug-in PDB with a Local APEX from Another CDB
    • 5.5.4 Scenario 4: Plug-in a Non-CDB or PDB with No APEX
• 6 Installing and Configuring APEX and Oracle REST Data Services
  • 6.1 Performing Pre-installation Tasks for APEX
  • 6.2 About SQLcl Support
  • 6.3 Downloading and Installing APEX
    • 6.3.1 Installing 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
    • 6.3.5 Configuring the APEX_PUBLIC_ROUTER Account
  • 6.4 Downloading and Installing Oracle REST Data Services (ORDS)
    • 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 Managing Static Resources (Images)
      • 6.5.1.1 Copying the Images Directory
      • 6.5.1.2 Using a Static Resources CDN
    • 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
    • 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 APEX
      • 6.8.2.3 Viewing JOB_QUEUE_PROCESSES from SQLcl
    • 6.8.3 Changing the Number of JOB_QUEUE_PROCESSES
  • 6.9 About Running APEX in Other Languages
  • 6.10 Installing Translated Versions of APEX
    • 6.10.1 About Installing Translated Versions of APEX
    • 6.10.2 Installing a Translated Version of APEX
  • 6.11 Creating a Workspace and Adding 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 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 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 APEX Installation Process
  • A.1 About apxsilentins.sql
  • A.2 Running apxsilentins.sql
• B Maximizing Uptime During an APEX Upgrade
• C APEX Installation Troubleshooting
  • C.1 Reviewing a Log of an Installation Session
  • C.2 Verifying the Validity of an 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 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 Reverting to Release 22.1 in a non-CDB or PDB with Local APEX
        • C.3.1.3.33 Reverting to Release 22.1 in a CDB
        • C.3.1.3.34 Reverting to Release 22.2 in a non-CDB or PDB with Local APEX
        • C.3.1.3.35 Reverting to Release 22.2 in a CDB
        • C.3.1.3.36 Reverting to Release 23.1 in a non-CDB or PDB with Local APEX
        • C.3.1.3.37 Reverting to Release 23.1 in a CDB
        • C.3.1.3.38 Reverting to Release 23.2 in a non-CDB or PDB with Local APEX
        • C.3.1.3.39 Reverting to Release 23.2 in a CDB
        • C.3.1.3.40 Re-enabling the REST Administration Interface After Downgrading
      • C.3.1.4 Removing the APEX Release Schema
        • C.3.1.4.1 Removing the APEX Release 24.1 Schema from a Non-CDB
        • C.3.1.4.2 Removing the APEX Release 24.1 Schema from a CDB
    • C.3.2 Removing APEX from the Database
  • C.4 About Images Displaying Incorrectly in APEX
  • C.5 About Page Protection Violation
• Index