Oracle Database 11g:
Administration Workshop I
Volume II • Student Guide
D50102GC20
Edition 2.0
August 2010
D62542
Copyright © 2009, 2010, Oracle and/or it affiliates. 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 and Java are registered trademarks of Oracle and/or its affiliates. Other names
may be trademarks of their respective owners.
Authors
Deirdre Matishak
Mark Fuller
Technical Contributors
and Reviewers
Maria Billings
Herbert Bradbury
Yanti Chang
Timothy Chien
Andy Fotunak
Gerlinde Frenzen
Steve Friedberg
Joel Goodman
Vimala Jacob
Dominique Jeunot
Pete Jones
Fukue Kawabe
Donna Keesling
Sean Kim
Achiel Langers
Gwen Lazenby
Essi Parast
Randy Richeson
Joe Roch
Hilda Simon
Ira Singer
Jim Spiller
Supithran Thananayagam
Branislav Valny
Manju Varrier
Editors
Raj Kumar
Daniel Milne
Graphic Designer
Rajiv Chandrabhanu
Publishers
Jobi Varghese
Veena Narasimhan
iii
Contents
I Introduction
Course Objectives I-2
Suggested Schedule I-3
Oracle Products and Services I-4
Oracle Database 11g: “g” Stands for Grid I-5
Grid Infrastructure for Single-Instance I-7
1 Exploring the Oracle Database Architecture
Objectives 1-2
Oracle Database 1-3
Connecting to a Server 1-4
Oracle Database Server Architecture: Overview 1-6
Instance: Database Configurations 1-7
Connecting to the Database Instance 1-8
Oracle Database Memory Structures 1-9
Shared Pool 1-11
Database Buffer Cache 1-13
Redo Log Buffer 1-14
Large Pool 1-15
Java Pool and Streams Pool 1-16
Program Global Area (PGA) 1-17
Quiz 1-18
Process Architecture 1-20
Process Structures 1-21
Database Writer Process (DBWn) 1-23
Log Writer Process (LGWR) 1-25
Checkpoint Process (CKPT) 1-27
System Monitor Process (SMON) 1-28
Process Monitor Process (PMON) 1-29
Recoverer Process 1-30
Archiver Processes (ARCn) 1-31
Process Startup Sequence 1-32
Database Storage Architecture 1-33
Logical and Physical Database Structures 1-35
iv
Segments, Extents, and Blocks 1-37
Tablespaces and Data Files 1-38
SYSTEM and SYSAUX Tablespaces 1-39
Automatic Storage Management 1-40
ASM Storage Components 1-41
Interacting with an Oracle Database: Memory, Processes and Storage 1-42
Quiz 1-44
Summary 1-46
Practice 1: Overview 1-47
2 Installing your Oracle Software
Objectives 2-2
Tasks of an Oracle Database Administrator 2-3
Tools for Administering an Oracle Database 2-4
Planning Your Installation 2-6
Oracle Grid Infrastructure and Oracle Database Installation: System
Requirements 2-8
Preparing the Operating System 2-9
Setting Environment Variables 2-10
Checking the System Requirements 2-11
Oracle Universal Installer (OUI) 2-12
Example: Installation Scenario 2-13
Part One: Installing the Oracle Grid Infrastructure for Standalone Server 2-14
Selecting Product Languages 2-15
Creating an ASM Disk Group 2-16
Defining ASM Passwords 2-17
Defining Privileged Operating System Groups 2-18
Specifying Installation Location 2-19
Creating Inventory 2-20
Performing Prerequisite Checks 2-21
Verifying Installation Summary Data 2-22
Monitoring Installation Progress 2-23
Executing root Configuration Scripts 2-24
Executing Configuration Assistants 2-25
Finishing Installation 2-26
Configuring the FRA Disk Group 2-27
Quiz 2-28
Part Two: Installing the Oracle Database Software 2-30
Choosing the Type of Installation 2-31
Choosing Grid Installation Options 2-32
Choosing Language Settings 2-33
v
Choosing the Database Edition 2-34
Specifying Installation Location 2-35
Choosing Operating System Groups 2-36
Performing Prerequisite Checks 2-37
Installation Summary Page 2-38
The Install Product Page 2-39
Installation Finished 2-40
Installation Option: Silent Mode 2-41
Quiz 2-42
Summary 2-44
Practice 2 Overview: Preparing the Database Environment 2-45
3 Creating an Oracle Database Using DBCA
Objectives 3-2
Planning the Database 3-3
Databases: Examples 3-4
Choosing the Appropriate Character Set 3-5
How Are Character Sets Used? 3-7
Problems to Avoid 3-8
Database Configuration Assistant (DBCA) 3-9
Using the DBCA to Create a Database 3-10
Create Database Summary 3-16
Password Management 3-17
Creating a Database Design Template 3-18
Using the DBCA to Delete a Database 3-19
Using the DBCA for Additional Tasks 3-21
Quiz 3-22
Summary 3-24
Practice 3 Overview: Using the DBCA 3-25
4 Managing the Database Instance
Objectives 4-2
Management Framework 4-3
Starting and Stopping Database Control 4-4
Oracle Enterprise Manager 4-5
Database Home Page 4-7
Other Oracle Tools 4-8
Using SQL*Plus 4-9
Calling SQL*Plus from a Shell Script 4-10
Calling a SQL Script from SQL*Plus 4-11
Initialization Parameter Files 4-12
