Contents

Title and Copyright Information

Send Us Your Comments

Pref ace

Audience

Organization

Related Documentation

Conventions

Documentation Accessibility

1 Introduction

About this Book

< dl>

What this Book is Not

How to Use this Book with Relate d Material

The Oracle Database

Common O racle DBA Tasks

Tools for Administering the Database

2 Installing Oracle and Building the Database

Overview of Installation

Chec king Prerequisites

Installation Choices

Installing Your Oracle Software and Database

Using DBCA to Create and Configure a Da tabase

Starting DBCA

Using DBCA to Create a Database

Database Templates

Database Identification

Management Options

Database Credentials

Storage Options

Database File Locations

Recovery Configuration

Databa se Content

Initialization Parameters

Database Storage

Creation Options

Using DBC A to Delete a Database

Using DBCA to Configure Database Options

Managing Templates with DBCA

Advantages of Using Templates

Types of Templates

DBCA Templates Provided by Oracle

Creating Templates Using DBCA

Deleting DBCA Templates

Upgrading a Database

Overview of the Database Upgrade Assistant

Before the Upg rade

During the Upgrade

Real Application Clus ters Support

Support for Silent Mode

Oracle Database Version Restrictions

Starting the Database Upgrade Assistant

< dd>Upgrading the Database Using the Database Upgrade Assistant

Installation: Oracle by Example Series

3 Getting Started with Oracle Enterprise Manager

Introduction to the Oracle Enterprise Manager

Database M anagement Features

Online Help

Navigati onal Features

Starting the Oracle Enterprise Manager Console

< dl>

Starting dbconsole in Windows

Acce ssing the Oracle Enterprise Manager

Granting Database Control Administrative Privilege s

Setting Up Enterprise Manager Preferences

Defining Blackout Time Periods

Setting Preferred Credentials

SQL Statements and Other Management Tools: SQL*Plus and iSQL*Plus

Starting SQL*Plus

Starting iSQL*Plus

Managing Your Database: A Roadmap

Getting Started: Oracle by Example Series

4 Configuring the Network Environment

Understanding Network Configuration

Oracle Net Listener Conf iguration

Client Configuration

Connection R equests

Naming Methods

Local Nami ng

Directory Naming

Easy Connect Naming

External Naming

Tools for Network Configuration

Oracle Net Configuration Assistant

Enterprise Manager

Oracle Net Manager

Viewing Listener Configuration

Starting and Shutting Down t he Listener

Configuring Oracle Networking on Client Machines

Networking: Oracle by Example Series

5 Managing the Oracle Instance

O verview of an Instance and Instance Management

Instance Memory Structure< /dd>

The System Global Area (SGA)

Progra m Global Area (PGA)

Oracle Background Processes

Accessing the Database

How the Oracle Instance and Database are Started

Server and Client Processes

N etwork Connections

About Initialization Parameters

Shutting Down and Restarting the Instance and Database

Starting and Shutting Down the Database Instance on Windows

Viewing a nd Modifying Initialization Parameters

Managing Memory Parameters

Modifying Memory Parameters

Instances: Ora cle by Example Series

6 Managing Database Storage Structures

Exploring the Storage Struct ure of Your Database

The Control File

Redo Log Files

Multiplexing the Redo Log

Archive Log Files

Rollback Segments

Tablespaces

Tablespaces Page

Some Tablespaces in the Database

Temporary Tablespace Groups

Datafiles

Other Storage Structures

Initialization Parameter File

Password File

Backup Files

Common DBA T asks for Managing Database Storage

Viewing Tablespaces in Your Database

Creating a Tablespace

Modifying a Tablespace< /dd>

Dropping a Tablespace

Reclaiming Wasted Space

Using the Segment Advisor

Shrinkin g Database Objects

Managing Undo for Your Database

About Undo

Undo Tablespace Size and Retention Time

Automatic Undo Management

Undo Management with Enterprise Manager

Using Oracle Recommendations for Managing Undo

Extending the Undo Tablespace

Using the Undo Advisor

Setting New Threshold Undo Retention Time

Making Changes to the Database Storage Structure

Storage: Oracle by Example Series

