25,000+ Courses Nationwide
0345 4506120

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

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 18c/19c software with the OUI
  • Create a non-container Oracle Database 18c or 19c Database
  • Upgrade an Oracle database to Oracle 18c/19c
  • Migrate a database to 18c/19c 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
  • 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

Who will the Course Benefit?

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.

Select specific date to see price, venue and full details.

Learning Objectives

The course aims to provide the delegate with the knowledge to be able to implement new features introduced in Oracle Database 12cR2, 18c and 19c.

Pre-Requisites

Requirements

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, therefore a good working knowledge of Linux/UNIX is required. This knowledge can be gained by attendance on the pre-requisite Linux Introduction course.

Pre-Requisite Courses

  • Linux Introduction
  • Oracle Database 11g Release 2 DBA - Part I
  • Oracle Database 11g Release 2 DBA - Part II

Course Content

Day 1

Course Introduction

  • Administration and Course Materials
  • Course Structure and Agenda
  • Delegate and Trainer Introductions

Session 1: ORACLE DATABASE MULTITENANT ARCHITECTURE OVERVIEW

  • 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

Session 2: INSTALL THE ORACLE 12c OR 18c DATABASE SOFTWARE

  • Plan an installation
  • System requirements and Operating System Prerequisites
  • Carry out Pre-installation Checks
  • Set Environment Variables
  • Set Permissions to run root Configuration Scripts Automatically
  • 19c Automated Installation, Configuration and Patching
  • Install the Oracle Database software with the Oracle Universal Installer
  • Silent mode installation
  • 19c Image Based Client Installation
  • 19c Automated Installation and Patching
  • Database Software Deinstallation

Session 3: CREATE A DATABASE WITH THE DATABASE CONFIGURATION ASSISTANT (DBCA)

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

Session 4: PREPARATION FOR UPGRADE TO ORACLE DATABASE 18c/19c

  • Methods used to Perform an Upgrade
  • Methods of Data Migration
  • Direct Upgrade Supported Releases
  • 19c Simplified Upgrade with Autoupgrade
  • The Database Upgrade Assistant(dbua)
  • Upgrade Process Overview
  • Rolling upgrade
  • Create an Upgrade Test Plan
  • Carry out Performance Testing
  • Run the Pre-Upgrade Information Tool
  • Pre-configuration of the ORAchk Utility with Default Values
  • Backup the database
  • Install the Oracle Database Software
  • Create the New Oracle Home

Session 5: PERFORM UPGRADEs TO ORACLE DATABASE 18c/19c

  • Upgrading to Oracle Database 18c/19c
  • The Manual Upgrade of an Oracle 12cR1 Database
  • Execute preupgrade.jar
  • Upgrade a Database with the Database Upgrade Assistant (DBUA)
  • Post Upgrade Checks
  • Deprecated 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

Day 2

Session 6: MIGRATE DATA WITH DATA PUMP

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

Session 7: ENHANCEMENTS TO DATABASE AUDITING

  • Use Mixed Mode Auditing or Migrate to Pure Unified Auditing
  • Enhancements to Unified Auditing 18c & 19c
  • Audit Top Level User Activities in 19c
  • Audit a Read-Only Database to the Operating System in 19c
  • Use Oracle Data Pump to Export and Import the Unified Audit Trail

Session 8: ENHANCEMENTS TO PRIVILEGES AND PROFILES

  • 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

Day 3

Session 9: NEW RMAN FEATURES

  • 12.2 RMAN Syntax Enhancements
  • Enhnced 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

Session 10: MISCELLANEOUS NEW FEATURES

  • Cancel a SQL Statement in a Session from 18c
  • Online Redefinition Enhancements from 18c
  • Use Private Temporary Tables from 18c
  • Miscellaneous Data Redaction Enhancements
  • New Algorithm for Tablespace Encryption from 19c
  • 12.2 INMEMORY_SIZE Parameter
  • 12.2 INMEMORY Enhancements

Session 11: SQL AND PL/SQL ENHANCEMENTS

  • 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
  • Markup CSV
  • New Approximate Functions
  • LISTAGG DISTINCT from Oracle 19c
  • Remove Duplicates from LISTAGG Results using DISTINCT
  • DBMS_SESSION.SLEEP Replaces DBMS_LOCK.SLEEP from 18c
  • Real Time Materialized View Enhancements
  • PL/SQL Enhancements
  • PL/SQL Scope Enhancements
  • The Deprecate Pragma for PL/SQL
  • Code coverage using DBMS_PLSQL_CODE_COVERAGE
  • Package White Lists Enhancements

