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

Course Code: ONF

Duration: 5 days

 
 
 
 

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

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

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 Multitenant 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.

Course 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.

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 into their databases where appropriate.

Skills Gained

The delegate will learn and acquire skills as follows:

  • Install the Oracle Database 19c software with the OUI
  • Create a non-container or container Oracle Database 19c Database
  • Upgrade an Oracle database to Oracle 19c
  • Migrate a database to Oracle 19c with Data Pump
  • Plug-in a non-container 19c database into a container database
  • 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 related new features
  • Data Pump, SQL*Loader and External Table new features
  • Table 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

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

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 19c 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: PREPARE THE SERVER FOR ORACLE DATABASE SOFTWARE INSTALLATION

  • 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

Session 3: INSTALL THE ORACLE DATABASE SOFTWARE

  • Interactive Oracle 19c 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

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

  • 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 19c Demonstration Database using Silent Mode
  • Post Database Creation Tasks
  • Delete a database with the DBCA Silent Mode
  • Configure Read Only Oracle Homes in Oracle Database 18c/19c

Session 5: PREPARATION FOR UPGRADE TO ORACLE DATABASE

  • 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

Session 6: PERFORM AN UPGRADE

  • The Manual Upgrade of a Database to 19c
  • Execute preupgrade.jar
  • Upgrade a Database with the Database Upgrade Assistant (DBUA)
  • Run the DBUA in Silent Mode
  • Use the Oracle Database Autoupgrade Utility
  • Post Upgrade Checks
  • Manually Start a Failed Upgrade
  • Common Installation Errors
  • Carry out Post Upgrade Checks
  • Check the /etc/oratab File
  • Check the Database Version
  • Run OPatch Commands
  • Enterprise Manager Express Configuration
  • Carry Out Post Upgrade Tasks
  • Migrate to Unified Auditing
  • Deprecated and Desupported Database Parameters
  • Plug a Non-Container Database into a 19c Container Database

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

Session 7: MIGRATE DATA WITH DATA PUMP

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

Session 8: ENHANCEMENTS TO DATABASE AUDITING

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

Session 9: ENHANCEMENTS TO SECURITY PRIVILEGES AND PROFILES

  • SYSRAC Administrative Privilege for RAC and Grid Infrastructure
  • Administrative User Authentication Enhancements
  • The READ Object Privilege
  • Automatically Lock Inactive accounts
  • Administrative Password Security Enhancements
  • Schema Only Accounts from 18c
  • Enhanced Security with Password Removal from Schema Only Accounts from 19c
  • Grant Administrative Privileges to Schema Only Accounts
  • 19c Privilege Analysis Available 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

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

Session 10: NEW RMAN FEATURES

  • Change to the Usage of the SYSBACKUP Privilege
  • RMAN Syntax Enhancements
  • Execute SQL Statements in RMAN
  • Use the RMAN DESCRIBE Command
  • The Enhanced SET NEWNAME Command
  • Improvements to the Backup and Restore of Very Large Files
  • Enhanced Table Point in Time Recovery
  • The Enhanced REPAIR FAILURE Command
  • Table or Partition Recovery Enhancements
  • Recover a Database after Missing Redo Logs Found
  • Run the DUPLICATE Operation with the NOOPEN Option
  • Simplified Cross Platform Migration

Session 11: MISCELLANEOUS NEW FEATURES

  • Automatic Memory Management Restrictions
  • Overview of Temporary UNDO
  • The Online Rename and Relocation of an Active Data File
  • Cancel a SQL Statement in a Session
  • Online Redefinition Enhancements from 18c
  • Use Private Temporary Tables from 18c
  • Miscellaneous Data Masking Enhancements
  • Overview of Oracle Data Redaction
  • Miscellaneous Data Redaction Enhancements
  • INMEMORY_SIZE Parameter Changes and Enhancements

Session 12: SQL ENHANCEMENTS

  • SQL*Plus Enhancements
  • The sqlcl Utility
  • 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
  • Remove Duplicates from LISTAGG Results using DISTINCT
  • Real-Time Materialized View Enhancements
  • Approximate Query Processing and Real-Time Materialised Views

Session 13: PL/SQL ENHANCEMENTS

  • Using the WITH Clause
  • PL/SQL Enhancements
  • DBMS_SESSION.SLEEP Replaces DBMS_LOCK.SLEEP
  • 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

Session 14: PERFORMANCE RELATED NEW FEATURES

  • Overview of Performance Tuning New Features
  • Adaptive Query Optimization in an Oracle Database
  • SQL Plan Management (SPM) Overview
  • 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
  • Monitor the Usage of Indexes

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

Session 15: BIG DATA AND DATA WAREHOUSE NEW FEATURES

  • Reduce Cursor Invalidations for DDLs
  • Automatic Indexing 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

Session 16: PARTITIONING ENHANCEMENTS

  • Oracle Partitioning Overview
  • New Oracle Partitioning Strategies prior to 12.1
  • Partitioning Strategies Introduced in 12.1
  • New Partitioning Strategies from 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 from 18c
  • Hybrid Partitioned Tables - Integrate Internal and External Partitions

