Oracle Database 12cR2, 18c and 19c New Features for Administrators

5 Day Course
Hands On
Code ONF

Book Now - 3 Delivery Methods Available:

Classroom Virtual Classroom Private Group - Virtual Self-Paced Online


This Oracle Database 12cR2, 18c and 19c New Features for Administrators course is designed to give Oracle Database Administrators practical experience in using the new non-container database features that have been introduced in Oracle Database 12cR2, 18c and 19c.

The delegate will gain an appreciation of how the enhanced features of Oracle Database 12cR2, 18c and 19c may be implemented at their own site.

Note: The focus of this course is on the general new features that have been introduced in Oracle Database 12cR2, 18c and 19c. The course covers an overview only of container and pluggable databases. The Oracle 18c Container and Pluggable Database Administration course covers Multitenant Architecture features in detail.

Exercises and examples are used throughout the course to give practical hands-on experience with the techniques covered.


The delegate will learn and acquire skills as follows:

  • Install the Oracle Database 12cR2, 18c or 19c software with the OUI
  • Create a non-container Oracle Database 12cR2, 18c or 19c Database
  • Upgrade an Oracle database to Oracle 12cR2, 18c or 19c
  • Migrate a database with Data Pump
  • New database management features
  • Enhancements to Unified Auditing
  • Enhancements to administrative privileges and profiles
  • Enable Privilege Analysis as part of the Enterprise Edition
  • Schema and data management new features
  • The SQL*Plus history commands and the SQLcl utility
  • New SQL and PL/SQL features
  • New RMAN and availability features
  • Data Redaction and Data Encryption Enhancements
  • Performance tuning new features
  • Data Pump, SQL*Loader and External Table new features
  • Partitioning enhancements
  • Big Data and Data Warehousing new features
  • Database Diagnostic new features
  • SQL Tuning enhancements using the Optimizer Statistics Advisor and SQL join processing
  • Using the Trace File Analyzer to collect and diagnose issues
  • Data Guard, Active Data Guard and the Broker new features
  • Use In-Memory Column Store new features to increase SQL performance

Target Audience

This Oracle Database 12cR2, 18c and 19c New Features for Administrators course is designed for Oracle professionals who need to gain an understanding of and implement the new non-Multitenant Architecture features and functionality introduced in Oracle Database 12cR2, 18c and 19c.

Additional Information

  • Course technical content is subject to change without notice.
  • Course content is structured as sessions, this does not strictly map to course timings. Concepts, content and practicals often span sessions.

Training Partners

We work with the following best of breed training partners using our bulk buying power to bring you a wider range of dates, locations and prices.


Hide all

Oracle Database Multitenant Architecture Overview (7 topics)

  • Overview of the Oracle Database 12cR2 architecture
  • An overview of a Container Database (CDB)
  • The benefits of Multitenant Architecture
  • The root container and Pluggable Database containers
  • The structure of the Root Container
  • The structure of a Pluggable Database (PDB)
  • CDB_xxx and DBA_xxx Views

Create a Database with the Database Configuration Assistant (DBCA) (8 topics)

  • Select a CDB or non-CDB database
  • Create a Database with the DBCA
  • Create a Database using Silent Mode
  • Create a Database using a Response File with DBCA Silent Mode
  • Create a Duplicate Database with DBCA Silent Mode from 19c
  • Create a 18c or 19c Demonstration Database using Silent Mode
  • Delete a database with the DBCA Silent Mode
  • Read Only Oracle Homes in Oracle Database 18c/19c

Preparation for Upgrade to Oracle Database 12cR2, 18c or 19c (18 topics)

  • Upgrade Process Overview
  • Direct Upgrade Supported Releases
  • Methods used to Perform Indirect Upgrades
  • 19c Simplified Upgrade with Autoupgrade
  • The Database Upgrade Assistant(dbua)
  • Manual Upgrade
  • Methods of Data Migration
  • Rolling upgrade for Grid Infrastructure
  • Create an Upgrade Test Plan
  • Carry out Performance Testing
  • Run the Pre-Upgrade Information Tool
  • Carry out the Recommended Actions
  • Check for Compatibility Issues
  • Pre-configuration of the ORAchk Utility with Default Values
  • Backup the database
  • Create the New Oracle Home
  • Install the Oracle Database Software
  • Oracle 19c Upgrade of Expired Password Accounts

Perform an Upgrade (14 topics)

  • The Manual Upgrade of a Database to 12.2.0.n
  • Execute preupgrade.jar
  • Upgrade a Database with the Database Upgrade Assistant (DBUA)
  • Run the DBUA in Silent Mode
  • Oracle Database Autoupgrade
  • Post Upgrade Checks
  • Manually Start a Failed Upgrade
  • Deprecated and De-supported Database Features and Parameters
  • Common Installation Errors
  • Check the /etc/oratab File
  • Check the Database Version
  • Enterprise Manager Express Configuration
  • Carry Out Post Upgrade Tasks After a Manual Upgrade
  • Migrate to Unified Auditing