7 Administering Users and Security

Overvie w of Users and Security

Database Administrative Accounts

SYS

SYSTEM

Administrative Privileges

Administering R oles

Viewing Roles

Crea ting a New Role

Modifying Roles

D ropping Roles

Administering Profiles

Administering Database Users

Creating Users

Using a Shortcut to Create Users

Editing Users

Unlocking Accounts and Resetting Passwords

Granting Roles

Revoking Roles

Dropping Users

Users: Oracle by Example Series< /a>

8 Managing Sch ema Objects

Overview of Schemas and Common Schema Objects

Exploring Your Database's Schema Objects

Managing Data base Objects

Managing Tables

Viewing Tables

Viewing Table Data

Creatin g Tables

Types of Table

Column Attr ibutes

Table Level Constraints

Storage Attrib utes

Other Table Creation Considerations

Esti mating the Size of New Tables

Table Creation Example

Modifying Table Attributes

Adding a Column

Dropping a Column

Creating a New Table Constraint

Modifying an Existing Constraint

Dropping a Constraint

Dropping a Table

Managing In dexes

Viewing Indexes

Creating a Ne w Index

Index Types

Index Creation Example

Dropping Indexes

Managing Views

View Creation Example

Managing Database Resident Program Units

Managing Packages

Managing Package Bodies

Managing Standalone Subprogra ms

Managing Triggers

Other Schema O bjects

Loading Data Into Tables

Managing Acce ss to Schema Objects

Some Schemas of Interest

SYS Schema

SYSTEM Schema

Sample Sc hemas

Schemas: Oracle by Example Series

9 Performing Backup and Recovery

Overview of Oracle Backup and Recovery

Oracle Backup, Restore and Recovery Concepts

Consistent and Inconsistent Bac kups

Media Recovery

The RMAN Repository

The Flash Recovery Area

Configuring Your Database for Basic Backup and Recovery

Planning Space Usag e and Location for the Flash Recovery Area

Retention Policy and the Flash Rec overy Area

Sizing the Flash Recovery Area

Credentials for Performing Oracle Enterprise Manager Backup and Recovery

Con figuring the Flash Recovery Area and ARCHIVELOG Mode

Configuring Backup Settings

Understanding Backup Device Settings for Disk

Configuring Backup Policy Settings

Recording Your DBID and DB_UNIQUE _NAME

Backing Up Your Database

Database Backup Concepts

Full Backups of Datafiles

Incremental Backups of Datafiles

Incrementally Updated Ba ckups: Rolling Forward Image Copies of Datafiles

Tagging Backups

Performing and Scheduling Backups with Enterprise Manager

Performing a Whole Database Backup with Oracle Enterprise Manager

Using the Oracle-Suggested Backup Strategy

Scheduling Other Backup Tasks

< dd>Validating Backups

Restore and Recovery O perations

Recovering a Whole Database from Backup

Recovering from a Lost SPFILE or Control File

Re turning a Table to a Past State: Flashback Table

Enabling Row Movement on a T able

Performing Flashback Table

Recovering Dropped Tables: Flashback Drop

Managing Your Backups

Using the Manage Current Backups Page in Enterprise Manager

Crosschecking Backups

Deleting Expired Backups

Deleting Obsolete Backups

Marking Backups Unavailable

< dd>Cataloging Additional Backups

Backup and Recovery: Oracle by Example Series

10 Monitoring and Tuning the Database

Proactive Databa se Monitoring

Alerts

Performance Self-Diagnostics: Automatic Database Diagnostics Monitor

Monitoring General Database Sta te and Workload

Managing Alerts

V iewing Metrics and Thresholds

Setting Metric Thresholds

Setting up Notification

Responding to Alerts

Clearing Alerts

Diagnosing Performance Problems

Viewing Performance Analysis

Respondin g to Performance Findings

Modifying Default ADDM Behavior

Running ADDM Manually

Using Advisors to Optimize Database Perfo rmance

About Performance Advisors

Using the SQL Tuning Advisor

Using the SQL Access Advisor

Using the Memory Advisor

Monitoring and Tuning: Oracle by Exam ple Series

Index