Oracle Application Express Administration: For DBAs and Developers

This book helps database and system administrators succeed in managing Oracle Application Express (APEX) environments. Focus is on creating the right combination of scalability, high-availability, backup and recovery, integrity, and resource control. The book covers everything from simple to enterprise-class deployments, with emphasis on enterprise-level requirements and coverage of cloud and hybrid-cloud scenarios.

Many books cover how to develop applications in Oracle APEX. It’s a tool with a fast-growing user-base as developers come to know how quick and easy it is to create new applications that run in a browser. However, just getting an application off the ground is only a small part of a bigger picture. Applications must be supported. They must be available when users need them. They must be robust against disaster and secure against malicious attack. These are the issues addressed in Oracle Application Express Administration. These are the issues that when tackled successfully lead to long term success in using Oracle APEX as a rapid application-development toolset.

Readers of this book learn how to install the Oracle APEX engine in support of small-scale projects such as at the departmental level, and in support of enterprise-level projects accessed by thousands of users across dozens of time zones. Readers learn to take advantage of Oracle Database’s underlying feature set in regards to application scalability and performance, integrity, security, high-availability, and robustness against failure and data loss. Oracle Application Express Administration also describes different cloud solutions, integration with Oracle E-Business Suite, and helps in taking advantage of multitenancy in Oracle Database 12c and beyond.

• Covers important enterprise considerations such as scalability, robustness, high-availability.
• Describes cloud-based application deployment scenarios
• Focuses on creating the right deployment environment for long-term success

What You Will Learn

• Install, upgrade, and configure robust APEX environments
• Backup and recover APEX applications and their data
• Monitor and tune the APEX engine and its applications
• Benefit from new administration features in APEX 5.0
• Run under multi-tenant architecture in Oracle Database 12c
• Manage the use of scarce resources with Resource Manager
• Secure your data with advanced security features

• Build high-availability into your APEX deployments
• Integrate APEX with Oracle E-Business Suite

Who This Book Is For

Oracle Application Express Administration is for architects, administrators, and developers who want to better understand how APEX works in a corporate environment. Readers will use this book to design deployment architectures around Oracle Database strengths like multi-tenancy, resource management, and high availability. The book is also useful to administrators responsible for installation and upgrade, backup and recovery, and the ongoing monitoring of the APEX engine and the applications built upon it.

Table of Contents

Part I: APEX Overview
Chapter 1. About APEX

Part II: Architecture
Chapter 2. APEX in the Database
Chapter 3. Middle-Tier
Chapter 4. Database Advanced Security
Chapter 5. APEX and Oracle E-Business Suite
Chapter 6. High Availability
Chapter 7. APEX in Multitenant Deployment

Part III: Configuration
Chapter 8. Installing
Chapter 9. Upgrading and Patching
Chapter 10. Configuring
Chapter 11. Administer APEX in Runtime Only Mode
Chapter 12. Database and APEX Backups
Chapter 13. Self-Provisioning Workspaces

Part IV: Tuning
Chapter 14. Monitoring
Chapter 15. Performance and Tuning
Chapter 16. Resource Manager and APEX