Migrate Data with Data Pump (3 topics)

  • Migrate data with Data Pump
  • Transport a database
  • Import data using a Data Pump network link

Enhancements to Database Auditing and Security (11 topics)

  • Overview of Database Auditing
  • Use Mixed Mode Auditing or Migrate to Pure Unified Auditing
  • Enhancements to Unified Auditing 18c & 19c
  • Write Unified Audit Records to SYSLOG
  • Changes to Audit Options
  • Audit Top Level User Activities in 19c
  • Audit by Role
  • Capture the Predicate Clause when using VPD
  • Data Dictionary Enhancements
  • Audit a Read-Only Database to the Operating System in 19c
  • Use Oracle Data Pump to Export and Import the Unified Audit Trail

Enhancements to Privileges and Profiles (16 topics)

  • SYSRAC Administrative Privilege for RAC and GI
  • Administrative User Authentication Enhancements
  • Automatically Lock Inactive accounts
  • 12.2 Administrative Password Security Enhancements
  • Schema Only Accounts from 18c
  • Passwords Removed from Schema Only Accounts in 19c
  • Grant Administrative Privileges to Schema Only Accounts in 19c
  • Control Definer's Rights Privileges for Database Links
  • 19c Privilege Analysis with an Enterprise Edition License
  • Database Privilege Analysis with Database Capture
  • Grant the CAPTURE_ADMIN Role to Enable Management of Privilege Captures
  • Create, Start and Stop Privilege Captures
  • Viewing Privilege Profile Data
  • Query the DBA_PRIV_CAPTURES View
  • The Default ORA$DEPENDENCY Profile
  • Execute the Invokers Rights Privilege with The Inherit Privilege

New RMAN Features (7 topics)

  • 12.2 RMAN Syntax Enhancements
  • Enhanced Table Point in Time Recovery from 12.2
  • The Enhanced REPAIR FAILURE Command
  • Table or Partition Recovery Enhancements from 12.2
  • Recover a Database after Missing Redo Logs Found
  • Simplified Duplicate a Database using TDE
  • Simplified RMAN Duplication of TDE Tablespaces

Miscellaneous New Features (8 topics)

  • Automatic Memory Management Restrictions
  • Cancel a SQL Statement in a Session from 18c
  • Online Redefinition Enhancements from 18c
  • Use Private Temporary Tables from 18c
  • Miscellaneous Data Masking Enhancements
  • Miscellaneous Data Redaction Enhancements
  • 12.2 INMEMORY_SIZE Parameter Changes
  • 12.2 INMEMORY Enhancements

SQL Enhancements (13 topics)

  • SQL*Plus Enhancements
  • The login.sql File
  • SQL*Plus Command Line History
  • SQL*Plus Performance Settings Options
  • The SQLcl Command Line Interface
  • Longer Object Names
  • Globalization Support at Table and Column Level
  • Configure Extended Data Types
  • Markup CSV
  • New Approximate Functions
  • LISTAGG DISTINCT from Oracle 19c
  • Remove Duplicates from LISTAGG Results using DISTINCT
  • Approximate Query Processing and Real-Time Materialised Views

Performance Tuning New Features (8 topics)

  • Overview of Performance Tuning New Features
  • Adaptive Query Optimization Enhancements
  • Automatic SQL Plan Capture Enhancements
  • Configure the Automatic SPM Evolve Advisor Task to Run Hourly
  • Automatic Resolution of SQL Plan Regressions
  • The Optimizer Statistics Advisor Rules, Findings, Recommendations and Actions
  • The Expression Statistics Store
  • Enhancements to the SQL Performance Analyzer

Big Data and Data Warehouse New Features (11 topics)

  • Reduce Cursor Invalidations for DDLs
  • Automatic Indexing in 19c with DBMS_AUTO_INDEX
  • Real Time Statistics Gathering during DML Operations
  • Configure a Lightweight, High Frequency Statistics Gathering Job for Stale Statistics
  • Advanced Index compression
  • SQL Statements Terminated by the Resource Manager Quarantined
  • SQL Diagnostics and Repair Enhancements
  • Bitmap-Based COUNT(DISTINCT) Rollup
  • Scalable Sequences
  • Polymorphic Tables Enhancements
  • HCC Data Compression with an ADO Row-level policy

Data Guard New Features (21 topics)

  • Use the DBCA to Create Standby Databases
  • Automatic Password File Management
  • Synchronous Redo Transport Enhancements
  • Simple Repair of NOLOGGING Operations
  • Shadow Lost Write Protection
  • Perform Data File Block Comparison Between the Primary and a Standby
  • Network Based Standby Database Recovery
  • Automatic Flashback of a Standby Database
  • Flashback a Standby Database when the Primary is Flashed Back
  • Automatically Replicate Restore Points from Primary to Standby
  • Data Guard Broker New Features
  • New Command Line Interface Properties
  • Create Scripts with the Broker DGMGRL Command Line Interface
  • New Broker Commands
  • New VALIDATE Commands
  • Export and Import the Broker Configuration File
  • Configure Multiple Failover Targets
  • Dynamically Change Fast Start Failover Target using the Data -Guard Broker
  • Use Observer Only Mode to Test Fast Start Failover
  • Set Multiple Observers

