This course covers the Oracle APEX Administration essentials for DBAs. You will learn how to install, configure and manage a secure, production-quality APEX environment that supports internal AND public-facing internet applications. Learn how to install and configure APEX, ORDS, Tomcat, and Apache; create, backup, and restore workspaces and applications; enable secure connections to external services; install a digital certificate and enforce use of https when connecting to a virtual host.
The current releases of all components are used for exercises and demonstrations.
Course Features
- Lectures 0
- Quizzes 0
- Duration 2 Half Days (~8 hours)
- Skill level All levels
- Language English
- Students 9
- Certificate Yes
- Assessments Yes
Architecture
- Describe the web application processing model
- Differentiate the middle tier services
- Understand the purpose of the ORDS listener
- Compare the various web tier options
- Summarize the APEX structures: the instance, workspaces, applications
Install APEX
- Install the APEX code into the database
- Configure the database schemas
- Enable network services
- Consider options: full or runtime install, additional language support
Configure ORDS
- Describe Oracle REST Services
- Configure ORDS as an HTTP listener with a database access descriptor
- Install the Tomcat servlet container
- Deploy ORDS to Tomcat
- Consider alternative deployment models
The Apache web listener
- Understand the role of a reverse proxy
- Consider firewall requirements
- Compile and install the Apache http server
- Deploy images to the Apache server
- Route requests to Tomcat
- Create virtual hosts
- Configure for scalability and performance
Basic APEX administration
- Connect to the INTERNAL workspace
- Configure the APEX instance
- Create user workspaces
- Manage applications
- Export and import components
- Monitor activity
Additional administration tasks
- Manage access to remote network services
- Understand the job system
- Upgrade and patching
- Configure inbound and outbound traffic over SSL
- Create and use a digital certificate wallet
- Set up access to email and print servers
- Understand how to backup and restore an APEX environment
Login with Google