Oracle 12c New Features for Administrators
 
 

Oracle 12c New Features for Administrators

Course Code: O12C11

Duration: 5 days

Our training courses can also be delivered at a location of your choice...

S6

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

This Oracle Database 12cR2, 18c and 19c New Features for Administrators Course Overview 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

Who will the Course Benefit?

This 'Oracle Database 12cR2, 18c and 19c New Features for Administrators Course Overview' 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.

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.

Requirements

Delegates attending the 'Oracle Database 12cR2, 18c and 19c New Features for Administrators Course Overview' 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.

Follow-On Courses

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.


 

Course Contents

Oracle 12c 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 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: 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 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 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

Session 5: PREPARATION FOR UPGRADE TO ORACLE DATABASE 12cR2, 18c or 19c

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

Oracle 12c 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 AND SECURITY

  • 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

Session 9: ENHANCEMENTS TO PRIVILEGES AND PROFILES

  • 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

Oracle 12c New Features for Administrators Training Course

Session 10: NEW RMAN FEATURES

  • 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

Session 11: MISCELLANEOUS NEW FEATURES

  • 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

Session 12: 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
  • 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

Session 13: PL/SQL ENHANCEMENTS

  • PL/SQL Enhancements
  • DBMS_SESSION.SLEEP Replaces DBMS_LOCK.SLEEP from 18c
  • 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 TUNING NEW FEATURES

  • 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

Oracle 12c New Features for Administrators Training Course

Session 15: 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
  • 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

  • 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 from 18c
  • Hybrid Partitioned Tables - Integrate Internal and External Partitions

Session 17: 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 18: 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

Oracle 12c New Features for Administrators Training Course

SESSION 19: 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
  • Create a Database Operation
  • Quarantined Objects

Session 20: 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 21: 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 22: TRANSPARENT SENSITIVE DATA PROTECTION ENHANCEMENTS

  • 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

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 12c New Features for Administrators

Duration: 5 days

RRP: £2,250.00 exc. VAT 


Upcoming Scheduled Events
Next 6 months

London
Start Date   Spaces Book
30 Mar 2020   Filling StayAhead - Course Running Book
 
08 Jun 2020   Spaces StayAhead - Course Running Book
 
03 Aug 2020   Spaces StayAhead - Course Running Book
 
28 Sep 2020   Spaces StayAhead - Course Running Book
 
30 Nov 2020   Spaces StayAhead - Course Running Book
 
Virtual Events StayAhead Virtual Courses available You can attend your training virtually using the London dates shown above. Please contact us for more details on our Virtual training options or to discuss specific Virtual course dates to meet your requirements.
 

Course Reviews

I very much enjoyed the course. The course content was spot on and delivered in a very effective manner by the instructor. The pace was good (not too fast) and meant that there was sufficient time to discuss (with other delegates and the instructor) how some of the new features could be used in practice.

Ryan - DBA - Academic


The course was excellent as was the trainer. Very attentive and obviously well skilled at the subject matter. Would happily recommend.

Howard - Oracle Database Administrator - Professional Services


Very good course with excellent instructor.

Kusal - Operational Oracle DBA - NHS


More Course Reviews....

Course provided the necessary update to my knowledge and skills.

Sean - Academic


Enjoyed the course and the Trainer was excellent at explaining everything.

Kevin - DBA - Insurance


 
 
 
        Home             Let Us Call You
 

 

Course Deliveries

Public Scheduled and Closed
Virtual
UK and Overseas

OUG

Oracle User Group - Membership Benefits

OUG

Certification

Our independent Oracle, Solaris & Red Hat Linux curriculums helps prepare delegates for official certification.

StayAhead
Flexibility

Cannot see a sutiable date?
Please call us and we will try an accommodateyour needs!




Our Course Curriculum

 
 
 
 
 



Our Ratings

Instructor
Quality
 

97.33%

Course
Practical
 

92.77%

Overall
Courseware
 

94.34%

Overall
Course
 

96.39%

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