Data Pump Enhancements (8 topics)

  • Data Pump Parallel Import and Export of Metadata
  • The Usage of Wildcards in TRANSPORT_DATAFILES
  • New Substitution Variables for Filenames
  • Parameter File Contents Written to the Log File
  • The REMAP_DIRECTORY Parameter
  • DATA_OPTIONS Parameter Changes
  • Dynamic Data Pump Tracing
  • Miscellaneous New Data Pump Features

Active Data Guard New Features (13 topics)

  • Connection Preservation During Role Transition
  • Keep Buffer Cache at Role Change
  • DML Operations on Active Data Guard
  • Active Data Guard Redirection
  • Network-Based Standby Recovery
  • Support for the Diagnostic Pack
  • Support for the SQL Tuning Advisor
  • Use RMAN and Enterprise Manager to create Far Sync Instances
  • Control Login Attempts
  • Create Global Temporary Tables
  • Standby NOLOGGING for Load Performance
  • Standby NOLOGGING for Data Availability

Prepare the Server for Oracle Database Software Installation (7 topics)

  • Plan an installation
  • System requirements and Operating System Prerequisites
  • Optimal Flexible Architecture
  • Software Pre-installation Tasks
  • Carry out Pre-installation Checks
  • Set Environment Variables
  • Set Permissions to run root Configuration Scripts Automatically

Install the Oracle Database Software (9 topics)

  • Interactive Oracle Database Software Installation with the OUI
  • The Oracle Inventory
  • Silent mode installation
  • Create a Response File
  • Install with a Response File
  • Oracle Database 19c RPM Installation
  • 19c Image Based Client Installation
  • 19c Automated Installation, Configuration and Patching
  • Database Software De-installation

PL/SQL Enhancements (7 topics)

  • PL/SQL Enhancements
  • PL/SCOPE Enhancements
  • The Deprecate Pragma for PL/SQL
  • Code coverage using DBMS_PLSQL_CODE_COVERAGE
  • Control Definer's Rights for Database Links
  • Package White Lists Enhancements

Partitioning Enhancements (11 topics)

  • New Oracle Partitioning Strategies in 12.2
  • Automatic List Partitioning
  • Multiple Column List Partitioning
  • Multiple Column with Automatic List Partitioning
  • Interval Sub-Partitioning
  • Filter Data During Partition Maintenance Operations
  • Convert a Non-Partitioned Table to a Partitioned Table
  • Read Only Partitions
  • Defer Segment Creation for Sub-Partitioning
  • Hybrid Partitioned Tables - Integrate Internal and External Partitions

SQL* Loader and External Table Enhancements (6 topics)

  • The SDF_PREFIX Parameter
  • The HADOOP_TRAILERS Parameter
  • Hexadecimal and Multi-byte String Support for SQL*Loader Express
  • InMemory External Tables
  • The External MODIFY Clause
  • Load XML Documents with the XML TAG Clause

Database Diagnostic New Features (8 topics)

  • Set an ADR Retention Target from 12.2
  • The Retention Advisor
  • The TFA Collector
  • Install the TFA Collector
  • Manage the TFA daemon
  • Start and stop the TFA Collector
  • Create a Database Operation
  • Quarantined Objects

Transparent Sensitive Data Protection Enhancements (6 topics)

  • Overview of New Security Features Support for TSDP
  • TSDP with Unified Auditing
  • TSDP with Fine-Grained Auditing
  • TSDP with TDE Column Encryption
  • TDE Column Encryption Encrypt Clause Settings used with TSDP Policies
  • TSDP Data Dictionary Views

Application Continuity Enhancements (5 topics)

  • Application Continuity Overview
  • Server Draining Prior to Stopping or Relocating Services
  • Oracle Database Recognition of Request Boundaries
  • Transparent Application Continuity
  • Application Continuity after a Communication Failure


Delegates attending the Oracle Database 12cR2, 18c and 19c New Features for Administrators course should have administration experience of Oracle Database 12.1. Knowledge of using PL/SQL packages is strongly recommended.

This course is run on a Linux operating system, a good working knowledge of UNIX/Linux is required. This knowledge can be gained by attendance on the pre-requisite Linux Introduction course.

Additional Learning

The courses below may help you meet the knowledge level required to take this course.

Scheduled Dates

Please select from the dates below to make an enquiry or booking.


Different pricing structures are available including special offers. These include early bird, late availability, multi-place, corporate volume and self-funding rates. Please arrange a discussion with a training advisor to discover your most cost effective option.

Code Location Duration Price Jul Aug Sep Oct Nov Dec
Virtual Classroom (London)
5 Days $3,085
Virtual Classroom (London)
5 Days $3,085

Course PDF


Share this Course


Recommend this Course