Creating An Oracle Database
Creating An Oracle Database
Creating An Oracle Database
Objectives
After completing this lesson, you should be able to do the following: Describe the Oracle database architecture Understand the instance architecture Use the management framework Use DBCA to
Create a database Configure a database Drop a database Manage templates
3-2
Database Architecture
Control files
Data files
Parameter file
3-3
Password file
Copyright 2004, Oracle. All rights reserved.
3-4
Control Files
Contain physical database structure information Multiplexed to protect against loss Required to start the instance
Control files
3-5
Group 1
Group 2
Group 3
3-6
Tablespaces consist of one or more data files Data files belong to only one tablespace
Data file 1
Data file 2
USERS Tablespace
3-7
Segments exist within a tablespace. Segments are made of a collection of extents. Extents are a collection of data blocks. Data blocks are mapped to OS blocks.
Segment
Extents
Data blocks
OS blocks
3-8
Java Pool
Archiver ARC0
3-9
Server Process 1
PGA
Server Process 2
PGA
Background Process
PGA
Java Pool
3-10
Oracle Processes
Server Process Server Process Server Process Server Process
Archiver ARCn
Background Processes
3-12
Data Dictionary
3-13
Database Control
Database control
3-14
Grid Control
Grid control
Management server
Agent
Agent
Agent
Database control
Database
OS/third-party application
Application server
3-15
3-16
Creating a Database
3-17
Database Identification
3-18
Management Options
3-19
3-20
3-21
3-22
3-23
Database Storage
3-25
3-26
3-27
Summary
In this lesson, you should have learned how to: Describe the Oracle database architecture Understand the instance architecture Use the management framework Use DBCA to
Create a database Configure a database Drop a database Manage templates
3-28
3-29