0845 450 6120

Oracle Database 12cR1 and 12cR2 New Features for 11gR2 Administrators

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

The delegate will gain an appreciation of how the enhanced features of Oracle Database 12cR1 and 12cR2 may be implemented at their own sites.

Note: This course covers an overview only of container and pluggable databases.

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 software with the OUI
  • Create a non-container Oracle Database 12cR2 Database
  • Upgrade an Oracle 11gR2 database to Oracle 12cR2
  • New database management features
  • Implement Unified Auditing
  • Implement and use Administrative privileges
  • Schema and data management new features
  • Enable Privilege Analysis
  • 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 new features
  • Performance tuning new features
  • Adaptive Execution Plans
  • SQL Plan Directives
  • Real-Time ADDM
  • New Data Pump, SQL*Loader and External Table features
  • Partitioning enhancements
  • Transparent Sensitive Data protection
  • Use 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
  • The Trace File Analyzer to collect and diagnose issues
  • Configure a heat map
  • Temporal history and validity

Who will the Course Benefit?

This Oracle Database 12cR1 and 12cR2 New Features for 11gR2 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 12cR1 and 12cR2.

Learning Objectives

Course Objectives

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

Pre-Requisites

Requirements

Delegates attending the  Oracle Database 12cR1 and 12cR2 New Features for 11gR2 Administrators course should have administration experience of Oracle Database 11.2. 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.

Pre-Requisite Courses

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

Follow-On Courses

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

Day 1

Course Introduction

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

Session 1: CHANGES TO DATABASE MANAGEMENT TOOLS

  • Enterprise Manager Express Home Page
  • SQL Developer new functionality
  • Changes to the OUI and the DBCA

Session 2: ORACLE DATABASE 12cR2 ARCHITECTURE

  • 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
  • Plan an installation
  • System requirements and operating system prerequisites
  • Install the Oracle Database 12cR2 software with the OUI
  • The Oracle Inventory
  • Silent mode installation
  • Database software de-install

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

  • Select a database storage method
  • Select a CDB or non-CDB database
  • Select a database type based on workload
  • Select a character set for the database
  • Set the NLS_LANG initialization parameter
  • Create a database with the DBCA

Session 4: PREPARATION FOR UPGRADE TO ORACLE DATABASE 12cR2

  • Methods used to perform upgrade
  • Methods of data migration
  • Direct upgrade supported releases
  • 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
  • Backup the database
  • Install the Oracle Database 12cR2 software
  • Create the new Oracle home

Session 5: PERFORM AN UPGRADE TO ORACLE DATABASE 12cR2

  • Execute preupgrade.jar
  • Upgrade a database with the Database Upgrade Assistant (DBUA)
  • Upgrade a database manually
  • Deprecated database features and parameters

Session 6: POST UPGRADE TASKS

  • 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

Session 7: MIGRATE DATA WITH DATA PUMP

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

Day 2

Session 8: NEW TABLESPACES AND MANAGEMENT FEATURES

  • Data storage overview
  • Online rename and relocation of an active datafile
  • Restrict PGA size
  • Implement extended data types for VARCHAR2, NVARCHAR2 and RAW data types to 32767 bytes
  • Temporary UNDO
  • DDL Logging
  • Full Database Caching mode
  • Smart Flash Cache
  • Automatic Big Table Caching
  • An overview of In-Memory Column Store

Session 9: ONLINE DATAFILE MOVE AND AUTOMATIC DATA OPTIMIZATION

  • Move datafiles online
  • Data classification in 12c
  • Configure a heat map
  • Automatic movement and compression
  • Compression levels and types

Session 10: IN DATABASE ARCHIVING

  • Enhancements to Flashback Database Archive
  • New In-database archiving solutions
  • Use the ROW ARCHIVAL clause to enable row lifecycle state for applications
  • Set the ROW ARCHIVAL VISIBILITY for session level visibility control
  • Use predicate on ORA_ARCHIVE_STATE column
  • Set a Temporal Validity: PERIOD FOR with the CREATE or ALTER TABLE clause
  • SQL temporal data type

Session 11: ENHANCEMENTS TO DATABASE AUDITING

  • Overview of database security
  • Overview of database auditing in Oracle Database 12c
  • Security compliance
  • Standard auditing
  • new unified audit trail overview
  • Create a tablespace for the Unified Audit Trail
  • Separation of audit responsibilities with the AUDIT_ADMIN and AUDIT_VIEWER roles
  • Configure the Unified Audit Trail
  • Specify audit options
  • Configure the Unified Audit Trail to set a tolerance level for lost of audit records
  • Create audit policies for privilege, action and component auditing
  • Audit policy enhancements
  • Audit by role
  • Purge old audit data

Day 3

Session 12: ENHANCEMENTS TO PRIVILEGES AND PROFILES

  • Implement the separation of duties for Database Administration tasks
  • Changes to tablespace quotas
  • Read object privileges
  • New password verification functions
  • Administrative user authentication enhancements
  • Administrative password security enhancements
  • Automatically lock inactive accounts
  • Control definer's rights privileges for database links
  • 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

