Oracle Database 10g:
Administration Workshop I
Volume II • Student Guide
D17090GC31
Edition 3.1
December 2008
D57299
Oracle Internal & Oracle Academy Use Only
Copyright © 2008, Oracle. All rights reserved.
Disclaimer
This document contains proprietary information and is protected by copyright and
other intellectual property laws. You may copy and print this document solely for your
own use in an Oracle training course. The document may not be modified or altered in
any way. Except where your use constitutes "fair use" under copyright law, you may
not use, share, download, upload, copy, print, display, perform, reproduce, publish,
license, post, transmit, or distribute this document in whole or in part without the
express authorization of Oracle.
The information contained in this document is subject to change without notice. If you
find any problems in the document, please report them in writing to: Oracle University,
500 Oracle Parkway, Redwood Shores, California 94065 USA. This document is not
warranted to be error-free.
Restricted Rights Notice
If this documentation is delivered to the United States Government or anyone using
the documentation on behalf of the United States Government, the following notice is
applicable:
U.S. GOVERNMENT RIGHTS
The U.S. Government’s rights to use, modify, reproduce, release, perform, display, or
disclose these training materials are restricted by the terms of the applicable Oracle
license agreement and/or the applicable U.S. Government contract.
Trademark Notice
Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other
names may be trademarks of their respective owners.
Authors
Tom Best
Maria Billings
Technical Contributors
and Reviewers
Celia Antonio
Larry Baumann
Tammy Bednar
Howard Bradley
M.J. Bryksa
Sandra Cheevers
Steve Friedberg
Joel Goodman
John Hibbard
Magnus Isaksson
Sushma Jagannath
Christine Jeal
Steven Karam
Donna Keesling
Stella Kister
Pierre Labrousse
Stefan Lindblad
Dee Matishak
Paul Needham
Raza Siddiqui
James Spiller
Janet Stern
Barry Trute
Jean-Francois Verrier
Anthony Woodell
Editor
Joyce Raftery
Graphic Designer
Satish Bettegowda
Publisher
Jobi Varghese
Oracle Internal & Oracle Academy Use Only
Contents
Preface
1 Introduction
Course Objectives 1-2
Suggested Schedule 1-3
Lesson Objectives 1-4
Oracle Products and Services 1-5
Oracle Database 10g: “g” Stands for Grid 1-6
Oracle Database Architecture 1-8
Database Structures 1-9
Oracle Memory Structures 1-10
Process Structures 1-12
Oracle Instance Management 1-13
Server Process and Database Buffer Cache 1-14
Physical Database Structure 1-15
Tablespaces and Data Files 1-17
SYSTEM and SYSAUX Tablespaces 1-18
Segments, Extents, and Blocks 1-19
Logical and Physical Database Structures 1-20
Course Examples: The HR Schema 1-22
Database Architecture: Summary of Structural Components 1-23
Summary 1-24
2 Installing the Oracle Database Software
Objectives 2-2
Tasks of an Oracle Database Administrator 2-3
Tools Used to Administer an Oracle Database 2-4
Installation: System Requirements 2-6
Checking the System Requirements 2-7
Optimal Flexible Architecture (OFA) 2-8
Using Optimal Flexible Architecture 2-9
Setting Environment Variables 2-11
Oracle Universal Installer (OUI) 2-13
Installing the Oracle Software 2-14
Database Configuration Options 2-15
iii
Oracle Internal & Oracle Academy Use Only
Executing Configuration Scripts 2-16
Completing Your Installation 2-17
Advanced Installation Options 2-18
Installation Option: Silent Mode 2-19
Summary 2-20
Practice Overview: Installing the Oracle Software 2-21
3 Creating an Oracle Database
Objectives 3-2
Planning the Database 3-3
Databases: Examples 3-4
Database Configuration Assistant (DBCA) 3-5
Using the DBCA to Create a Database 3-6
Password Management 3-12
Creating a Database Design Template 3-13
Using the DBCA to Delete a Database 3-14
Summary 3-16
Practice Overview: Using the DBCA 3-17
4 Managing the Oracle Instance
Objectives 4-2
Management Framework 4-3
Starting and Stopping Database Control 4-4
Oracle Enterprise Manager 4-5
Accessing Oracle Enterprise Manager 4-6
Database Home Page 4-7
Using SQL*Plus and iSQL*Plus to Access Your Database 4-8
Using iSQL*Plus 4-9
Setting Up iSQL*Plus for SYSDBA and SYSOPER Access 4-10
Using SQL*Plus 4-12
Calling SQL*Plus from a Shell Script 4-13
Calling a SQL Script from SQL*Plus 4-14
Initialization Parameter Files 4-15
Simplified Initialization Parameters 4-16
Viewing and Modifying Initialization Parameters 4-18
Database Startup and Shutdown 4-19
Starting Up an Oracle Database Instance 4-20
Starting Up an Oracle Database Instance: NOMOUNT 4-21
Starting Up an Oracle Database Instance: MOUNT 4-22
Starting Up an Oracle Database Instance: OPEN 4-23
iv
Oracle Internal & Oracle Academy Use Only
Shutting Down an Oracle Database Instance 4-24
Shutdown Modes 4-25
SHUTDOWN Options 4-26
Using SQL*Plus to Start Up and Shut Down 4-29
Viewing the Alert Log 4-30
Viewing the Alert History 4-31
Dynamic Performance Views 4-32
Dynamic Performance Views: Usage Examples 4-33
Dynamic Performance Views: Considerations 4-34
Summary 4-35
Practice Overview: Managing the Oracle Instance 4-36
5 Managing Database Storage Structures
Objectives 5-2
Storage Structures 5-3
How Table Data Is Stored 5-4
Anatomy of a Database Block 5-5
Tablespaces and Data Files 5-6
Oracle Managed Files (OMF) 5-7
Space Management in Tablespaces 5-8
Exploring the Storage Structure 5-9
Creating a New Tablespace 5-10
Storage for Locally Managed Tablespaces 5-12
Tablespaces in the Preconfigured Database 5-14
Altering a Tablespace 5-16
Actions with Tablespaces 5-19
Dropping Tablespaces 5-21
Viewing Tablespace Information 5-22
Gathering Storage Information 5-23
Viewing Tablespace Contents 5-24
Enlarging the Database 5-25
What Is Automatic Storage Management? 5-26
ASM: Key Features and Benefits 5-27
ASM: Concepts 5-28
Summary 5-29
Practice Overview: Managing Database Storage Structures 5-30
6 Administering User Security
Objectives 6-2
Database User Accounts 6-3
Predefined Accounts: SYS and SYSTEM 6-5
v
Oracle Internal & Oracle Academy Use Only
