Oracle Database 10g: 2 Day DBA Release 2

What you will learn

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.

Learn To:
  • 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

Course Objectives
 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 Topics
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 Pre-requisites
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