Oracle DBA 11g

Home > Courses > Oracle DBA 11g

Course Duration: 65 Hours

Course Highlights:

  • Installation of Oracle Database 11g R2 on Oracle Enterprise Linux
  • SQL Command
  • Managing the Oracle Database Instance
  • Oracle Database Architecture
  • Configuring the Oracle Network Environment
  • Managing Database Storage Structures/Files
  • Administering User Security
  • Oracle Database Auditing
  • Managing Data ConcurrencyUndo Management
  • Redo Log Management
  • Backup and Recovery.
  • Moving Data
  • Database Maintenance
  • Performance Management

Required Prerequisites:

  • Basic Knowledge of Unix.
  • Oracle Database: Introduction to SQL

Target Audience:

  • Fresher who wants to make career as Oracle Database Administrator.
  • Oracle SQL and PL/SQL Developer who wants to change career path from Developer to DBA.

Download Oracle DBA 11g Brochure

Course Content

Section 1: Introduction

What is Database?

What is RDBMS?

What is Oracle?

What is Oracle Database?

What is Oracle Database 11g?

Section 2: Installation of Oracle Enterprise Linux on Oracle VirtualBox

How to Install Oracle VirtualBox on Windows Operating System (O.S)?

How to Install Oracle Enterprise Linux on Oracle VirtualBox?

How to Configure Putty on Windows O.Sto Connect Oracle Enterprise Linux in VirtualBox?

Section 3: Linux Command

Basic Linux Commands which are helpful in DBA Activity.

Section 4: Installation of Oracle Database 11g R2 on Oracle Enterprise Linux

Install Oracle Database Software11g R2 using Oracle Universal Installer (OUI).

Create Oracle Database using DBCA.

Create Oracle Database Manually.

Drop Database using DBCA.

Drop Database Manually.

Uninstall Oracle Database Software11gR2 using Oracle Universal Installer (OUI).

Section 5: SQL Command

What is SQL?

What is SQL Plus?

SQL Commands – DDL, DML, DCL, TC and SELECT Commands which are helpful in DBA Activity.

Section 6: Managing the Oracle Database Instance

Start and stop the Oracle database and components

Access a database with SQL Plus

Modify database installation parameters

Describe the stages of database startup

Describe database shutdown options

View the alert log

Access dynamic performance views

Section 7:Oracle Database Architecture

Oracle Database Architecture Overview

Process Architecture

Memory structures

Logical and physical storage structures

Section 8: Configuring the Oracle Network Environment

Use Netca,Netmgr,Manual to create and configure the Listener

Start and stop the listener

Setting up tnsnames.ora/listener.ora/sqlnet.ora

Troubleshooting listener related connectivity issue

Use tnsping to test Oracle Net connectivity

Identify when to use shared servers and when to use dedicated servers

Section 9: Managing Database Storage Structures/Files

Storage Structures

How Table Data Is Stored

Anatomy of a Database Block

Actions with Table space like create/drop/offline/online

Space Management in Tablespace

Adding/Resizing Data files

Renaming/Relocating Data file

Oracle Managed Files (OMF)

Section 10: Administering User Security

Database User Creation/Management

Predefined Administrative Accounts

Benefits/Creation of Roles

Predefined Roles and Roles Management

Implementing Profiles

Section 11: Managing Data Concurrency

Locks

Locking Mechanism

Data Concurrency

DML Locks

Enqueue Mechanism

Lock Conflicts

Possible Causes of Lock Conflicts

Detecting Lock Conflicts

Resolving Lock Conflicts

Resolving Lock Conflicts with SQL

Deadlocks

Section 12: Oracle Database Auditing

Standard Database Auditing

Value-Based Auditing

Fine-Grained Auditing

SYSDBA Auditing

Section 13: Undo Management

Monitor and administer undo

Configure undo retention

Guarantee undo retention

Use the undo advisor

What is ORA-01555 Error?

Section 14: Redo Log Management

What is Redo Log file and Redo Log Management?

What is ARCHIVELOG and NOARCHIVELOG Mode?

Configure ARCHIVELOG mode

Archive Log File: Naming and Destinations

Adding/Dropping Redo Log Members/ Groups

Multiplexing the Redo Log

Section 15: Backup and Recovery Concepts

Part of Your Job

Categories of Failure

Statement Failure

User Process Failure

Network Failure

User Error

Flashback Technology

Instance Failure

Media Failure

Configuring for Recoverability

Configuring the Fast Recovery Area

Multiplexing Control Files

Section 16: Performing Database Backups

Backup Solutions: Overview

User-Managed Backup

User-Managed – Full DB Online / Offline Backup, Partially DB Online / Offline Backup.

Terminology

Recovery Manager (RMAN)

Configuring Backup Settings

RMAN – Full DB Online / Offline Backup, Partially DB Online / Offline Backup.

RMAN – Level 0 / Level 1 – Differential, Cumulative Backup.

Backing Up the Control File to a Trace File.

Block Change Tracking, Enable Block Change Tracking.

Managing Backup.

Viewing Backup Reports.

Monitoring the Fast Recovery Area.

Configure Recovery Catalog in RMAN.

Taking backup using Recovery Catalog.

Section 17: Performing Database Recovery

Opening a Database

Keeping a Database Open

Loss of a Control File

Loss of a Redo Log File

Loss of a Data File in NOARCHIVELOG Mode

Loss of a Noncritical Data File in ARCHIVELOG Mode

Loss of a System-Critical Data File in ARCHIVELOG Mode

Section 18: Moving Data

SQL*Loader: Overview

Loading Data with SQL*Loader

SQL*Loader Control File

Loading Methods

Oracle Data Pump: Overview

Oracle Data Pump: Benefits

Data Pump Export and Import: Overview

Data Pump Utility: Interfaces and Modes

Fine-Grained Object Selection

Advanced Feature: Sampling

Data Pump Import

Data Pump Import: Transformations

Data Pump: Performance Considerations

Performance Initialization Parameters

Section 19: Database Maintenance

Terminology

Oracle Optimizer: Overview

Optimizer Statistics

Using the Manage Optimizer

Statistics Page

Gathering Optimizer Statistics Manually

Preferences for Gathering Statistics

Statistic Levels

Automatic Workload Repository

(AWR)

AWR Infrastructure

AWR Baselines

Enterprise Manager and the AWR

Managing the AWR

Automatic Database

Diagnostic Monitor (ADDM)

ADDM Findings

ADDM Recommendations

Advisory Framework

DBMS_ADVISOR Package

Automated Maintenance Tasks

Server-Generated Alerts

Setting Thresholds

Creating and Testing an Alert

Alerts Notification

Reacting to Alerts

Alert Types and Clearing Alerts

Section 20: Performance Management

Performance Monitoring

Enterprise Manager Performance Page

Drilling Down to a Particular Wait Category

Performance Page: Throughput

Performance Monitoring: Top Sessions

Performance Monitoring: Top Services

Managing Memory

Components

Enabling Automatic Memory Management (AMM)

Enabling Automatic Shared

Memory Management (ASMM)

Automatic Shared Memory

Advisor

Setting Shared Memory

Components Manually

Using Memory Advisors

Dynamic Performance Statistics

Troubleshooting and Tuning Views

Invalid and Unusable Objects

Signup today and be the first to get notify on latest videos and upcoming batches.

Subscribe to our mailing list