Database 10g R2: 2 Day DBA

Course Overview

The goal of this course is to teach Database Adminstrators how to install the Oracle Database software and perform the tasks required to manage an Oracle database. Enterprise Manager is used exclusively throughout to teach students how to quickly accomplish the required task. Emphasis is on the self-managing capabilities and automatic features of Oracle Database 10g. This course is targeted towards Database Administrators of small to medium sized businesses.

• Install the Database
• Monitor and Tune the Database
• Navigate in the EM
• Manage the Oracle Instance
• Perform Backup and Recovery
• Administer Users and Security

Audience

• Database Administrators
• SAP Administrator
• Sales Consultants

Skills Gained

• Installing the Oracle Database software and creating a database
• Using Enterprise Manager Database Control to manage the database
• Configuring and managing the Oracle Network environment
• Managing database storage structures
• Administering users and security
• Managing schema objects
• Backing up and recovering the Oracle database
• Monitoring the database and using the Advisors
• Updating Oracle software with patch releases
• Tuning the database

Course Outline

Overview of Oracle Database Administration

• Overview of the Oracle Instance and Database
• Tasks of an Oracle Database Administrator
• Tools Used to Administer an Oracle Database

Installing Oracle Software and Creating the Database

• Using the Oracle Universal Installer (OUI)
• Installation Prerequisites
• Installing the Oracle Software
• Using the Database Configuration Assistant (DBCA) to Create a Database
• Using DBCA to Manage Templates
• Using DBCA to Add Options to Your Database

Using Oracle Enterprise Manager Database Control and SQL*Plus

• Overview of Administering the Database Using Enterprise Manager (EM)
• Starting the EM Database Console
• Enterprise Manager Navigation
• Granting EM Administrative Privileges
• Using SQL*Plus and iSQL*Plus to Access Your Database

Configuring the Oracle Network Environment

• Network Configuration Overview
• Oracle Net Listener Configuration and Management
• Oracle Net Naming Methods
• Tools for Configuring and Managing the Oracle Network

Managing the Oracle Instance

• Oracle Instance and Instance Management
• Accessing the Oracle Database
• Initialization Parameters and Password File
• Starting Up and Shutting Down the Instance
• Viewing the Alert Log and Trace Files

Managing Database Storage Structures

• Oracle Database Structures
• Creating a New Tablespace
• Managing Undo and Using the Undo Advisor
• Multiplexing the Redo Log File

Administering Users and Security

• Overview of Users and Security
• Creating and Administering Users
• Locking and Unlocking Accounts
• Setting Passwords
• Administering Privileges and Roles

Managing Schema Objects

• Creating Schema Objects
• Creating and Modifying Tables
• Understanding Data Integrity and Defining Constraints
• Viewing the Attributes and Contents of a Table
• Creating Indexes and Views
• 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 EM
• Whole Database Backups
• Oracle-Suggested Backup Strategy
• Restoring and Recovering the Whole Database

Monitoring and Tuning the Database

• Monitoring the Oracle Database
• Self-Monitoring Architecture
• Monitoring and Tuning Usage Model
• Using the Advisors

Managing Oracle Software

• Working with Oracle Support
• Search MetaLink
• Logging TARs
• Applying a Patch Release