0845 450 6120

Oracle 12CR2 New Features for 12CR1 Administrators

This Oracle 12CR2 New Features for 12CR1 Administrators course is designed to give Oracle 12cR1 Database Administrators practical experience in using the new features that have been  introduced in Oracle Database 12cR2.

The delegate will gain an appreciation of how the enhanced features of Oracle Database 12c Release 2 may be implemented at their own sites.

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

The delegate will gain an understanding of:

  • Install the Oracle Database 12cR2 software with the OUI
  • Create a container and pluggable database with the DBCA
  • Use new methods to create Pluggable databases
  • Create a PDB with Local UNDO
  • Hot Clone a PDB
  • Create and Manage Application Containers
  • Plug and unplug a database with a PDB archive file
  • Relocate a PDB to a new container
  • Recover and flashback at PDB level
  • Create and manage and implement security in Application root and Application Container PDBs
  • Manage performance at a PDB level
  • Upgrade multitenant and pluggable databases
  • Unified Auditing New Features
  • Data Redaction and Data Encryption new features
  • Transparent Sensitive Data protection
  • New RMAN and availability features
  • Data Pump, SQL*Loader and External Table new features
  • In-Memory Column Store new features to increase SQL performance
  • SQL Tuning enhancements using the Optimizer Statistics Advisor and SQL join processing
  • Manage resources with Resource Manager performance profiles and memory directives
  • Use the Trace File Analyzer to collect and diagnose issues
  • Partitioning enhancements
  • Use the SQL*Plus history commands and the SQLcl utility
  • Use new SQL and PL/SQL features
  • An understanding of the Oracle Public Cloud Services

Who will the Seminar Benefit?

This Oracle 12CR2 New Features for 12CR1 Administrators course is designed for Oracle professionals who need to gain an understanding of and implement the new features and functionality  introduced in Oracle Database 12cR2.

We don't currently have any courses listed for Oracle 12CR2 New Features for 12CR1 Administrators, would you like to view all courses for Oracle?

Learning Objectives

This course aims to provide the delegate with the knowledge to be able to implement the new features introduced in Oracle Database 12cR2.

Pre-Requisites

Requirements

Delegates attending this Oracle 12CR2 New Features for 12CR1 Administrators course should have administration experience of Oracle Database 12.1.0.2. They should also have knowledge of  the usage of container and pluggable databases in 12.1.0.2. Knowledge of using PL/SQL packages is strongly recommended.

Course Notes

This course is run on a Linux operating system and therefore a good working knowledge of UNIX/Linux is required.

Pre-Requisite Courses

  • Oracle 12c New Features for Administrators

Follow-On Courses

  • Oracle Database 12c RAC and Grid Infrastructure Administration
  • Oracle Database 12c Data Guard
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 Content

Course Contents - DAY 1

Course Introduction

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

Session 1: ORACLE DATABASE 12cR2 DATABASE INSTALLATION

  • Software Pre-Installation Tasks
  • Install the Oracle Database 12cR2 software with the OUI
  • Create a container and pluggable database with the DBCA
  • Post creation tasks

Session 2: CREATE PDBS USING NEW METHODS

  • Parallel PDB creation
  • Create a PDB with a default tablespace
  • Local UNDO mode
  • Hot clone a PDB
  • Refresh a Read Only PDB
  • Plug and unplug a PDB using a PDB archive file
  • Relocate a PDB to a new container
  • Remote proxy PDBs

Session 3: RECOVERY AND FLASHBACK AT PDB LEVEL

  • Shutdown a PDB with critical datafiles missing
  • Flashback a pluggable database at PDB level
  • Create a restore point at CDB and PDB level
  • Create a clean restore point
  • Flashback a PDB in local and shared undo mode

Course Contents - DAY 2

Session 4: APPLICATIONS AND APPLICATION CONTAINERS

  • Application Root and Application Container PDBs
  • Create an Application Container
  • Open an Application Container
  • Create network services
  • Drop an Application Container
  • Manage Applications
  • Install and uninstall an Application
  • Upgrade an Application
  • Drop an Application Container
  • Manage an Application seed
  • Application common objects
  • Application Container views

Session 5: PDB SECURITY

  • Create common and local users in an application
  • Grant common and local privileges in an application
  • Create and grant common and local roles in application containers
  • Use common and local objects and profiles in an application
  • Application common objects
  • Implement Lockdown Policies
  • Assign a lockdown profile to a PDB

Session 6: PDB PERFORMANCE MANAGEMENT

  • Automatic Workload Repository Data at CDB and PDB Level
  • Enable PDB snapshots
  • Disable AWR for a PDB with a Lockdown profile
  • Set SGA and PGA for a PDB
  • Share Resource between PDBs
  • PDB Profile Directives
  • Share Based Instance Caging
  • Limit I/O rates for PDBs
  • Use PDB Resource Plans

Session 7: UPGRADE TO ORACLE DATABASE 12c

  • Prepare to upgrade a database from 12.1.0.2 to 12.2
  • Execute preupgrade.jar
  • Upgrade a database with the Database Upgrade Assistant (DBUA)
  • Upgrade a database manually
  • Post upgrade tasks
  • Plugin an upgraded database as a PDB into a CDB

Course Contents - DAY 3

Session 8: PRIVILEGES AND USER PROFILES

  • The SYSRAC Administrative privilege
  • Administrative user authentication enhancements
  • Administrative password security enhancements
  • Automatically lock inactive accounts
  • Control definer's rights privileges for database links

