Course Icon Oracle Database Training

Oracle Database 11g Release 2 DBA - Part I

0800 1337 401

Overview

The Oracle Database 11g Release 2 DBA - Part I course is designed to give the Oracle database administrator practical experience in setting up, administering and troubleshooting an Oracle 11g Release 1 or Release 2 database. Database administrators will gain an understanding of the architecture and processes of the Oracle database server. They will be able to ensure the integrity and availability of a company's data within the Oracle environment. They will be able to monitor the performance of the database and perform basic backup and recovery of the database.

This Oracle Database 11g Release 2 DBA - Part I course is suitable for users of both Release 1 and Release 2.

Prerequisites

Delegates who wish to attend the Oracle Database 11g Release 2 DBA - Part I course should have an understanding of relational database concepts and good operating system knowledge. They should have attended the Oracle SQL course or have a good working knowledge of Oracle SQL. Knowledge of PL/SQL would be beneficial.

Objectives

This Oracle Database 11g Release 2 DBA - Part I course is designed to give database administrators the knowledge and skills needed to maintain successful and efficient day-to-day operations of an Oracle 11g database. The Oracle Database 11g administrator will gain practical experience in setting up, administering and troubleshooting an Oracle 11g database.

Outline

Course Contents - DAY 1

Course Introduction

  • Administration and Course Materials
  • Course Structure and Agenda
  • Delegate and Trainer Introductions

Session 1: INTRODUCTION TO ORACLE DATABASE 11g

  • Relational database concepts
  • Database administration tasks
  • DBA responsibilities

Session 2: ORACLE DATABASE 11g ARCHITECTURE

  • Oracle database architecture
  • The Oracle instance
  • Memory structures
  • Background processes
  • Server and client processes
  • The Oracle database
  • Overview of Oracle ASM architecture

Session 3: INSTALLATION AND CONFIGURATION OF AN ORACLE DATABASE

  • System Hardware Requirements
  • Optimal Flexible Architecture
  • Authentication methods for a database
  • Oracle environment variables
  • Install Oracle software using the Oracle Universal Installer (OUI)
  • Silent Install
  • Use the database Configuration Assistant (DBCA)
  • Create a database with DBCA
  • Manage a database with DBCA
  • Delete a database with DBCA
  • Manage Templates using DBCA

Session 4: ADMINISTER A DATABASE INSTANCE

  • Administrative tools available to a DBA
  • Using SQL*Plus in Oracle to manage a database
  • Administer the database using Enterprise Manager (EM)
  • Start and stop the EM Database Console
  • Access EM
  • EM navigation
  • Grant EM administrative privileges to a user
  • Overview of Oracle Restart

Session 5: CONFIGURE THE ORACLE NETWORK ENVIRONMENT

  • Overview of network configuration
  • Oracle Net Listener configuration and management
  • Oracle Net Naming methods
  • Tools for configuring and managing the Oracle network
  • Use Enterprise Manager to create and configure the Listener
  • Configure client connections with Net Manager
  • View listener configuration
  • Start and stop the Oracle listener
  • Enable Oracle Restart to monitor the listener
  • Use TNSPING to test Oracle Net connectivity
  • Connect to the database
  • Configure Net Services with Enterprise Manager
  • Overview of Dedicated Server architecture
  • Overview of Shared Server architecture
  • Identify when to use Shared Servers and when to use Dedicated Servers

Course Contents - DAY 2

Session 6: MANAGE AN ORACLE INSTANCE

  • Access an Oracle database
  • Database authentication methods
  • Password file
  • The Startup Process
  • The Shutdown Process
  • Initialization parameters
  • Shutdown a database and instance using SQL and EM
  • Startup a database and instance using SQL and EM
  • View alert log and trace files
  • View or modify initialization parameters with EM

Session 7: TABLESPACE AND DATAFILE MANAGEMENT

  • Overview of tablespaces and datafiles
  • Use EM to view the storage structure of the database
  • Create and alter tablespace commands
  • Locally managed tablespaces
  • Dictionary managed tablespaces
  • Bigfile tablespaces
  • Temporary tablespaces
  • Multiple temporary tablespaces
  • Create tablespaces
  • Manage tablespaces
  • Use standard and non-standard block sizes
  • Create and manage tablespaces using OMF
  • Drop tablespace command

Session 8: MANAGE REDO LOGS

  • Redo log overview
  • Plan redo logs
  • Redo log data dictionary tables
  • Log switches and checkpoints
  • Log file maintenance
  • Add and drop log file members and groups
  • Clear a log file
  • Move or rename an online redo log file
  • Multiplex redo log files
  • Use EM to manage redo logs
  • Manage online redo log files with OMF
  • List redo log information