Session 13: DATA REDACTION

  • Overview of Oracle Data Redaction
  • Types of data masking policies
  • Administer the EXEMPT REDACTION POLICY system privilege to enable a user to view unmasked values
  • Manage masking policies
  • Understanding the masking of statements containing nested functions and subqueries
  • Grant Data Redaction privileges to a user
  • NULL as a redacted value
  • Named policy expressions
  • Miscellaneous Data Redaction enhancements
  • Query the data dictionary to obtain information on masking policies

Session 14: 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 15: 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 16: NEW RMAN FEATURES

  • The SYSBACKUP privilege
  • Execute SQL statements in RMAN
  • Use the RMAN DESCRIBE Command
  • RMAN syntax enhancements
  • Enhanced table point in time recovery
  • The enhanced REPAIR FAILURE command
  • Create multi-section backups
  • Table or partition recovery
  • Restore and recover datafiles across the network
  • Run the duplicate database operation with the NOOPEN option
  • Backup and restore very large files
  • Cross platform backup and restore
  • Recover a database after missing redo logs found
  • Duplicate a database using TDE
  • RMAN duplication of TDE tablespaces

Day 4

Session 17: SCHEMA AND DATA CHANGES

  • Create identity columns
  • Create a table with invisible columns
  • Set default values for table columns
  • Truncate table cascade
  • Session level sequences
  • Create multiple indexes on the same set of columns
  • Advanced Row Compression
  • The Schema Change Plan flow
  • Change requests
  • Schema synchronization
  • The Data Comparison package
  • Comparison job results

Session 18: SQL AND PL/SQL ENHANCEMENTS

  • SQL*Plus Enhancements
  • Last login time
  • The login.sql file
  • SQL*Plus command line history
  • SQL*Plus performance settings options
  • The SQLcl command line interface
  • Longer object names
  • Markup CSV
  • Row limiting for Top-N result Queries
  • The APPROX_COUNT_DISTINCT function
  • Approximate query processing
  • Conversion function enhancements
  • PL/SQL Enhancements
  • Implicit results on SQL*Plus
  • WITH clause enhancements
  • Real Time Materialized View enhancements
  • PL/SQL Scope enhancements
  • The deprecate pragma for PL/SQL
  • Code coverage using DBMS_PLSQL_CODE_COVERAGE
  • Package White Lists

Session 19: PERFORMANCE TUNING NEW FEATURES

  • Overview of performance tuning new features
  • The Adaptive Optimizer
  • Default values for OPTIMIZER_ADAPTIVE parameters
  • Adaptive Query optimization enhancements in 12.2
  • Continuous Adaptive Query plans
  • The Optimizer Statistics Advisor rules, findings, recommendations and actions
  • The Expression Statistics Store
  • Enhancements to SQL Plan Management
  • SQL Plan Directives
  • Dynamic statistics
  • Online statistics gathering for bulk loads
  • Gather statistics concurrently for multiple tables
  • Histogram enhancements
  • Enhancements to extended statistics
  • Overview of new ADDM Analysis features
  • Emergency Monitoring
  • Real time ADDM analysis
  • Define Workload dimensions
  • Enhancements to the SQL Performance Analyzer
  • Execution plan capture from AWR
  • Automatic Capture files

Session 20: RESOURCE MANAGER AND OTHER PERFORMANCE ENHANCEMENTS

  • Automated maintenance tasks
  • The Multithreaded Model using Threaded Execution
  • Manage session PGA limit
  • Reduce cursor invalidations for DDLs
  • Advanced Index compression
  • HCC data compression with an ADO Row-level policy

Day 5

SESSION 21: ADR NEW FILE TYPES AND NETWORK COMPRESSION

  • ADR file types
  • New File types
  • New File locations
  • New commands for ADRCI
  • Improve performance by using Network Compression
  • Setup Compression

SESSION 22: DATA PUMP AND SQL*LOADER ENHANCEMENTS

  • Data Pump enhancements
  • Turn off redo log generation
  • Transport view as table
  • Dumpfile compression
  • Password encryption enhancements
  • Use FULL Transportable export and import
  • SQL*Loader enhancements
  • SQL*Loader and External table common enhancements
  • SQL*Loader Express
  • External Table Enhancements

SESSION 23: PARTITIONING ENHANCEMENTS

  • Move a partition online
  • An overview of the ALTER TABLE ... SPLIT PARTITION, ALTER TABLE ... MERGE PARTITION , ALTER TABLE...ADD PARTITION clauses
  • The split partition operation enhancement
  • The merge partition operation
  • The Add and drop partition operations
  • 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 24: 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 25: MONITORING DATABASE OPERATIONS

  • Overview of DB monitoring operations
  • Define a DB operation
  • Bracketing an operation
  • Monitoring the progress of operations
  • DB Operation tuning
  • DB Operation Active report

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

 

Our Customers Include