Session 9: UNIFIED AUDITING ENHANCEMENTS

  • Enable Unified Auditing
  • New unified audit trail
  • Audit policy enhancements
  • Unified Audit enhancements
  • Audit by role
  • Purge old audit data
  • Capture the predicate clause when using VPD

Session 10: DATA REDACTION ENHANCEMENTS

  • Grant Data Redaction privileges to a user
  • Online rename and relocation of an active datafile
  • NULL as a redacted value
  • Named policy expressions
  • Miscellaneous Data Redaction enhancements

Session 11: DATA ENCRYPTION ENHANCEMENTS

  • Transparent Data Encryption
  • Create and open a Keystore
  • Start a CDB and PDBs with a Keystore
  • Table encryption
  • Tablespace encryption
  • Encrypt SYSTEM, SYSAUX and temporary tablespaces
  • The ALTER TABLESPACE ENCRYPTION FINISH Clause
  • Considerations when deciding to use online tablespace encryption

Session 12: TRANSPARENT SENSITIVE DATA PROTECTION

  • New security features support for TSDP
  • TSPD with Unified Auditing
  • TSPD with Fine-Grained Auditing
  • TSPD with TDE Column Encryption
  • Auditing parameters used with TSDP policies
  • TSDP data dictionary views

Session 13: AVAILABILITY ENHANCEMENTS

  • RMAN syntax enhancements
  • Recover a database after missing redo logs found
  • Duplicate a database using TDE
  • RMAN duplication of TDE tablespaces
  • Enhanced table point in time recovery
  • The enhanced REPAIR FAILURE command
  • Online Redefinition enhancements

Course Contents - DAY 4

Session 14: DATA PUMP, SQL*LOADER AND EXTERNAL TABLE ENHANCEMENTS

  • Data Pump enhancements
  • SQL*Loader enhancements
  • External Table enhancements

Session 15: IN-MEMORY COLUMN STORE NEW FEATURES

  • The IN_MEMORY_SIZE parameter
  • Enable database in memory
  • Cache results of query expressions and virtual columns
  • Configure In-Memory FastStart
  • Create Join Groups

Session 16: SQL TUNING ENHANCEMENTS

  • New default values for OPTIMIZER_ADAPTIVE parameters
  • Adaptive Query optimization enhancements in 12.2
  • The Optimizer Statistics Advisor rules, findings, recommendations and actions
  • The Expression Statistics Store
  • Continuous Adaptive Query plans
  • Enhancements to the SQL Performance Analyzer
  • Enhancements to SQL Plan Management
  • Execution plan capture from AWR
  • Automatic Capture files

Session 17: RESOURCE MANAGER ENHANCEMENTS

  • Memory Resource management for PDBs
  • Manage session PGA limit
  • Control memory usage for PDBs
  • PDB memory parameters
  • Set PDB memory parameters
  • Monitor memory usage for PDBs
  • The SESSION_PGA_LIMIT parameter
  • Limit session PGA with a resource plan
  • Reduce cursor invalidations for DDLs
  • Advanced Index compression
  • HCC data compression with an ADO Row-level policy

Course Contents - DAY 5

Session 18: PARTITIONING NEW FEATURES

  • New Oracle 12.2 partitioning strategies
  • 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

Session 19: DIAGNOSABILITY

  • Set an ADR retention target
  • The Retention Advisor
  • The TFA Collector
  • Install the TFA Collector
  • Manage the TFA daemon
  • Start and stop the TFA Collector
  • Dynamic Data Pump tracing

Session 20: ORACLE DATABASE CLOUD SERVICES OVERVIEW

  • Create a Database as a Service
  • Create a SSH key pair
  • Create a service
  • Connect to the VM using ssh
  • racle Compute Cloud service - network firewall
  • Connect to the database using Oracle Net

Session 21: NEW FEATURES FOR DEVELOPERS

  • The SQLcl command line interface
  • The login.sql file
  • SQL*Plus command line history
  • Longer object names
  • SQL*Plus performance settings options
  • Markup CSV
  • Conversion function enhancements
  • Real Time Materialized View enhancements
  • Approximate query processing
  • PL/SQL Scope enhancements
  • The deprecate pragma for PL/SQL
  • Code coverage using DBMS_PLSQL_CODE_COVERAGE
  • Package White Lists

Exams & Certification

This course together with the Oracle 12c New Features for Administrators course will aid the delegate  in their preparation for the following exam:

  • Upgrade Oracle DBA 11g or 12c to 12c R2 1Z0-074.

Attending this course will help the delegate gain many of the skills and practical knowledge requirements as outlined in the exam objectives. Studying this course  and its associated reference materials can form part of the preparation to achieve certification.

Experience, practice and self-study and aptitude are also key  requirements for exam success. An integrated multifaceted exam preparation approach is recommended.

Before taking any exam, ensure you have the recommended experience. The Oracle website lists all exam requirements and these are updated regularly.

Exams are not included as part of the course.

One Month
Two Months
Three Months
More than Three Months
PRINCE2 Foundation & Practitioner
MSP Foundation & Practitioner
APMP Certificate
ITIL Foundation
Scrum in One Day
Certified ScrumMaster
ISTQB Software Test Foundation
Microsoft Project
BCS Business Analysis Practice
Other - Please Specify Below

Our Customers Include