Fusion Blog

EBS Blog


Contact Us

  • Register

Oracle Gold Partners, our very popular training packages, training schedule is listed here
Designed by Five Star Rated Oracle Press Authors & Oracle ACE's.

webinar new Click here to raise Support Ticket. Get reply within 48 hours.

Search Courses

User Rating: 1 / 5

Star ActiveStar InactiveStar InactiveStar InactiveStar Inactive

Databases represent the core of an organization's informational infrastructure. It is imperative for administrators to be well trained. In this training, you will gain the knowledge and skills to create and configure Oracle 12c databases, manage memory and storage effectively, and deploy essential procedures to maintain your organization's database and ensure its availability.


By the end of this training you will learn to:

Create, configure and maintain Oracle 12c databases

Automate database administration using OEM Cloud Control 12c

Ensure database security by managing user privileges and roles

Manage storage to optimize space and performance

Implement Oracle partitions to manage large tables and indexes

Deploy appropriate backup, recovery and flashback procedures

Course Contents

Day 1

Understanding the Architecture

Oracle Database 12c Introduction

Oracle Database Architecture: Overview


Oracle Database Instance Configurations

Connecting to the Oracle Database Instance

Oracle Database memory Structures

Process Architecture

Process Structures

Process Startup Sequence

Day 2


Planning Your Installation

Configuring Oracle Linux with Oracle RDBMS Pre-Install RPM

Operating System Groups and Users

Environment Variables

Configuring the Oracle Software Owner Environment

Using Oracle Universal Installer (OUI)

Installation Option: Silent Mode


Installing Oracle Database Software

Oracle Software Installation Basics

System Requirements for Oracle Database

Creating Operating System Groups and Users


Creating an Oracle Database by Using DBCA

Planning the Database Storage Structure

Types of Databases (based on workload)

Choosing the Appropriate Character Set

Understanding How Character Sets are Used

Setting the NLS_LANG Initialization Parameter

Using the Database Configuration Assistant (DBCA)

Day 3

Database Configuration

Introducing Oracle Database Management Tools

Using SQL*Plus

Using SQL Developer

Logging in to Oracle Enterprise Manager Database Express

Using the Enterprise Manager Database Express Home Page

Using Enterprise Manager Cloud Control


Managing the Database Instance

Initialization Parameter Files

Starting an Oracle Database Instance

Shutting Down an Oracle Database Instance

Viewing Log Files

Using Trace Files

Using the Dynamic Performance Views

Data Dictionary


Configuring the Oracle Network Environment

Oracle Net Services Overview

Oracle Net Listener Overview

Establishing Oracle Network Connections

Connecting to a Server

Tools for Configuring and Managing the Oracle Network

Using the Listener Control Utility

Using Oracle Net Configuration Assistant

Using Oracle Net Manager

Day 4

Storage Structures

Managing Database Storage Structures

Understanding Storage of Data

Database Block contents

Exploring the Storage Structure

Creating a New Tablespace

Overview of Tablespaces Created by Default

Managing Tablespaces

.Viewing Tablespace Information

Using Oracle Managed Files


Managing Space

Space Management Overview

Block Space Management

Row Chaining and Migration

Free Space Management Within Segments

Types of Segments

Allocating Extents

Allocating Space

Creating Tables Without Segments


Managing Undo Data

Undo Data Overview

Transactions and Undo Data

Storing Undo Information

Comparing Undo Data and Redo Data

Managing Undo

Configuring Undo Retention

Guaranteeing Undo Retention

Changing an Undo tablespace to a Fixed Size

Managing Data Concurrency

Day 5

Database Security

Administering User Security

Database User Accounts (overview)

Predefined Administrative Accounts

Creating a User


Unlocking a User Account and Resetting the Password





Implementing Oracle Database Auditing

Separation of Responsibilities

Database Security

Monitoring for Compliance

Standard Database Auditing

Unified Audit Data Trail

Separation for Duties for Audit Administration (AUDIT_ADMIN and AUDIT_VIEWER roles)

Configuring the Audit Trail

Specifying Audit Options

Day 6

Database Backups

Backup and Recovery Concepts

Categories of Failures

Flashback Technology


Understanding Instance Recovery

Phases of Instance Recovery

Tuning Instance Recovery

Using the MTTR Advisor

Comparing Complete and Incomplete Recovery


Backup and Recovery Configuration

Configuring for Recoverability

Configuring the Fast Recovery Area

Multiplexing the Control File

Online Redo Log File

Multiplexing the Online Redo Log File

Archived Redo Log Files

Archiver Process

Archived Redo Log File Naming and Destinations

Day 7

Backup and Recovery

Performing Database Backups 

Backup Solutions Overview

Oracle Secure Backup (overview)

User Managed Backup (overview)

Backup Terminology and Types of Backups

Using Recovery Manager (RMAN)

Configuring Backup Settings

Oracle-Suggested Backup

Backing Up the Control File to a Trace File


Performing Database Recovery

Data Recovery Advisor

Loss of a Control File

Loss of a Redo Log File

Loss of a Datafile in NOARCHIVELOG Mode

Loss of a Noncritical Datafile in ARCHIVELOG Mode

Loss of a System-Critical Datafile in ARCHIVELOG Mode


Moving Data

Moving Data: General Architecture

Oracle Data Pump


External Tables

Day 8

Database Performance

Performing Database Maintenance

Database Maintenance (overview)

Viewing the Alert History


Automatic Workload Repository (AWR)

Statistic Levels

Automatic Database Diagnostic Monitor (ADDM)

Advisory Framework h.Enterprise Manager and Advisors

Managing Performance


Performance Monitoring

Tuning Activities

Performance Planning

Instance Tuning

Performance Tuning Methodology

Performance Tuning Data

Monitoring Performance

Managing Memor




Training Hours

Start Date: 4th May 2019

Duration: 8 Days

Training Schedule: 4, 5, 11, 12, 18, 19, 25 & 26th May 2019

Time: 12:00 NOON GMT | 08:00AM EST | 5:00AM PST | 7:00AM CST | 6:00AM MST | 5:30PM IST | 01:00PM GMT+1


About the Author


Search Trainings

Fully verifiable testimonials

Apps2Fusion - Event List

<<  May 2021  >>
 Mon  Tue  Wed  Thu  Fri  Sat  Sun 
       1  2
  3  4  5  6  7  8  9

Enquire For Training

Fusion Training Packages

Get Email Updates

Powered by Google FeedBurner