Go to main content
1/76
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 18.1
Deprecated and Desupported Features
Other Changes
1
Oracle Application Express Installation Overview
1.1
About Accessing Oracle Application Express in Oracle Database Cloud
1.2
Understanding the Installation Process
1.2.1
About Planning Your Installation
1.2.2
About Patch Sets and Point Releases
1.2.3
About Oracle Application Express Schemas
1.2.4
About the Installation Process
1.2.5
About Accessing Oracle Application Express
1.2.6
Signing In When Workspace Requests Is Enabled
1.2.6.1
Requesting a Workspace from the Sign In Page
1.2.6.2
Signing In To a Workspace
1.2.6.3
Signing Out of a Workspace
1.2.6.4
Recovering Your Workspace Name
1.2.6.5
Resetting Your Password from the Sign In Page
1.3
Upgrading from a Previous Oracle Application Express Release
1.3.1
Sample Upgrade Scenarios
1.3.2
Determining Your Oracle Application Express Release Version
1.3.3
About Determining the version of Oracle REST Data Services
1.3.4
About Installing the Oracle Application Express Release Included with the Oracle Database
1.3.5
About Upgrading Existing Applications
1.3.6
About Specifying an Application Compatibility Mode
1.3.7
About Testing Requirements
1.3.8
About Cleaning Up Your Environment
1.3.9
About Reverting to a Previous Release
1.4
Choosing a Web Listener
1.4.1
About Choosing a Web Listener
1.4.2
Comparing Web Listener Options
1.4.3
About Oracle REST Data Services
1.4.4
About the Embedded PL/SQL Gateway
1.4.5
About Security Considerations When Using the Embedded PL/SQL Gateway
1.4.6
About Oracle HTTP Server with mod_plsql
1.4.7
Selecting a Web Listener in an Oracle RAC Environment
1.5
About the Oracle Application Express Runtime Environment
2
Oracle Application Express Installation Requirements
2.1
Oracle Database Requirements
2.2
Checking the MEMORY_TARGET of the Target Database
2.3
Browser Requirements
2.4
Web Listener Requirements
2.5
Disk Space Requirement
2.6
Oracle XML DB Requirement
3
Utilizing the Multitenant Architecture in Oracle Database 12
c
or Later
3.1
Understanding the Installation Choices
3.2
Installing Application Express into Different PDBs
3.2.1
Uninstalling Application Express 18.1 from a CDB
3.2.2
Installing Application Express Locally in a PDB
3.2.3
Installing Application Express 18.1 into a CDB
3.3
Plugging in a PDB When Application Express is Installed in the Root Container
3.3.1
Scenario 1: Plug-in Non-CDB with Application Express
3.3.2
Scenario 2: Plug-in PDB with a 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 Non-CDB or PDB with No Application Express
3.3.5
Working with Incompatible Application Express Versions
3.3.5.1
Patching or Upgrading Application Express in the CDB
3.3.5.2
Patching or Upgrading Application Express in a PDB
3.3.5.2.1
Patching Application Express in a PDB
3.3.5.2.2
Upgrading Application Express in a PDB
3.4
Plugging in a PDB When Application Express Is Not in the Root Container of the Target CDB
3.4.1
Scenario 1: Plug-in a Non-CDB with Application Express
3.4.2
Scenario 2: Plug-in PDB with Common Application Express from Another CDB
3.4.3
Scenario 3: Plug-in PDB with a Local Application Express from Another CDB
3.4.4
Scenario 4: Plug-in a Non-CDB or PDB with No Application Express
4
Installing Application Express and Configuring Oracle REST Data Services
4.1
Oracle Database Requirements
4.2
Oracle REST Data Services Requirement
4.3
About Patching Oracle Application Express
4.4
Performing Pre-installation Tasks for Oracle Application Express
4.5
Downloading and Installing Oracle Application Express
4.5.1
Installing Application Express
4.5.2
Creating or Updating Your Instance Administration Account
4.5.2.1
What Is an Instance Administrator?
4.5.2.2
About apxchpwd.sql
4.5.2.3
Running apxchpwd.sql
4.5.3
Restarting Processes
4.5.4
Configuring the APEX_PUBLIC_USER Account
4.5.4.1
About the APEX_PUBLIC_USER Account
4.5.4.2
Unlocking the APEX_PUBLIC_USER Account
4.5.4.3
Changing the Password for the APEX_PUBLIC_USER Account
4.5.4.4
About Password Expiration in Oracle Database 11
g
and Later
4.6
Downloading and Installing Oracle REST Data Services
4.6.1
Downloading Oracle REST Data Services
4.6.2
About Configuring Oracle REST Data Services Behind a Reverse Proxy or Load Balancer
4.6.3
Web Server HTTP POST Request Limits
4.6.4
Disabling Oracle XML DB Protocol Server
4.7
Configuring Oracle REST Data Services
4.7.1
Copying the Images Directory
4.7.2
Configuring RESTful Services
4.7.3
Configuring Static File Support
4.7.4
Securing Oracle REST Data Service
4.8
Enabling Network Services in Oracle Database 11
g
or Later
4.8.1
When and Why Network Services Must be Enabled
4.8.2
Granting Connect Privileges Prior to Oracle Database 12
c
4.8.3
Granting Connect Privileges in Oracle Database 12
c
or Later
4.8.4
Troubleshooting an Invalid ACL Error
4.9
Performing Security Tasks
4.10
Controlling the Number of Concurrent Jobs
4.10.1
About Managing the Number of Concurrent Jobs
4.10.2
Viewing the Number of JOB_QUEUE_PROCESSES
4.10.2.1
Viewing JOB_QUEUE_PROCESSES in the Installation Log File
4.10.2.2
Viewing JOB_QUEUE_PROCESSES in Oracle Application Express
4.10.2.3
Viewing JOB_QUEUE_PROCESSES from SQL*Plus
4.10.3
Changing the Number of JOB_QUEUE_PROCESSES
4.11
About Running Oracle Application Express in Other Languages
4.12
Installing Translated Versions of Oracle Application Express
4.12.1
About Installing Translated Versions of Oracle Application Express
4.12.2
Installing a Translated Version of Oracle Application Express
4.13
Creating a Workspace and Adding Oracle Application Express Users
4.13.1
About Workspaces and Users
4.13.2
Accessing Administration Services Using Oracle REST Data Services
4.13.3
Creating a Workspace Manually
4.13.4
Creating Oracle Application Express Users
4.13.5
Signing into a Workspace Using Oracle REST Data Services
4.14
Performing Post Installation Tasks for Upgrade Installations
4.14.1
About Removing Prior Oracle Application Express Installations
4.14.2
Verifying if a Prior Installation Exists
4.14.3
Removing Schemas from Prior Installations
4.14.4
Removing Schemas from Prior Installations in a CDB
4.14.5
Fixing Invalid ACL in Oracle Database 11
g
or Later
4.15
About Performance Optimization Tasks
4.16
Converting Between Runtime and Full Development Environments
4.16.1
About Runtime and Full Development Environments
4.16.2
Converting a Runtime Environment to a Full Development Environment
4.16.3
Converting a Full Development Environment to a Runtime Environment
A
Installing Application Express and Configuring Embedded PL/SQL Gateway
A.1
Oracle Database Requirements
A.2
About Patching Oracle Application Express
A.3
Performing Pre-installation Tasks for Oracle Application Express
A.4
Downloading and Installing Oracle Application Express
A.4.1
Downloading and Installing Application Express
A.4.2
Creating or Updating Your Instance Administration Account
A.4.2.1
What Is an Instance Administrator?
A.4.2.2
About apxchpwd.sql
A.4.2.3
Running apxchpwd.sql
A.4.3
Restart Processes
A.5
Configuring the Embedded PL/SQL Gateway
A.5.1
Running the apex_epg_config.sql Configuration Script
A.5.2
Updating the Images Directory When Upgrading from a Previous Release
A.5.3
Verifying the Port Assigned to HTTP on the Oracle XML DB HTTP Server
A.5.4
Verifying the Oracle XML DB Protocol Server Port
A.5.5
Enabling Oracle XML DB Protocol Server
A.5.6
Configuring Static File Support
A.5.7
About Configuring Embedded PL/SQL Gateway Behind a Reverse Proxy or Load Balancer
A.6
Enabling Network Services in Oracle Database 11
g
or Later
A.6.1
When and Why Network Services Must be Enabled
A.6.2
Granting Connect Privileges Prior to Oracle Database 12
c
A.6.3
Granting Connect Privileges in Oracle Database 12
c
or Later
A.6.4
Troubleshooting an Invalid ACL Error
A.7
Performing Security Tasks
A.8
Controlling the Number of Concurrent Jobs
A.8.1
About Managing the Number of Concurrent Jobs
A.8.2
Viewing the Number of JOB_QUEUE_PROCESSES
A.8.2.1
Viewing JOB_QUEUE_PROCESSES in the Installation Log File
A.8.2.2
Viewing JOB_QUEUE_PROCESSES in Oracle Application Express
A.8.2.3
Viewing JOB_QUEUE_PROCESSES from SQL*Plus
A.8.3
Changing the Number of JOB_QUEUE_PROCESSES
A.9
About Running Oracle Application Express in Other Languages
A.10
Installing Translated Versions of Oracle Application Express
A.10.1
About Installing Translated Versions of Oracle Application Express
A.10.2
Installing a Translated Version of Oracle Application Express
A.11
About Configuring the SHARED_SERVERS Parameter
A.12
Creating a Workspace and Adding Oracle Application Express Users
A.12.1
About Workspaces and Users
A.12.2
Accessing Administration Services Using Embedded PL/SQL Gateway
A.12.3
Creating a Workspace Manually
A.12.4
Creating Oracle Application Express Users
A.12.5
Signing into a Workspace Using the Embedded PL/SQL Gateway
A.13
Performing Post Installation Tasks for Upgrade Installations
A.13.1
About Removing Prior Oracle Application Express Installations
A.13.2
Verifying if a Prior Installation Exists
A.13.3
Removing Schemas from Prior Installations
A.13.4
Fixing Invalid ACL in Oracle Database 11
g
or Later
A.14
About Performance Optimization Tasks
A.15
Converting Between Runtime and Full Development Environments
A.15.1
About Runtime and Full Development Environments
A.15.2
Converting a Runtime Environment to a Full Development Environment in a non-CDB or locally in a PDB
A.15.3
Converting a Full Development Environment to a Runtime Environment in a non-CDB or locally in a PDB
A.15.4
Converting a Runtime Environment to a Full Development Environment in a CDB
A.15.5
Converting a Full Development Environment to a Runtime Environment in a CDB
B
Installing Application Express and Configuring Legacy Web Listener – Oracle HTTP Server
B.1
Oracle Database Requirements
B.2
About Patching Oracle Application Express
B.3
Performing Pre-installation Tasks for Oracle Application Express
B.4
Downloading and Installing Oracle Application Express
B.4.1
Installing Application Express
B.4.2
Creating or Updating Your Instance Administration Account
B.4.2.1
What Is an Instance Administrator?
B.4.2.2
About apxchpwd.sql
B.4.2.3
Running apxchpwd.sql
B.4.3
Restarting Processes
B.4.4
Configuring the APEX_PUBLIC_USER Account
B.4.4.1
About the APEX_PUBLIC_USER Account
B.4.4.2
Unlocking the APEX_PUBLIC_USER Account
B.4.4.3
Changing the Password for the APEX_PUBLIC_USER Account
B.4.4.4
About Password Expiration in Oracle Database 11
g
B.5
Configuring the Oracle HTTP Server
B.5.1
About Copying the Images Directory
B.5.2
Copying the Images Directory
B.5.3
Editing the dads.conf File
B.5.4
Configuring Static File Support
B.5.5
Stopping and Restarting Oracle HTTP Server
B.5.5.1
Stopping and Restarting Oracle HTTP Server with Oracle Database 10g and Lower
B.5.5.2
Stopping and Restarting Oracle HTTP Server 12
c
B.5.6
Disabling Oracle XML DB Protocol Server
B.5.7
About Configuring Oracle HTTP Server Behind a Reverse Proxy or Load Balancer
B.6
Enabling Network Services in Oracle Database 11
g
or Later
B.6.1
When and Why Network Services Must be Enabled
B.6.2
Granting Connect Privileges Prior to Oracle Database 12
c
B.6.3
Granting Connect Privileges in Oracle Database 12
c
or Later
B.6.4
Troubleshooting an Invalid ACL Error
B.7
Performing Security Tasks
B.8
Controlling the Number of Concurrent Jobs
B.8.1
About Managing the Number of Concurrent Jobs
B.8.2
Viewing the Number of JOB_QUEUE_PROCESSES
B.8.2.1
Viewing JOB_QUEUE_PROCESSES in the Installation Log File
B.8.2.2
Viewing JOB_QUEUE_PROCESSES in Oracle Application Express
B.8.2.3
Viewing JOB_QUEUE_PROCESSES from SQL*Plus
B.8.3
Changing the Number of JOB_QUEUE_PROCESSES
B.9
About Running Oracle Application Express in Other Languages
B.10
Installing Translated Versions of Oracle Application Express
B.10.1
About Installing Translated Versions of Oracle Application Express
B.10.2
Installing a Translated Version of Oracle Application Express
B.11
Creating a Workspace and Adding Oracle Application Express Users
B.11.1
About Workspaces and Users
B.11.2
Accessing Administration Services Using Oracle HTTP Server
B.11.2.1
Creating a Workspace Manually
B.11.3
Creating Oracle Application Express Users
B.11.4
Signing into a Workspace Using the Oracle HTTP Server
B.12
Performing Post Installation Tasks for Upgrade Installations
B.12.1
About Removing Prior Oracle Application Express Installations
B.12.2
Verifying if a Prior Installation Exists
B.12.3
Removing Schemas from Prior Installations
B.12.4
Fixing Invalid ACL in Oracle Database 11
g
or Later
B.13
About Performance Optimization Tasks
B.14
Converting Between Runtime and Full Development Environments
B.14.1
About Runtime and Full Development Environments
B.14.2
Converting a Runtime Environment to a Full Development Environment in a non-CDB or locally in a PDB
B.14.3
Converting a Full Development Environment to a Runtime Environment in a non-CDB or locally in a PDB
B.14.4
Converting a Runtime Environment to a Full Development Environment in a CDB
B.14.5
Converting a Full Development Environment to a Runtime Environment in a CDB
C
Oracle Application Express Installation Troubleshooting
C.1
Reviewing a Log of an Installation Session
C.2
Verifying the Validity of an Oracle Application Express Installation
C.3
Downloading and Installing Patches
C.4
Cleaning Up After a Failed Installation
C.4.1
Reverting to a Previous Release After a Failed Upgrade Installation
C.4.1.1
Verifying If You Have a Previous Release of Oracle Application Express
C.4.1.2
Reverting the Images Directory
C.4.1.3
Reverting to a Previous Release
C.4.1.3.1
Reverting to Release 1.5
C.4.1.3.2
Reverting to Release 1.6
C.4.1.3.3
Reverting to Release 2.0
C.4.1.3.4
Reverting to Release 2.2
C.4.1.3.5
Reverting to Release 3.0
C.4.1.3.6
Reverting to Release 3.1
C.4.1.3.7
Reverting to Release 3.2
C.4.1.3.8
Reverting to Release 4.0
C.4.1.3.9
Reverting to Release 4.1
C.4.1.3.10
Reverting to Release 4.2 in a non-CDB
C.4.1.3.11
Reverting to Release 4.2 in a CDB
C.4.1.3.12
Reverting to Release 5.0 in a non-CDB
C.4.1.3.13
Reverting to Release 5.0 in a CDB
C.4.1.3.14
Reverting to Release 5.1 in a non-CDB
C.4.1.3.15
Reverting to Release 5.1 in a CDB
C.4.1.4
Removing the Oracle Application Express Release 18.1 Schema
C.4.1.4.1
Removing the Oracle Application Express Release 18.1 Schema from a Non-CDB
C.4.1.4.2
Removing the Oracle Application Express Release 18.1 Schema from a CDB
C.4.2
Removing Oracle Application Express from the Database
C.5
About Images Displaying Incorrectly in Oracle Application Express
C.6
About Page Protection Violation
D
Upgrading Oracle Application Express within Oracle Database Express Edition
D.1
Upgrading to the Latest Oracle Application Express Release
D.2
Understanding the Differences Between Later Oracle Application Express Releases
D.2.1
User Interface Differences
E
Maximizing Uptime During an Application Express Upgrade
Index
Scripting on this page enhances content navigation, but does not change the content in any way.