ORA10g201 - Oracle Database 10g: Administration I

Course ORA10g201

Table of Contents

Introduction
Audience
At Course Completion
Prerequisites
Certified Professional Exams
Student Materials
Course Outline

Introduction

This 5-day course provides a starting point for administration of the Oracle database. The first 2-day segment considers an in-depth discussion of the database architecture, including the Oracle instance, background processes, the SGA and memory structures, data files, tablespaces, extents, blocks and rows. Common administration tasks are also considered such as security, backup & recovery, physical storage of indexes and tables and many others.

Return to Top

Audience

The target audience for this course is Oracle database administrators. Additionally, senior database developers will benefit from an understanding of the architecture of the Oracle database with which they interface.

Return to Top

At Course Completion

Major tasks to be considered are:

• Software installation and the creation of new databases.
• An in-depth exploration of the database architecture, including memory, process and data structures, and the management of those structures.
• Management of database files.
• Management of security policies and procedures, including administration of user accounts, roles, privileges and profiles.
• Utilization of advanced self-tuning and self-management capabilities, including the use of Oracle-Managed Files, database Advisors and other components of the Management Framework.
• Performance monitoring, problem troubleshooting, and resolving lock and conflict issues.
• Using the Oracle Enterprise Manager and SQL interfaces for administration tasks.
• Control over database support services, including iSQL*Plus, the Database Control, Oracle Net and others.
• A primer on backup and recovery structures and strategies.
• Operating system-specific considerations for UNIX, Linux and MS Windows.

Return to Top

Prerequisites

Before attending this course, students must have:

• Completed ora10g008, Oracle Database 10g: Introduction to SQL I, or equivalent.
• Completed ora10g009, Oracle Database 10g: Introduction to SQL II, or equivalent.

It is also recommended that students have:

• Completed ora10g101, Oracle Database 10g: Program with PL/SQL, or equivalent.

Suggested Next Course

• ora10g202, Oracle Database 10g: Administration II

Return to Top

Certified Professional Exams

This course will help the student prepare for the following Certified Professional exams:

• Exam 1Z0-042, Oracle Database 10g: Administration I

Return to Top

Student Materials

The student kit includes a comprehensive workbook and other necessary materials for this class.

Return to Top

Course Outline

INSTALLING ORACLE 10G DATABASE SOFTWARE

• IDENTIFY DATABASE SYSTEM REQUIREMENTS
• THE OPTIMAL FLEXIBLE ARCHITECTURE (OFA)
• CONFIGURE THE INSTALLATION ENVIRONMENT
• INSTALLATION USING THE UNIVERSAL INSTALLER
• MORE ABOUT ENTERPRISE MANAGER

EXPLORING THE ORACLE DATABASE ARCHITECTURE

• GENERAL DATABASE ARCHITECTURE
• DATABASE INSTANCE MEMORY ARCHITECTURE

DATABASE INSTANCE PROCESS ARCHITECTURE

• ABOUT THE INSTANCE PROCESS ARCHITECTURE
• INSTANCE BACKGROUND PROCESSES
• SQL EXECUTION PROCESSES

CREATING AN ORACLE DATABASE

• CREATE A DATABASE
• CONFIGURE & DROP A DATABASE
• MANAGE DBCA TEMPLATES
• MANUALLY CREATING A DATABASE

CONTROLLING THE DATABASE ENVIRONMENT

• STARTING & STOPPING DATABASE CONTROL
• STARTING & STOPPING ISQL*PLUS
• STARTING & STOPPING THE DATABASE LISTENER
• STARTING & STOPPING THE DATABASE
• MORE ABOUT THE DATABASE FILES
• HANDLING PARAMETER FILES & PARAMETER SETTINGS

STORAGE STRUCTURES: TABLESPACES

• ABOUT TABLESPACES
• TABLESPACE MANAGEMENT

STORAGE STRUCTURES: ADVANCED TABLESPACES

• MORE ABOUT TEMPORARY TABLESPACES
• ABOUT TEMPORARY TABLESPACE GROUPS
• MORE ABOUT PERMANENT TABLESPACES
• MORE ABOUT BIGFILE TABLESPACES
• MORE ABOUT THE SYSAUX TABLESPACE

STORAGE STRUCTURES: DATA FILES & TEMP FILES

• MANAGING DATA FILES
• MANAGING TEMP FILES
• ABOUT ORACLE-MANAGED FILES (OMF)

UNDO MANAGEMENT

• ABOUT UNDO SPACE MANAGEMENT
• CONFIGURE UNDO MANAGEMENT
• GUARANTEE UNDO RETENTION
• MONITOR UNDO SPACE
• USE THE UNDO ADVISOR

DATABASE SECURITY

• DATABASE SYSTEM PRIVILEGES
• DATABASE OBJECT PRIVILEGES
• AUDIT DATABASE ACTIVITY
• REGISTER FOR SECURITY UPDATES

ADMINISTERING USERS

• CREATE & MANAGE DATABASE ACCOUNTS
• GRANT & REVOKE DATABASE PRIVILEGES
• RESOURCE LIMITS VIA PROFILES
• PASSWORD MANAGEMENT VIA PROFILES
• ABOUT ROLE-BASED SECURITY

MANAGING DATA: LOADING DATA WITH SQL LOADER

• ABOUT THE DATABASE UTILITIES
• USING THE LOADER
• UNDERSTANDING THE LOADER PROCESS
• CONTROL FILE OPTIONS
• DIRECT PATH LOADS

MANAGING DATA: EXPORTING & IMPORTING DATA

• CREATE DIRECTORY OBJECTS
• EXPDP
• IMPDP

ORACLE NET SERVICES

• WHAT IS ORACLE NET SERVICES?
• ORACLE NET MANAGER
• LISTENER CONFIGURATION
• LISTENER ADMINISTRATION
• LSNRCTL COMMANDS
• CONFIGURING CLIENT PARAMETERS
• ISOLATING THE PROBLEM
• ORACLE TRACE ASSISTANT
• NETWORK TROUBLESHOOTING UTILITIES

ORACLE SHARED SERVERS

• SHARED SERVERS ARCHITECTURE
• CONFIGURATION OF SHARED SERVER MODE

MONITORING & RESOLVING LOCK CONFLICTS

• ABOUT LATCHES & LOCKS
• MORE ABOUT LATCHES
• MORE ABOUT LOCKS

BACKUP & RECOVERY CONCEPTS

• ABOUT DATABASE BACKUP & RECOVERY
• ABOUT REDO DATA
• REDO LOG FILE MAINTENANCE
• MANAGING THE ARCHIVE OPTIONS
• MORE ABOUT THE CONTROL FILE

Return to Top