[thim-heading title=”Oracle Database 12c Administration” line=””]

Upon Completion Of this Course on Oracle 12c Database Administration you will have good understanding on:

  • Manage an Oracle Database instance.
  • Configure the Oracle Network environment.
  • Create and manage storage structures.
  • Manage and move data.
  • Create and manage users.
  • Understand the concept of backup and recovery using RMAN.
  • Monitor the database and manage performance.
  • Learn upgrade from 11g to 12c
  • Learn database patching
  • Managing the ASM instance

Overview

  • Oracle Database Architecture Overview
  • Oracle ASM Architecture Overview
  • Process Architecture
  • Memory structrues
  • Logical and physical storage structures
  • ASM storage component

 

Installing your Oracle Software

  • Tasks of an Oracle Database Administrator
  • Tools Used to Administer an Oracle Database
  • Installation: System Requirements
  • Oracle Universal Installer (OUI)
  • Installing Oracle Grid Infrastructure
  • Installing Oracle Database Software
  • Silent Install

 

Creating an Oracle Database

  • Planning the Database
  • Using the DBCA to Create a Database
  • Password Management
  • Creating a Database Design Template
  • Using the DBCA to Delete a Database

 

Managing the Oracle Database Instance

  • Start and stop the Oracle database and components
  • Use Oracle Enterprise Manager
  • Access a database with SQLPlus
  • Modify database installation parameters
  • Describe the stages of database startup
  • Describe database shutdown options
  • View the alert log
  • Access dynamic performance views

 

Manage the ASM Instance

  • Set up initialization parameter files for ASM instance
  • Start up and shut down ASM instances
  • Administer ASM disk groups

 

Configuring the Oracle Network Environment

  • Use Enterprise Manager to create and configure the Listener
  • Enable Oracle Restart to monitor the listener
  • Use tnsping to test Oracle Net connectivity
  • Identify when to use shared servers and when to use dedicated servers

 

Managing Database Storage Structures

  • Storage Structures
  • How Table Data Is Stored
  • Anatomy of a Database Block
  • Space Management in Tablespaces
  • Tablespaces in the Preconfigured Database
  • Actions with Tablespaces
  • Oracle Managed Files (OMF)

 

Administering User Security

  • Database User Accounts
  • Predefined Administrative Accounts
  • Benefits of Roles
  • Predefined Roles
  • Implementing Profiles

 

Managing Data Concurrency

  • Data Concurrency
  • Enqueue Mechanism
  • Resolving Lock Conflicts
  • Deadlocks

 

Managing Undo Data

  • Data Manipulation
  • Transactions and Undo Data
  • Undo Data Versus Redo Data
  • Configuring Undo Retention

 

Implementing Oracle Database Auditing

  • Describe DBA responsibilities for security
  • Enable standard database auditing
  • Specify audit options
  • Review audit information
  • Maintain the audit trail

 

Database Maintenance

  • Manage optimizer statistics
  • Manage the Automatic Workload Repository (AWR)
  • Use the Automatic Database Diagnostic Monitor (ADDM)
  • Describe and use the advisory framework
  • Set alert thresholds
  • Use server-generated alerts
  • Use automated tasks

 

Performance Management

  • Performance Monitoring
  • Managing Memory Components
  • Enabling Automatic Memory Management (AMM)
  • Automatic Shared Memory Advisor
  • Using Memory Advisors
  • Dynamic Performance Statistics
  • Troubleshooting and Tuning Views
  • Invalid and Unusable Objects

 

Backup and Recovery Concepts

  • Part of Your Job
  • Statement Failure
  • User Error
  • Understanding Instance Recovery
  • Phases of Instance Recovery
  • Using the MTTR Advisor
  • Media Failure
  • Archive Log Files

 

Performing Database Backups

  • Backup Solutions: Overview
  • Oracle Secure Backup
  • User-Managed Backup
  • Terminology
  • Recovery Manager (RMAN)
  • Configuring Backup Settings
  • Backing Up the Control File to a Trace File
  • Monitoring the Flash Recovery Area

 

Performing Database Recovery

  • Opening a Database
  • Data Recovery Advisor
  • Loss of a Control File
  • Loss of a Redo Log File
  • Data Recovery Advisor
  • Data Failures
  • Listing Data Failures
  • Data Recovery Advisor Views

 

Moving Data

  • Describe ways to move data
  • Create and use directory objects
  • Use SQL*Loader to move data
  • Use external tables to move data
  • General architecture of Oracle Data Pump
  • Use Data Pump export and import to move data

 

Working with Support

  • Use the Enterprise Manager Support Workbench
  • Work with Oracle Support
  • Log service requests (SR)
  • Manage patches

 

Upgrade

  • 11g to 12c upgrade

Duration of the course : 40 hrs

Please note :

  • This is the approximate duration .We love more discussion with students and  depending on the interaction , the duration may increase
  • This is the time for the class delivery . Please reserve more  time for your practice

Course Prerequisite

  • Good Understanding SQL
  • Good Understanding on Linux OS and Commands

Recommended Prerequisite Courses

  • SQL
  • Linux Operating System For DBAs

The training is an instructor led training . Along with the training, we provide the following study materials via our e-learning portal

  •  Video Tutorials
  • Student guide
  • PowerPoint Presentations
  • We provide individual lab servers for our students during the training period .
  • The students can also access the lab for 1 months after the completion of the training.
  • We also help students in setting up their laptop/desktop for study purpose.
[thim-list-events layout=”layout-2″ text_link=”View All Events”]