Oracle - Course Details

OraD11g:AWIR2 Oracle Database 11g: Administration Workshop I Release 2

Oracle Course Description:
This Oracle Database 11g: Administration Workshop I Release 2 course explores the fundamentals of basic database administration. Expert Oracle University instructors will reinforce topics with structured hands-on practices that will prepare you for the corresponding Oracle Certified Associate exam.
Oracle Course Duration:
5 DAYS
Oracle Course Target Audience:
Database Administrators,Java Developer,Support Engineer,Technical Administrator,Technical Consultant
Oracle Course Prerequisite:
Taken Oracle Introduction to SQL course or equivalent experience,Taken Oracle PL/SQL course or equivalent experience
Course Content:
  • Exploring the Oracle Database Architecture

    • Oracle Database Architecture Overview
    • Oracle ASM Architecture Overview
    • Process Architecture
    • Memory structrues
    • Logical and physical storage structures
    • ASM storage components

  • Installing your Oracle Software

    • Tasks of an Oracle Database Administrator
    • Tools Used to Administer an Oracle Database
    • Installation: System Requirements
    • Oracle Universal Installer (OUI)
    • Installing Oracle Grid Infrastructure
    • Installing Oracle Database Software
    • Silent Install

  • Creating an Oracle Database

    • Planning the Database
    • Using the DBCA to Create a Database
    • Password Management
    • Creating a Database Design Template
    • Using the DBCA to Delete a Database

  • Managing the Oracle Database Instance

    • Start and stop the Oracle database and components
    • Use Oracle Enterprise Manager
    • Access a database with SQLPlus
    • Modify database installation parameters
    • Describe the stages of database startup
    • Describe database shutdown options
    • View the alert log
    • Access dynamic performance views

  • Manage the ASM Instance

    • Set up initialization parameter files for ASM instance
    • Start up and shut down ASM instances
    • Administer ASM disk groups

  • Configuring the Oracle Network Environment

    • Use Enterprise Manager to create and configure the Listener
    • Enable Oracle Restart to monitor the listener
    • Use tnsping to test Oracle Net connectivity
    • Identify when to use shared servers and when to use dedicated servers

  • Managing Database Storage Structures

    • Storage Structures
    • How Table Data Is Stored
    • Anatomy of a Database Block
    • Space Management in Tablespaces
    • Tablespaces in the Preconfigured Database
    • Actions with Tablespaces
    • Oracle Managed Files (OMF)

  • Administering User Security

    • Database User Accounts
    • Predefined Administrative Accounts
    • Benefits of Roles
    • Predefined Roles
    • Implementing Profiles

  • Managing Data Concurrency

    • Data Concurrency
    • Enqueue Mechanism
    • Resolving Lock Conflicts
    • Deadlocks

  • Managing Undo Data

    • Data Manipulation
    • Transactions and Undo Data
    • Undo Data Versus Redo Data
    • Configuring Undo Retention

  • Implementing Oracle Database Auditing

    • Describe DBA responsibilities for security
    • Enable standard database auditing
    • Specify audit options
    • Review audit information
    • Maintain the audit trail

  • Database Maintenance

    • Manage optimizer statistics
    • Manage the Automatic Workload Repository (AWR)
    • Use the Automatic Database Diagnostic Monitor (ADDM)
    • Describe and use the advisory framework
    • Set alert thresholds
    • Use server-generated alerts
    • Use automated tasks

  • Performance Management

    • Performance Monitoring
    • Managing 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 Concepts

    • Part of Your Job
    • Statement Failure
    • User Error
    • Understanding Instance Recovery
    • Phases of Instance Recovery
    • Using the MTTR Advisor
    • Media Failure
    • Archive Log Files

  • Performing Database Backups

    • Backup Solutions: Overview
    • Oracle Secure Backup
    • User-Managed Backup
    • Terminology
    • Recovery Manager (RMAN)
    • Configuring Backup Settings
    • Backing Up the Control File to a Trace File
    • Monitoring the Flash Recovery Area

  • Performing Database Recovery

    • Opening a Database
    • Data Recovery Advisor
    • Loss of a Control File
    • Loss of a Redo Log File
    • Data Recovery Advisor
    • Data Failures
    • Listing Data Failures
    • Data Recovery Advisor Views

  • Moving Data

    • Describe ways to move data
    • Create and use directory objects
    • Use SQL*Loader to move data
    • Use external tables to move data
    • General architecture of Oracle Data Pump
    • Use Data Pump export and import to move data

  • Working with Support

    • Use the Enterprise Manager Support Workbench
    • Work with Oracle Support
    • Log service requests (SR)
    • Manage patches