Oracle DBA Training

Oracle DBA Training: Learn Oracle Database 12c core architectural foundations, database concepts, the role and capabilities of the administrator and Database configuration, administration, programming, performance tuning, backup and recovery, and high availability., etc. You will also get an exposure to industry based Real-time projects in various verticals.

Oracle DBA Training Details
Track Regular Track Weekend Track Fast Track
Course Duration 30 Hrs 8 Weekends 5 Days
Hours 1.5hr/day 2 Hours a day 6 Hours a day
Training Mode Online Online Online
Pricing 25000/- 13999/-Rs 25000/- 13999/-Rs 25000/- 13999/-Rs
Get Trained Enquire Enquire Enquire
Prerequisites

 

  • Basic knowledge of Introduction to SQL
  • Basic knowledge of Linux Operating System

 

Students can use this training to prepare for majority of the topics required to pass the Oracle Database 12c Administration 1Z0-062 examination towards Oracle OCA certification (Oracle Certified Associate). The same training course can be used for preparation towards the Oracle Database 11g: Administration I 1Z0-052 examination as well. Additionally, students can also use this training to prepare for some topics required to pass the  Oracle Database 12c: Advanced Administration 1Z0-063 exam that is required for acquiring the Oracle Certified Professional (OCP) designation.

Audience: Oracle 12c training is meant for Database Administrators, Data Warehouse Administrators, Database Designers, Technical Administrators and Support Engineers.

Course Contents

ORACLE Linux Installation

Basic Linux Commands

ORACLE 12C Database Installation

Graphical Method
Silent Method
Bash file Configuration

Oracle Architecture

Process Structure
Memory Structure
Database Instance

Manage Database Instance

Instance startup/shutdown
Parameter file Configuration
Creating a New Database
Typical and Custom Install
Planning Database Files Locations
Operating System Environment
DB Configuration Assistant (DBCA)
Using Silent Method, Understanding TS
Changing Initialization parameters – SGA size
Processes, TS Naming Conventions
Block Sizes Type of DB Dropping a Database.

Maintaining the Control File, Redo Log File and Archive Log Files

Importance, Role, Sizing, Contents,
Multiplexing and Backing up of the Control File
Purpose of and how online redo log files work with their associated Background Processes Controlling log switches and checkpoints, Multiplexing and Archiving online redo log files.

Managing Tablespaces and Datafiles

Creating and Altering Tablespaces
adding, resizing, renaming and relocating a Datafile.
Tablespace offline, online, readonly, readwrite,
Temporary tablespace groups, multiple blocks
Creating and Managing a Tablespace
when using OMF and the advantages of OMF feature Extent management- Dictionary Managed and Locally Managed Tablespaces (AUTOALLOCATE, UNIFORM) and advantages of locally managed over dictionary managed tablespaces Big File Tablespace, Temporary Tablespace Group.

Managing Undo Segments

Understanding ORACLE Undo Segments
Undo Data versus Redo Data
Undo Parameters
Retention Policy
Retention Gurantee/Nogurantee
Switching Undo Tablespace
Flashback Technologies.

Managing Oracle Network

Network Overview
Oracle Net Services Server-side Configuration
Oracle Net Services Client-Side Configuration
Listener start/stop/status
Interactive Mode
Use tnsping to test Oracle Net connectivity

Managing Backups and Recovery

Backup Introduction
Physical Backups – Hot, Cold
Exports & Imports
Datapumps
User Managed – RMAN Backups and Recovery
RMAN Configuration
RMAN Catalog
Crosscheck
Delete Obsolete
RMAN Incremental Backups
Parallelism
Compression
RMAN Recoveries
Duplicating Databases
Recovery Scenarious
Redo log file lost
Datafile lost
Restoring archives etc.,

High Availability - DATAGUARD

 

Introduction to Oracle Data Guard
Creating a Physical Standby Database
Data Guard Protection Modes
Redo Transport Services
Apply Services, Role Transitions
Data Guard Scenarios
Troubleshooting Data Guard
Creating a Standby Database with Recovery Manager
Configuring DGMGRL
Using Oracle Active Data Guard
Creating and Managing a Snapshot Standby Database
Monitoring a Data Guard Configuration, Fast Start Failover.

Performance Tuning

Overview of Tuning Phases
Goals
Methodology and Common Performance problems DB Conf. and I/O Issues
File Striping
Optimize/Tuning Sorting Operations
Diagnosing and Tuning Latch and Lock Contention
Redo Log File Configuration
Online Segment Shrinking
Enabling Oracle Parallel Query Option
Multiple DB Writers
Log Writers
Table Caching Tuning Rollback/Undo Segments - Usage
Configuration
Detecting and Resolving problems Diagnostic and Tuning Tools - Alert Log File
Trace Files
TKPROF, Explain Plan
Dynamic Performance Views
TIMED_STATISTICS parameter to collect statistics
STATSPACK Application Tuning - SQL Tuning
Indexing Tuning
Introduction to Statspack
AWR,ADDM,ASH
Self tuning with Statspack and AWR.

Working with Support

Use the Enterprise Manager Support Workbench
Work with Oracle Support
Log service requests (SR)
Manage patches
Crontab Scheduling
Shell Scripts

 

Need more info ? Email training@oracledbatraining.in  or   Enquire now!