Courses Details
Course Overview
The Oracle Database 12c R2: Administration Workshop Ed 3 course is designed to provide you with a firm foundation in administration of an Oracle Database. In this course you will gain a conceptual understanding of Oracle Database architecture and learn how to manage an Oracle Database in an effective and efficient manner.

Learn To:

  • Manage an Oracle Database instance.
  • Configure the Oracle Network environment.
  • Create and manage storage structures.
  • Manage and move data.
  • Create and manage users.
  • Monitor the database and manage performance.
  • Create and manage Database as a Cloud Service database deployments.
Course Schedule
Target Audience
  • Database Administrators
  • Database Administrators
  • Database Designers
  • Database Designers
  • Support Engineer
  • Support Engineer
  • Technical Administrator
  • Technical Administrator
  • Data Warehouse Administrator
  • Data Warehouse Administrator
  • Data Warehouse Administrator
Course Objectives
  • Back up, restore, and patch DBCS database deployments
  • Describe the DBaaS and on-premises Oracle Database architectures
  • Manage database instances
  • Manage UNDO data
  • Move data between databases
  • Implement basic backup and recovery procedures
  • Monitor and tune database performance
  • Tune SQL to improve performance
  • Manage resources with Oracle Database Resource Manager
  • Create pluggable databases (PDBs)
  • Configure the Oracle network environment
  • Administer user security and implement auditing
  • Create and manage tablespaces
  • Manage storage space
  • Create and manage Database as a Cloud Service (DBCS) database deployments
  • Register databases and manage performance with Enterprise Manager Cloud Control
Course Prerequisites
  • A working knowledge of SQL and PL/SQL packages is very helpful in the course.
  • Basic knowledge of Linux operating system
Course Outline

Exploring Oracle Database Architecture

  • Querying the Oracle Data Dictionary
  • Oracle Database Tools
  • Oracle-Supplied User Accounts
  • Oracle Database Server Architecture
  • Oracle SQL and PL/SQL
  • Connecting to Oracle Databases
  • Introducing Oracle Database
  • Relation Database Models

ManagingDatabase Instances

  • Initialization Parameter Files
  • Opening and Closing PDBs
  • Starting Up Oracle Databases
  • Shutting Down Oracle Databases
  • Querying Dynamic Performance Views
  • Working with the Automatic Diagnostic Repository (ADR)


  • Methods and Tools to Create PDBs
  • Dropping PDBs with SQL*Plus
  • Unplugging and Pluggin In PDBs with SQL*Plus
  • Cloning PDBs with SQL*Plus
  • Creating PDBs from Seed with SQL*Plus

Configuringthe Oracle Network Environment

  • Configuring Listeners for Static Service Registration
  • Dedicated Versus Shared Server Configurations
  • How Listeners Work
  • Testing Oracle Net Connectivity with tnsping
  • Configuring Listeners for Dynamic Service Registration
  • Oracle Net Services
  • Configuring Local Naming for Connections
  • Configuring Communidation Between Databases

AdministeringUser Security

  • Authenticating Users
  • Assigning Quotas to Users
  • Creating Users
  • Granting Privileges
  • Creating and Granting Roles
  • Creating and Assigning Profiles
  • Applying the Principal of Least Privilege
  • Revoking Privileges and Roles

Creatingand Managing Tablespaces

  • Implementing Oracle Managed Files
  • Creating Tablespaces in SQL*Plus
  • Moving and Renaming Online Data Files in SQL*Plus
  • Viewing Tablespace Information in SQL*Plus
  • How Table Data is Stored
  • Altering and Dropping Tablespaces in SQL*Plus

ManagingStorage Space

  • Block Space Management
  • Allocating Extents
  • Free Space Management Within Segments
  • Row Chaining and Migration
  • Space-Saving Features
  • Types of Segments
  • Oracle Database Space Management Features
  • Understanding Deferred Segment Creation