Session 17: DATA PUMP ENHANCEMENTS

  • Oracle Data Pump New Features Introduced from 12c
  • 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 18: SQL*LOADER AND EXTERNAL TABLE ENHANCEMENTS

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

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

SESSION 19: DATABASE DIAGNOSTIC NEW FEATURES

  • Automatic Diagnostic Repository (ADR) New Features
    • Long Date Formats in the alert.log
    • ADR New File Types and Locations
    • The DDL and Debug Logs
    • The ADRCI SHOW LOG Command
    • Set an ADR Retention Target from 12.2
  • The UNDO Retention Advisor
  • The Trace File Analyzer (TFA) Collector
    • Overview of the TFA
    • Install the TFA Collector Prior to 19c
    • Post Install of the TFA Collector Prior to 19c
    • Download the Latest Version of the TFA for 19c
    • Install the TFA Collector in 19c
    • Automatic Startup of the TFA from the TFA Installation
    • Manage the TFA daemon
    • tfactl Help
    • Start and stop the TFA Collector
    • One Command Service Request Data Collections
    • Quick System and Cluster Summary Reports
  • Create a Database Operation
  • Quarantined Objects

Session 20: TRANSPARENT SENSITIVE DATA ENCRTPTION (TDE) ENHANCEMENTS

  • Overview of New Security Features Support for TDE
  • Create, Open and Manage a Keystore
  • Table Encryption Enhancements
  • Encrypt and Decrypt a Tablespace Online
  • Encrypt SYSTEM, SYSAUX and Temporary Tablespaces
  • Duplicate a Database that uses TDE
  • TSDP Policies for 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

Session 21: DATA GUARD NEW FEATURES

  • 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
    • The V$DATAGUARD_PROCESS View
    • 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

Session 22: ACTIVE DATA GUARD NEW FEATURES

  • 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
  • RECOVER STANDBY DATABASE FROM SERVICE
  • Create Global Temporary Tables
  • Standby NOLOGGING for Load Performance
  • Standby NOLOGGING for Data Availability

Session 23: APPLICATION CONTINUITY ENHANCEMENTS

  • 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

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

Session A: DEMONSTRATION TABLES

Session B: CONTAINER AND PLUGGABLE DATABASE CRIB SHEET

  • Connect to a Container Database as an Administrator
  • Connect to a Container Database using a Service Name
  • Connect to a Pluggable Database
  • Display the Current Container
  • Switch between Containers
  • Start Up and Shutdown a CDB
  • Open and Close a PDB
  • Alter a Pluggable Database
  • Open and Close All PDBS
  • Automatic Start Up of Pluggable Databases
  • Preserve or Discard the PDB Open Mode after a CDB Restart
  • Change the State of a PDB
  • Configure Instance Parameters in a CDB and PDBs

Session C: DATA GUARD QUICK SETUP GUIDE

  • Data Guard Physical Standby using the Data Guard Broker
  • Primary Server Setup
  • Configure Initialization Parameters
  • Service Setup
  • Standby Server Setup
  • Enable the Broker
  • Database Switchover
  • Database Failover
  • Configure the Original Primary as a Standby using Flashback Database
  • Configure the Original Primary as a Standby without Flashback
  • Read-Only Standby and Active Data Guard
  • Snapshot Standby
Notes:
  • 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.

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

Course Reviews

Explained clearly with enthusiasm. Let's people actively cooperate in the course and think about solutions. Does the extra effort...

Alain - Oracle Financials DBA - Finance

Absolute great course! very detailed and all the areas of the course were covered without any issues. All questions were answered and the lab explanations were very clear also.

pamandeep - Oracle & SQL SERVER DBA - Manufacturing

Trainer was very well prepared and content was to the point

Raymond - Database Administrator - Finance

Public Scheduled Events

Classroom & Live Virtual Instructor-Led Training

Duration: 5 days

Price: £2,750.00 exc. VAT 


Start Date Options Spaces  
13 May 2024
StayAhead Virtual Courses available 
Spaces Book Now 
01 Jul 2024
StayAhead Virtual Courses available 
Spaces Book Now 
19 Aug 2024
StayAhead Virtual Courses available 
Spaces Book Now 
14 Oct 2024
StayAhead Virtual Courses available 
Spaces Book Now 
09 Dec 2024
StayAhead Virtual Courses available 
Spaces Book Now 
 

Live Virtual Classroom

 
Join live instructor-led classroom training from the comfort of your home or office.
All the convenience and benefits of the classroom experience without the hassle and costs of travel and accommodation.
 
 



Our Customers Include

 
EDF
Amazon
American Express
Aviva
QA
BAE
University of Cambridge
Barnardo's
Scottish Government
Bauer
Bloomberg
BP
HSBC
DVLA
GlaxoSmithKline
Government Campus
Capita
Tui
NHS
Ordnance Survey
Ministry of Defence
Zurich Insurance Group
trainline
Vodafone
 
 



Our Course Curriculum

 
 
 
+44 (0)20 7600 6116
Enquiries@StayAhead.com
Copyright © 2024 StayAhead Training Ltd
Cookies   /   Privacy Policy