Oracle 12C DBA Training – Online

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 Topics


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

Working with Support

Use the Enterprise Manager Support Workbench

Work with Oracle Support

Log service requests (SR)

Manage patches

Crontab Scheduling

Shell Scripts