ManagingUNDO Data

  • Local Undo Mode Versus Shared Undo Mode
  • Comparing Undo Data and Redo Data
  • Undo Data: Overview
  • Configuring Undo Retension
  • Categories of Undo
  • Storing Undo Information
  • Transactions and Undo Data
  • Managing Undo

Moving Data

  • Oracle Data Pump: Benefits
  • Data Pump Export and Import Clients
  • SQL*Loader Overview
  • Data Pump Utility: Interfaces and Modes
  • Loading Methods
  • Oracle Data Pump: Overview
  • Data Pump Import: Transformations
  • Moving Data: General Architecture

Backup andRecovery Concepts

  • Categories of Failure
  • Understanding Types of Backups
  • Understanding Instance Recovery
  • Flashback Technology
  • DBA Responsibilities
  • Oracle Data Protection Solutions
  • Comparing Complete and Incomplete Recovery

Monitoringand Tuning Database Performance

  • Database Maintenance
  • Automatic Database Diagnostic Monitor
  • Automatic Workload Repository (AWR)
  • Database Server Statistics and Metrics
  • Performance Tuning Methodology
  • Performance Planning Considerations
  • Managing Performance Activities
  • Performance Monitoring

SQL Tuning

  • Oracle Optimizer
  • SQL Access Advisor
  • SQL Plan Directives
  • SQL Tuning Advisor
  • SQL Tuning Process
  • Optimizer Statistics
  • Adaptive Execution Plans
  • SQL Performance Analyzer

OracleDatabase Resource Manager

  • Resource Manager Elements
  • Limiting CPU Utilization at the Database Level
  • Using the Active Session Pool Feature
  • Creating a Complex Resource Plan
  • Oracle Database Resource Manager: Overview
  • Limiting CPU Utilization at the Server Level
  • Creating a Simple Resource Plan
  • Using Resource Manager to Allocate Resources

EnterpriseManager Cloud Control

  • Controlling the Enterprise Manager Cloud Control Framework
  • Starting the Enterprise Manager Cloud Control Framework
  • Stopping the Enterprise Manager Cloud Control Framework

Introductionto Oracle Database Cloud Service

  • DBCS Architecture
  • Oracle Cloud: Overview
  • Additional Database Configuration Options
  • Features and Tooling
  • Database Cloud Service Offerings

CreatingDBCS Database Deployments

  • Creating a Database Deployment
  • Automated Database Provisioning
  • Creating an SSH Key Pair
  • How SSH Key Pairs are Used
  • Storage Used for Database Files

ManagingDBCS Database Deployments

  • Managing Network Access to DBCS
  • Cloud Tooling
  • Accessing Tools and Features from the DBCS Console
  • Enabling Access to a Compute Node Port
  • Scaling a Database Deployment
  • Managing the Compute Node Associated With a Database Deployment

Backing Upand Restoring DBCS Database Deployments

  • Backing Up and Recovering Databases on DBCS
  • Creating an On-Demand Backup
  • Performing Recovery by Using the Console
  • Performing Recovery by Using the dbaascli Utility
  • Backup Configuration
  • Customizing the Backup Configuration
  • Backup Destination Choices

PatchingDBCS Database Deployments

  • Using the dbaascli Utility to Manage Patches
  • Using the DBCS Console to Manage Patches
  • Patching DBCS

CreatingMaster Encryption Keys for PDBs

  • Creating and Activating an Encryption Key
  • Determining Whether You Need to Create and Activate and Encryption Key for a PDB
  • CDB and PDB Master Encryption Keys

TablespaceEncryption by Default

  • Using TDE
  • Defining the Keystore Location
  • Transparent Data Encryption (TDE) Overview
  • Managing the Software Keystore and Master Encryption Key
  • Managing the Keystore in CDBs and PDBs
  • Components of TDE
  • Tablespace Encryption by Default in DBCS
  • Controlling Tablespace Encryption by Default