Oracle Database 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 Database 11g Brochure

Course Content

timeline_pre_loader

What is Database?

What is RDBMS?

What is Oracle?

What is Oracle Database?

What is Oracle Database 11g?

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?

Basic Linux Commands which are helpful in DBA Activity.

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

What is SQL?

What is SQL Plus?

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

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

Oracle Database Architecture Overview

Process Architecture

Memory structures

Logical and physical storage structures

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

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)

Database User Creation/Management

Predefined Administrative Accounts

Benefits/Creation of Roles

Predefined Roles and Roles Management

Implementing Profiles

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

Standard Database Auditing

Value-Based Auditing

Fine-Grained Auditing

SYSDBA Auditing

Monitor and administer undo

Configure undo retention

Guarantee undo retention

Use the undo advisor

What is ORA-01555 Error?

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

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

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.

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

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

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

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

Download Oracle Database 11g Brochure

Signup today and get latest Videos and Upcoming Courses for free and be the first to get notified on new updates.

Subscribe to our mailing list