Oracle DBA 12C Training


MK Training’s offers the best Oracle DBA 12c Online Training Course is designed by IT Professionals with the IT Industry Specialists as our trainers are experienced and certified trainers. They share their experience, tips and tricks in the Oracle DBA 12c Online Training course. We are also delighted to be one of the best leading IT online training with best experienced IT professionals and skilled resources. We have been offering courses to consultants, companies so that they can meet all the challenges in their respective technologies.

Oracle Database (commonly referred to as Oracle RDBMS or simply as Oracle) is an object-relational database management system produced and marketed by Oracle Corporation.

Oracle DBA Course Content


1. Introduction
 What is DBA?
 Why a Company needs a DBA?
 Roles & Responsibilities of DBA
 Identify the oracle product
 Oracle Architecture
 Physical and Logical Phase of Database

2. Installing oracle database 12c software
 System requirements.
 Redhat Linux Installation
 Install software with the Oracle Universal Installer on Linux Platform
 Identify System Requirements
 Optimal Flexible Architecture (OFA)
 Discuss Oracle Base
 Discuss Oracle Home
 Prerequisite Checks and Fixup Utility

3. Container and Pluggable Database Architecture
 Describe the multitenant architecture
 Describe the root and pluggable database containers
 Differentiate the root from a pluggable database
 Explain pluggable database plugging
 List impacts in various areas
 Initialization Parameter Files
 Starting Up Oracle Databases
 Shutting Down Oracle Databases
 Opening and Closing PDBs
 Working with the Automatic Diagnostic Repository (ADR)
 Querying Dynamic Performance Views

4. CDB and PDB Creation
 Methods and Tools to Create PDBs
 Creating PDBs from Seed with SQL*Plus
 Cloning PDBs with SQL*Plus
 Unplugging and Pluggin In PDBs with SQL*Plus
 Dropping PDBs with SQL*Plus
 Configure and create a CDB, Create a PDB from PDB$SEED
 Plug or clone a non-CDB into a CDB
 Clone a local or remote PDB into a CDB
 Unplug and plug a PDB from one CDB to another CDB
 Explore the instance and structure of PDBs
 Migrate a pre-12.1 non-CDB database to CDB

5. Managing Tablespaces and Users in CDB and PDBs
 How Table Data is Stored
 Creating Tablespaces in SQL*Plus
 Altering and Dropping Tablespaces in SQL*Plus
 Viewing Tablespace Information in SQL*Plus
 Implementing Oracle Managed Files
 Moving and Renaming Online Data Files in SQL*Plus
 Permanent & temporary tablespaces in CDB and PDBs

6. Managing Storage Space
 Oracle Database Space Management Features
 Block Space Management
 Row Chaining and Migration
 Free Space Management Within Segments
 Types of Segments
 Allocating Extents
 Understanding Deferred Segment Creation
 Space-Saving Features

7. Managing UNDO Data
 Undo Data: Overview
 Transactions and Undo Data
 Storing Undo Information
 Comparing Undo Data and Redo Data
 Managing Undo
 Local Undo Mode Versus Shared Undo Mode
 Configuring Undo Retension
 Categories of Undo

8. Administering User Security
 Creating Users
 Granting Privileges
 Creating and Granting Roles
 Revoking Privileges and Roles
 Creating and Assigning Profiles
 Authenticating Users
 Assigning Quotas to Users
 Applying the Principal of Least Privilege
 Common and local users, roles and privileges
 New Administrative Privileges
 New Administrative Privilege SYSBACKUP
 New Administrative Privilege SYSDG
 New Administrative Privilege SYSKM
 OS Authentication and OS Groups
 Password Authentication for SYSBACKUP
 Password Authentication for SYSDG
 New System Privilege PURGE DBA_RECYCLEBIN 10-19
 Creating Policies Database and Role Analysis
 Creating Policies Context Analysis
 Analyzing and Reporting
 SYSTEM and OBJECT Used Privileges
 Used Privileges Results
 Compare Used and Unused Privileges


9. Configuring the Oracle Network Environment
 Oracle Net Services
 How Listeners Work
 Configuring Listeners for Dynamic Service Registration
 Configuring Listeners for Static Service Registration
 Configuring Local Naming for Connections
 Testing Oracle Net Connectivity with tnsping
 Configuring Communication Between Databases
 Dedicated Versus Shared Server Configurations

10. Moving Data (DATAPUMP)
 Moving Data: General Architecture
 Oracle Data Pump: Overview
 Oracle Data Pump: Benefits
 Full Transportable Export/Import Overview
 Full Transportable Export/Import Usage
 Full Transportable Export/Import Example
 Plugging a Non-CDB into CDB Using Data Pump
 Plugging a Non-CDB into CDB Using Replication
 Transporting a Database over the Network Example
 Disabling Logging for Oracle Data Pump Import Overview
 Disabling Logging for Oracle Data Pump Import Usage
 Disabling Logging for Oracle Data Pump Import Command-Line Examples
 Exporting Views as Tables Overview
 Exporting Views as Tables Usage
 Exporting Views as Tables Command-Line Examples
 Specifying the Encryption Password
 Compressing Tables during Import

11. Backup and Recovery Concepts
 DBA Responsibilities
 Categories of Failure
 Understanding Instance Recovery
 Understanding Types of Backups
 Comparing Complete and Incomplete Recovery
 Duplicating a Database ( Database Cloning )
 Use Table Recovery
 Backup and Recovery Concepts
 Perform basic backup and recovery
 Configure and manage RMAN settings, Configure FRA
 Describe the use of the RMAN recovery catalog, Create Catalog
 Register a database in the RMAN recovery catalog
 Perform full and incremental backups
 Configure Block Change tracking, Perform incremental level backups
 Recover an incremental level 0 backup with level 1 incremental
 Perform automated TSPITR, Perform table recovery from backups
 Perform CDB and PDB backups
 Recover CDB and PDB from essential file loss

 Media Failure: CDB or PDB Temp File Recovery
 Media Failure: PDB Temp File Recovery
 Media Failure: Control File Loss
 Media Failure: Redo Log File Loss
 Media Failure: Root SYSTEM or UNDO Data File
 Media Failure: Root SYSAUX Data File
 Media Failure: PDB SYSTEM Data File
 Media Failure: PDB Non-SYSTEM Data File


13. Using Flashback Technologies
 Describe Flashback Database architecture
 Understand flashback technologies from various types of errors
 Configure your database to use flashback technologies
 Perform flashback query, version query, transaction backout
 Perform flashback table, recyclebin, flashback data archive

14. Patching Activity
 Database Patch Management Introduction
 Applying Interim and Patch set Patches
 Patch History & Documentation

15. Oracle Database Upgrades

16. Monitoring and Tuning Database Performance
 SQL Tuning Process
 Oracle Optimizer
 Optimizer Statistics
 SQL Plan Directives
 Adaptive Execution Plans
 SQL Tuning Advisor
 SQL Access Advisor
 SQL Performance Analyzer
 Managing Performance Activities
 Performance Planning Considerations
 Database Maintenance
 Automatic Workload Repository (AWR)
 Automatic Database Diagnostic Monitor
 Performance Monitoring
 Performance Tuning Methodology
 Database Server Statistics and Metrics

Please enter your email, so we can follow up with you.