Retour en haut de la page

Oracle Database 11g - 2 Day DBA Release 2

2 jours - 14 heures

Objectifs

Install Oracle Database 11g Create a Database Use Enterprise Manager Database Control to manage the database Configure and manage the Oracle Network environment Manage database storage structures Administer users and security Manage schema objects Backup and recover the database Monitor the database Use the Support Workbench Manage the Oracle Database software Use the Advisors

Participants

Administrateurs de base de données Consultant Technique Ingénieurs support

Prérequis

Cours pré-requis obligatoire(s): Basic knowledge of Linux Operating System

Pédagogie

La pédagogie est basée sur le principe de la dynamique de groupe avec alternance d'apports théoriques, de phases de réflexion collectives et individuelles, d'exercices, d'études de cas et de mises en situations observées. Formation / Action participative et interactive : les participants sont acteurs de leur formation notamment lors des mises en situation car ils s'appuient sur leurs connaissances, les expériences et mettront en œuvre les nouveaux outils présentés au cours de la session.

Profil de l’intervenant

Consultant-formateur expert. Suivi des compétences techniques et pédagogiques assuré par nos services.

Moyens techniques

Encadrement complet des stagiaires durant la formation. Espace d’accueil, configuration technique des salles et matériel pédagogique dédié pour les formations en centre. Remise d’une documentation pédagogique papier ou numérique à échéance de la formation.

Méthodes d’évaluation des acquis

Exercices individuels et collectifs durant la formation. La feuille d’émargement signée par demi-journée ainsi que l’évaluation des acquis de fin de stage sont adressées avec la facture.

Programme

Overview of Oracle Database Administration

Relational Databases: Introduction

What is SQL?

Overview of Oracle Instance and Database

Common Tasks of an Oracle Database Administrator (DBA)

Tools for Administering an Oracle Database

Monitoring the Database and Using the Advisors

Monitoring General Database State, Workload, and Performance

Setting Metric Thresholds

Setting Up Direct Alert Notification

Diagnosing Performance Problems

Viewing ADDM Performance Analysis and Responding to Findings

Using the SQL Tuning and SQL Access Advisors

Configuring the Automatic SQL Tuning Advisor

Viewing Automatic SQL Tuning Results

Investigating, Reporting, and Resolving Problems

Using the Enterprise Manager Support Workbench

Workflow for Investigating, Reporting, and Resolving a Problem

Performing the Tasks to Investigate and Report a Critical Error

Managing Oracle Database Software

Understanding Software Management and Patch Releases

Patching Oracle Database Software

Using the Database Upgrade Assistant to Upgrade the Database

Installing the Database and Creating the Database

Using Oracle Universal Installer

Installation Prerequisites

Setting Environment Variables

Installing the Oracle Database Software: Steps

Using the Database Configuration Assistant (DBCA)

Using the DBCA to Create a Database

Performing Other Actions with the DBCA

Using the DBCA to Manage Templates

Using Oracle Enterprise Manager Database Control and SQL-Based Management Tools

Oracle Database 11g Release 2 Management Framework: Components

Administering the Database by Using Enterprise Manager: Overview

Starting the Database Control Console Process

Accessing Enterprise Manager Database Control

Oracle Enterprise Manager: Navigation

Granting Enterprise Manager Administrative Privileges

Configuring Enterprise Manager Settings and Preferences

Using SQL*Plus and SQL Developer to Access Your Database

Configuring the Oracle Network Environment

Tools for Configuring and Managing the Oracle Network

Accessing the Enterprise Manager Net Services Administration Page

Managing the Oracle Net Listener with Enterprise Manager

Using the Listener Control Utility

Connecting to an Oracle Database

Oracle Net: Naming Methods

Using Enterprise Manager to Configure Local Naming

Using Oracle Net Manager to Configure Local Naming

Managing the Oracle Instance

Oracle Instance Management

Oracle Processes

Oracle Memory Structures

Starting the Instance and Opening the Database

Shutting Down an Oracle Database Instance

Viewing and Modifying Initialization Parameters

Managing Memory Components

Viewing the Alert Log

Managing Database Storage Structures

Oracle Database Structures

Exploring the Storage Structure of the Oracle Database

Multiplexing the Redo Log

Enlarging the Database

Creating, Modifying, and Dropping Tablespaces

Reclaiming Space in Your Tablespace

Managing Undo Data

Using the Undo Advisor to Compute the Minimum Undo Tablespace Size

Administering Users and Security

Overview of Users and Security

Oracle-Defined Users

Creating, Modifying, and Dropping Users

Locking and Unlocking Accounts

Unlocking a User Account and Resetting the Password

Setting the Password Policy

Modifying the Default Password Policy

Administering Privileges and Roles

Managing Schema Objects

Creating, Modifying, and Dropping Tables

Understanding Data Integrity and Defining Constraints

Viewing the Contents of a Table

Creating and Dropping Indexes

Managing Views

Managing Program Code Stored in the Database

Managing Access to Schema Objects

Loading Data

Performing Backup and Recovery

Backup, Restore, and Recovery Concepts

Configuring the Database for Backup and Recovery

Configuring Backup Settings

Backing Up the Database

Using the Oracle-Suggested Backup Strategy

Performing Backup Maintenance Tasks

Using Oracle Advised Recovery to Recover the Database

Performing Flashback Table and Flashback Drop

1224 log-544.pdf