Oracle 19c Hands-On Experience

PART 2: UPGRADING TO ORACLE DATABASE 19C

Overview

In this two hour class, students will get hands-on experience with on how to upgrade databases to Oracle Database 19c.  

A virtual presentation will be followed by the hands-on practicum on performing an actual database upgrade.  Attendees will have access to a virtual machine with Oracle database versions 11.2.0.4 and 12.1.0.2 pre-installed with the latest PSU.  Attendee can perform database upgrades from Oracle versions 11.2.0.4 or 12.1.0.2 to Oracle Database 19c (19.7 or higher).  

Outline

1. Installing Oracle Database 19c software
2. Patching the database software to the latest Release Update (RU)
3. Performing pre-upgrade tasks prior to the database upgrade
4. Upgrading an Oracle 11.2.0.4 or 12.1.0.2 database to Oracle Database 19c with the latest RU
5. Performing post-upgrade tasks after the database upgrade
6. Learn how to perform AutoUpgrades to Oracle Database 19c

PART 3: PERFORMANCE TUNING

Overview

Oracle database upgrades often lead to performance related issues.  This is due to the number of underlying technical changes in software, introduction of new features, and general enhancement of the products.  With many 19c upgrades going on, it’s good to know how to use the many technical features in Oracle for dealing with or even eliminating performance issue.  In this lab we will go through some of the basic skills that every DBA should have around performance tuning from enhance explain plans and gathering statistics to using SQL Plan Management.  We will also cover the differences between SQL Baselines and SQL profiles.  This session should be good if you are an experienced DBA just brushing up on your skills, or new to using Oracle database performance tuning tools.

Two-hour course: A virtual presentation will be followed by the hands-on practicum on SQL tuning.  Attendees will have access to a virtual machine with Oracle database pre-installed.

Outline

1. 19c upgrade / Lab Setup
   1. MOS Reading
   2. Profiles vs Baselines
   3. Optimizer Decision Tree
2. SQL Explain Plan + Lab
   1. Normal
   2. Plan statics
   3. Monitor
   4. Finding you statements
3. Database Statistics + Lab
   1. Automated jobs
   2. Checking object staleness
4. SQL Plan Management (SPM) / Baselines + Labs
   1. Create a baseline
   2. Evolving baseline
   3. Viewing baseline plan / usage
5. SQL Profile + Lab
   1. Generated by SQL tuning advisor
   2. Transport to another DB
6. SQL Patch + Lab
   1. Grabbing a SQL ID
   2. Adding a patch (hint)

DATA GUARD: CONFIGURE AND BEST PRACTICES

Overview

In this two hour class, students will get access to 2 VMs with Oracle Database 19c pre-installed to setup and configure Data Guard.

Learn how you can setup Data Guard with all the best practices. Attendees will receive a brief history of Data Guard and how it became Data Guard. Then, dive directly into new features in Oracle Data Guard 12c Release 2/18c/19c. This workshop will disseminate Data Guard best practices and reference architectures that DBAs need to know to protect their Oracle ecosystem.  Viscosity will demonstrate how DBAs should setup, configure, and monitor mission critical Data Guard environments (including Active Data Guard).

Outline

1. Building the Physical Standby database
2. Monitoring the Physical Standby database
3. Maintaining the Physical Standby database
4. Configuring Data Guard Broker
5. Performing Backup and Recovery with RMAN
6. Setting Archive Retention
7. Switchovers
8. Failovers
   1. FSFO
   2. Observer
9. Active Data Guard
10. Snapshot Standby

PART 5: PDB IS RISEN FROM THE DEAD IN ORACLE DATABASE 19C

Overview

In this two hour class, students willlearn the fundamentals to managing the new frontier of pluggable databases. Each student will be assigned 2 VMs to configure PDBs and work labs.

With the recent announcement at Oracle OpenWorld, starting in Oracle Database 19c, we are allowed to have up to 3 pluggable databases per container database. Effective Oracle Database 20c, non-containerized databases will no longer be supported. As an attendee of this session, you will receive a free copy of the PDB Me to Oracle Cloud book written by Oracle ACEs. Come learn what it takes to effectively create, configure, manage and monitor Oracle PDBs while learning all the latest and greatest new features of Oracle PDBs from Oracle 12.2/18c/19c.

Outline

1. Migrate a non-CDB database to a singleton containerized database
2. Setup Data Guard between the primary and standby environments
3. Setup performance governors on the database tier
4. Clone PDB databases from one container to another container without downtime
5. Setup refreshable PDBs, Proxy PDBs, and to setup PDB Archives
6. Configure lockdown profiles
7. Configure snapshot carousels