Session 12: PERFORMANCE TUNING NEW FEATURES

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

Day 4

Session 13: BIG DATA AND DATA WAREHOUSE NEW FEATURES

  • 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
  • Automatic SQL Plan Management
  • SQL Statements Terminated by the Resource Manager Quarantined
  • Improved Diagnosis and Repair Capabilities with the Test Case Builder and the SQL Repair Advisor
  • COUNT(DISTINCT) Rollup
  • Polymorphic Tables Enhancements
  • HCC Data Compression with an ADO Row-level policy

Session 14: PARTITIONING ENHANCEMENTS

  • 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
  • Online MERGE PARTITION and MERGE SUBPARTITION in 18c
  • Hybrid Partitioned Tables - Integrate Internal and External Partitions

Session 15: DATA PUMP ENHANCEMENTS

  • 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

Session 16: SQL*LOADER AND EXTERNAL TABLE ENHANCEMENTS

  • 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

Day 5

SESSION 17: DATABASE DIAGNOSTIC NEW FEATURES

  • 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
  • Quarantined Objects

Session 18: DATA GUARD NEW FEATURES

  • 12.2 Data Guard New Features
  • Use the DBCA and EM Command Line Interface to Create Standby Databases
  • Create Scripts with the Broker DGMGRL Command Line Interface
  • Automatic Password File Management
  • Simple Repair of No Logging Operations
  • Perform Data File Block Comparison Between the Primary and a Standby
  • Multiple Fast Start Failover Targets and Observers
  • Fast Start Failover in Maximum Protection mode
  • Zero Data Loss Failovers in any Mode with Storage Failures
  • Enhanced Control of Alternative Destinations
  • Use RMAN and Enterprise Manager to create Far Sync Instances
  • 18c Data Guard New Features
  • New Broker VALIDATE Commands
  • Multi-Instance Redo Apply
  • Keep Buffer Cache at Role Change
  • 19c Data Guard New Features
  • New Broker Commands
  • Export and Import the Broker Configuration File
  • Dynamically Change Fast Start Failover Target using the Data Guard Broker
  • Observe Only Mode to Test Fast Start Failover
  • Data Guard Physical Standby using the Data Guard Broker in 18c and 19c
  • Automatically Replicate Restore Points from Primary to Standby
  • Flashback a Standby Database when the Primary is Flashed Back
  • Periodically Clear the Flashback Logs
  • Active Data Guard Redirection

Session 19: ACTIVE DATA GUARD NEW FEATURES

  • 12.2 Active Data Guard New Features
  • Use all Standby Instances to Apply Redo
  • Data Guard Broker Support for DBMS_ROLLING Upgrades
  • Use AWR and SQL Tuning Advisor to diagnose and Tune Redo Apply and Query Issues on an Active Data Guard Standby
  • Move Users Transparently During Role Change on the Primary and Preserve Existing Connections at the Active Data Guard Standby
  • Increased Protection with Auto Block Repair Enhancements
  • Control Login Attempts
  • 18c Active Data Guard New Features
  • New RECOVER STANDBY DATABASE FROM SERVICE
  • Execute DML
  • Create Global Temporary Tables
  • Standby Nologging for Load Performance
  • Standby Nologging for Data Availability

Session 20: TRANSPARENT SENSITIVE DATA PROTECTION

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

Session 21: APPLICATION CONTINUITY ENHANCEMENTS

  • Server Draining Prior to Stopping or Relocating Services
  • Oracle Database Recognition of Request Boundaries
  • Transparent Application Continuity
  • Application Continuity for Java
    • New States Management
    • Declarative Request Demarcation

Related Courses

Privacy Notice

In order to provide you with the service requested we will need to retain and use your contact information in accordance with our Privacy Notice. If you choose to provide us with this information you explicitly consent to us using the information as necessary to provide the requested service to you. If you do not agree please do not proceed to request the service from us.

Marketing Permissions

Would you like to receive our newsletter and other information on products and services which we think will be of interest to you by email. We will always treat your information with care and in accordance with our Privacy Notice. You are free to withdraw this permission at any time.

 

We work with the best