Oracle Database 10g: Administration Workshop I

Introduction

Copyright © 2005, Oracle. All rights reserved.

Objectives •

After completing this course, you should be able to do the following: – Install, create, and administer Oracle Database 10g Enterprise Edition – Configure the database for an application – Implement a backup and recovery strategy – Employ basic monitoring procedures

•

After completing this lesson, you should be able to do the following: – Describe course objectives – Explain the Oracle Database 10g architecture

1-2

Copyright © 2005, Oracle. All rights reserved.

Oracle Products • • • • • •

1-3

Oracle databases Oracle Application Server Oracle Applications Oracle Collaboration Suite Oracle Developer Suite Oracle services

Copyright © 2005, Oracle. All rights reserved.

Oracle Database 10g: “g” Stands for Grid • • •

1-4

Low cost High quality of service Easy to manage Storage grid

Database grid

Application grid

Grid control

Automatic Storage Management

Real Application Clusters

Oracle Streams

Enterprise Manager Grid Control

Copyright © 2005, Oracle. All rights reserved.

Oracle Database Architecture

An Oracle server: • Is a database management system that provides an open, comprehensive, integrated approach to information management • Consists of an Oracle instance and an Oracle database

1-6

Copyright © 2005, Oracle. All rights reserved.

DB structures - Memory - Process - Storage

Database Structures

Memory structures

Instance System Global Area (SGA)

Process structures

Background processes

Storage structures

1-7

Database files

Copyright © 2005, Oracle. All rights reserved.

Oracle Memory Structures DB structures - Memory