Oracle Database 11g Administration Workshop I Release 2

Course Introduction

The course helps the delegates in their initial step towards becoming an Oracle Database Administrator. The Oracle course is designed for the candidates who want to learn about installing and managing an Oracle Database.

Overview

The candidates get a detailed overview of the Oracle Database architecture through this course. It also provides an insight into the interaction that the components of the database make while fetching or updating data to and from the database. The course prepares the candidates for the Oracle Certified Associate certification exam.

Course Content

The Oracle Database Architecture

• An Overview Of The Oracle Database Architecture

• Introducing The Oracle Automatic Storage Management (ASM) Architecture

• Process Architecture

• Memory Structures

• Logical and Physical Structures

• Components of ASM

Installing Oracle

• Oracle DBA Tasks

• Tools For Administering An Oracle Database

• System Requirements

• The OUI – Oracle Universal Installer

• Installing Oracle Grid Infrastructure

• Install Oracle Database Software

• Unattended Installation

Oracle Database Creation

• Plan A Database

• Create Database With The Database Configuration Assistant(DBCA)

• Managing Passwords

• Creating The Database Design Template

• Delete A Database With DBCA

The Oracle Database Instance Management

• Starting and Stopping The Oracle Database and Its Components

• The Oracle Enterprise Manager

• Using SQL Plus to Access A Database

• Changing Installation Parameters

• Database Startup Stages –No Mount, Mount, Open

• Shutdown Options – Normal, Immediate, Abort

• Viewing The Alert Log

• Using Dynamic Performance Views

The ASM Instance

• Setting Up Initialization Parameter File for ASM Instance

• ASM Instance – Starting Up and Shutting Down

• Administering ASM Disk Groups

The Oracle Network Environment and Its Configuration

• Configuring The LISTENER through Enterprise Manager

• Enabling Oracle Restart to Monitor the LISTENER

• Testing Oracle Net Connectivity With tnsping

• Using Shared and Dedicated Servers

Database Storage Structure Management

• Storage Structures

• How Is Table Data Stored?

• Database Block

• Tablespaces and Space Management

• Default and System Tablespaces In Oracle Database

• Actions With Tablespaces

• Oracle Managed File(OMF) System

Administering User Security

• User Accounts in Oracle 11g

• Administrative Accounts in Oracle 11g

• Roles and Their Benefits

• Predefined Roles

• Implementing Profiles

Data Concurrency Management

• What Is Data Concurrency?

• Enque Mechanism In Oracle 11g

• Resolving Locks

• Deadlocks

Managing Undo Data

• Data Manipulation

• Transactions and Undo Data

• Undo Vs Redo Data

• Configuring Retention for Undo

Database Auditing In Oracle 11g

• DBA Concerns For Security

• Enabling Standard Database Auditing

• Specifying Audit Options

• Review Audit Information

• Maintaining Audit Trail

Database Maintenance

• Managing Optimizer Statistics

• Manage AWR (Automated Workload Repository)

• Using The Automatic Database Diagnostic Monitor

• The Advisory Framework – Its Use

• Setting Thresholds

• Use Server-Generated Alerts

• Use Automated Tasks

Performance Management

• Performance Monitoring

• Manage 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

• Statement Failure

• User Error

• Instance Recovery and Its Phases

• The MTTR Advisor

• Media Failure

• Archive Log Files

Performing Backups In Oracle 11g

• Backup Solutions

• Oracle Secure Backup and User-Managed Backup

• Terms Relating To Backup

• Recovery Manager(RMAN)

• Configure Backup Settings

• Backup Control File to Trace File

• Monitoring Flash Recovery Area

Database Recovery

• Opening A Database

• Data Recovery Advisor

• Recovering From A Loss Of Control File

• Recovering From A Loss Of Redo Log File

• Data Failures

• Listing Data Failures

• Data Recovery Advisory Views

Moving Data

• Various Ways To Move Data

• Using Directory Objects

• Using SQL*Loader

• Using External Tables

• The Oracle Data Pump

• Data Pump Export and Import

Working With Support

• Using Enterprise Manager Support Workbench

• Working With Oracle Support

• Record Service Requests

• Manage Patches

Prerequisites

The candidates must be familiar with the following to take up this course:

• Delegates should be knowledgeable about Oracle SQL Fundamentals introduction

• Oracle PL/SQL is recommended as prior information on this will be beneficial during the course

Target Audience

The course is intended for the Professionals who want to master Oracle Database technologies to administer the Oracle Database.

Delegate Will Learn How To

At the end of the course candidates will be able to do the following:

• Monitor Performance

• Describe The Architecture of The Oracle Database

• Install Oracle Grid Infrastructure

• Install And Configure Oracle Database 11g

• Configure Oracle Net Services

• Monitor And Manage Undo Data

• Managing Storage Structures In An Oracle Database

• Creating And Administering User Accounts

• Basic Backup And Recovery

• Manage Users And Schemas

• Manage Data Concurrency