Oracle Database Management HOLs

Overview:

DevOps adoption helps customers to automate and standardize processes, accelerate software delivery while keeping control of the operations, monitoring and lifecycle management of the environment.  DevOps tools require deeper automation from specialized management tools like Oracle Enterprise Manager 13c (EM 13c).  In this workshop you will get hands-on experience with the Extensibility and Interoperability capabilities of the Database as A Service offering in Oracle Enterprise Manager 13c with DevOps tools like Ansible.

Agenda

• Install and Configure Ansible
• Verify DBaaS Setup and Integration with Ansible
• Provision a PDB using DBaaS and Ansible
• PDB Life Cycle Management using DBaaS and Ansible
• Delete a PDB using DBaaS and Ansible

Speaker is Alfredo Krieg, Master Principal Security and Management Platform Specialist

Title: EM - Deploy and Manage Oracle Databases with Ansible and Enterprise Manager

Duration: 2 hrs

Description:

In this workshop you will get hands-on experience with the Extensibility and Interoperability capabilities of the Database as A Service offering in Oracle Enterprise Manager 13c with DevOps tools like Ansible.

Speaker:

Alfredo Krieg

Master Principal Security and Management Platform Specialist

Overview:

Configuration and compliance management are key to a resilient and secure IT estate.  With Configuration Management, one can continuously monitor and track configuration drifts of targets against the reference configuration.  With Compliance Management, one can run automated, continuous security checks based on industry standards and best practices, such as the Center for Internet Security (CIS), Security Technical Implementation Guide (STIG), Payment Card Industry Data Security Standard (PCI DSS), and Health Insurance Portability and Accountability Act (HIPAA).    In this workshop you will leverage Oracle Enterprise Manager Cloud Control 13c’s Lifecycle Management capabilities related to configuration and security compliance management of managed targets.

Agenda

• Inventory & Usage details, Configuration Search
• One-time database comparison
• Database configuration drift management
• Database security compliance
• Host security compliance
• Custom Compliance Standard

Speaker is Amine Tarhini, Principal Security and Management Platform Specialist

Title: EM – Oracle Database Configuration and Compliance Management

Duration: 2 hrs

Description:

In this workshop you will leverage Oracle Enterprise Manager Cloud Control 13c’s Lifecycle Management capabilities related to configuration and security compliance management of managed targets.

Speaker:

Amine Tarhini

Principal Security and Management Platform Specialist

Overview:

Oracle Real Application Testing option enables you to perform real-world testing of Oracle Database. By capturing production workloads and assessing the impact of system changes on these workloads before production deployment, Oracle Real Application Testing minimizes the risk of instabilities associated with system changes.

Agenda

• SQL Performance Analyzer
• Database Workload Replay - Capture Workload
• Database Workload Replay - Replay Workload
• Database Workload Replay - API
• Database Replay - Consolidation Replay

Title: EM - Get Started With Oracle Real Application Testing

Duration: 2 hrs

Description:

The attendee will learn how to use SQL Performance Analyzer and Database Replay to validate that changes (upgrades, migrations, patches, …) won’t impact performance and resiliency of the their database estate.

Speaker:

Alfredo Krieg

Master Principal Security and Management Platform Specialist

Overview:

Database Lifecycle Management provides an end-to-end automated solution for upgrade of the Oracle Database. Fleet Maintenance enables DBAs to automate upgrade of wide range of DB Configurations including Oracle RAC environments with Data Guard Standby.  With 19C being a long term release the workshop will show you an automated approach up upgrading your estate.   The lab will also showcase how you can leverage the Migration Workbench within Real Application Testing if platform migration is also required for such new OS and/or hardware platforms.

Agenda

• Detect Configuration Pollution with Software Standardization Advisor
• Oracle Database Upgrade with Fleet Maintenance (Overview)
• Review Pre-Completed Patching Tasks
• Create New Image Version
• Deploy New Image Version
• Migrate Listener to New Upgraded Home
• Update Database – Upgrade to 19.7
• Cleanup Old Homes
• Migration Workbench Demonstration

Speaker is Amine Tarhini, Principal Security and Management Platform Specialist

Title: EM – Oracle Automated Database Upgrade and Migration at Scale with Fleet Maintenance

Duration: 2 hrs

Description:

Gain insight into how to automate the upgrade process of your estate using Fleet Maintenance in Database Lifecycle Management. In the event of migration (new OS and/or Hardware), you will also learn how to eliminate the complexity of migration and reduce downtime with the Migration Workbench in Real Application Testing.

Speaker:

Amine Tarhini

Principal Security and Management Platform Specialist