Session 9: MANAGE CONTROL FILES

  • The usage of the control file
  • The contents of a control file
  • Manage control files
  • Replace a lost or damaged control file
  • Mirror a control file
  • Standby control file
  • Manage control files with OMF
  • List control file information

Course Contents - DAY 3

Session 10: MANAGE SCHEMA OBJECTS

  • Create a new table
  • View the attributes and contents of a table
  • Understand data integrity
  • Define constraints
  • Alter tables
  • Create indexes
  • View index attributes
  • Create views
  • Create and use sequences

Session 11: MANAGE USERS

  • Database administration accounts
  • User accounts
  • Create a user account
  • Operating system authentication
  • Change a user's password
  • Manage a user account
  • Drop a user account
  • Monitor user information
  • Terminate user sessions
  • Product user profiles

Session 12: MANAGE PROFILES AND RESOURCES

  • Overview of user profiles
  • Profile resource parameters
  • Create profile command
  • Manage passwords with profiles
  • Control resource usage with profiles
  • Maintain profiles
  • Drop profiles

Session 13: MANAGING PRIVILEGES

  • Database access
  • Oracle supplied roles
  • System level privileges
  • Object level privileges
  • The grant and revoke commands
  • Create roles
  • Modify and drop roles
  • Control the availability of roles
  • Use predefined roles
  • Synonyms
  • Listing valid grants

Session 14: DATABASE AUDITING

  • Overview of database auditing
  • Auditing SYS statements
  • Auditing end user sessions
  • Statement auditing
  • Privilege auditing
  • Auditing modifications made to database objects
  • Audit table relocation
  • Auditing from Enterprise Manager

Course Contents - DAY 4

Session 15: UNDO MANAGEMENT

  • Undo data overview
  • Monitor and administer undo
  • Configure undo retention
  • Switch undo tablespaces
  • Specify the retention period
  • Guarantee undo retention
  • Retention period for flashback queries
  • View undo space information
  • Use the undo advisor
  • Size the undo tablespace
  • Manage undo with EM

Session 16: MOVING DATA

  • Create directory objects

  • Data Pump Export and Import

    • Data Pump architecture
    • Data Pump data dictionary views
    • Data Pump interactive mode
    • Data Pump API
    • Use Data Pump to export data
    • Use Data Pump to import data

  • SQL Loader

    • Overview of SQL Loader
    • Command line parameters
    • Record filtering
    • Control file keywords
    • Datafiles
    • SQL Loader data paths

Session 17: OVERVIEW OF MANAGING AN ASM INSTANCE

  • Overview of Automatic Storage Management
  • ASM Storage Components
  • Set up initialization files for an ASM instance
  • Startup and Shutdown ASM Instances
  • Administer ASM disk groups
  • Administer ASM Files

Session 18: DATA CONCURRENCY AND LOCK CONFLICTS

  • Levels of locking in Oracle
  • Methods used to acquire locks
  • Possible causes of contention
  • Deadlocks
  • Prevent locking problems
  • Detect lock contention
  • Resolve conflicts in an emergency

Course Contents - DAY 5

Session 19: PROACTIVE DATABASE MAINTENANCE

  • Self Monitoring Architecture
  • Automatic Workload Repository
  • Automatic Database Diagnostic Monitoring
  • Monitor an Oracle database
  • Use the Advisors
  • Set up notification rules

Session 20: PERFORMANCE MANAGEMENT

  • Tuning information sources
  • Identify unusable objects
  • Optimizer Statistics collection
  • Automated statistics collection
  • Performance metrics
  • Use the advisors
  • React to performance issues

Session 21: BACKUP AND RECOVERY CONSIDERATIONS

  • Oracle Backup solutions
  • Overview of Oracle Secure Backup
  • Oracle Suggested Backup Strategy
  • Database backup, restore and recover
  • Types of failure
  • Tune instance recovery
  • Checkpoints, redo log files and archive log files
  • Alter the ARCHIVELOG mode of a database
  • Configure a database for recoverability

Session 22: DATABASE BACKUPS

  • Types of RMAN backup
  • Backup sets and image copies
  • Perform backups using EM
  • Automate database backups
  • Configure backup settings
  • Catalog settings
  • Monitor the flash recovery area
  • Manage backups

Session 23: DATABASE RECOVERY

  • Restore and recovery operations
  • Recover an entire database from backup
  • Recover from the loss of a system critical data file
  • Recover from the loss of a control file
  • Recover from the loss of a redo log file
  • Data Recovery Advisor

Session 24: ENHANCE THE CAPABILITIES OF THE DATABASE

  • Enterprise Manager Support Workbench
  • Register for security updates
  • Work with Oracle support
  • Log Service Requests
  • Manage patches
See all of the available Technical Courses