Oracle Application Express for Amazon RDS for Oracle demystified

This article provides a comprehensive guide to installing, configuring, and managing Oracle Application Express (APEX) on Amazon RDS for Oracle, covering key aspects such as installation, web listener setup, and upgrade procedures.

• APEX can be installed in two environments:
  • Runtime environment (users can run applications)
  • Full development environment (users can develop and modify applications)
• Oracle REST Data Services (ORDS) is recommended as the web listener for APEX
• Installation involves:
• Adding APEX option to RDS option group
• Installing ORDS on a separate EC2 instance
• Configuring web listener and APEX administration
• Key upgrade considerations:
• APEX version upgrades
• ORDS version upgrades
• Database version compatibility

The article provides detailed technical steps for implementing APEX in Amazon RDS for Oracle environments, addressing common configuration challenges and best practices.