Creating an oracle database
This presentation is the property of its rightful owner.
Sponsored Links
1 / 27

Creating an Oracle Database PowerPoint PPT Presentation


  • 106 Views
  • Uploaded on
  • Presentation posted in: General

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

Download Presentation

Creating an Oracle Database

An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -

Presentation Transcript


Creating an oracle database

Creating an Oracle Database


Objectives

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


Database architecture

Database Architecture

  • Data files

Control files

  • Online redo log files

  • Archive log files

  • Parameter file

  • Password file


Exploring the storage structure

Exploring the Storage Structure

Click on the links to view detailed information


Control files

Control Files

  • Contain physical database structure information

  • Multiplexed to protect against loss

  • Required to start the instance

Control files


Redo log files

Redo Log Files

  • Record changes to the database

  • Multiplex to protect against loss

Redo log

buffer

Log

writer

LGWR

Group 1

Group 3

Group 2


Tablespaces and datafiles

Tablespaces and Datafiles

  • Tablespaces consist of one or more data files

  • Data files belong to only one tablespace

Data file 2

Data file 1

USERS Tablespace


Segments extents and blocks

Segment

Extents

Data blocks

OS blocks

Segments, Extents, and Blocks

  • 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.


Oracle instance management

Oracle Instance Management

SGA

Shared Pool

Streams Pool

Large Pool

Java Pool

Database

Buffer Cache

Redo Log

Buffer

System

Monitor

SMON

Process

Monitor

PMON

Database

Writer

DBW0

Log

Writer

LGWR

Check

point

CKPT

Archiver

ARC0


Oracle memory structures

Oracle Memory Structures

Server

Process

1

Server

Process

2

Back-

ground

Process

PGA

PGA

PGA

SGA

Streams Pool

Large Pool

Shared Pool

Database

Buffer Cache

Redo Log

Buffer

Java Pool


Oracle processes

Oracle Processes

Server

Process

Server

Process

Server

Process

Server

Process

System Global Area

SGA

System

Monitor

SMON

Process

Monitor

PMON

Database

Writer

DBWn

Check

point

CKPT

Log

Writer

LGWR

Archiver

ARCn

Background Processes


Data dictionary

Data Dictionary


Database control

Database Control

Database control


Grid control

Grid Control

Grid control

Management server

Management repository

Managed targets

Agent

Agent

Agent

Database control

Database

OS/third-party application

Application server

Application server control


Database configuration assistant dbca overview

Database Configuration Assistant (DBCA) Overview


Creating a database

Creating a Database


Database identification

Database Identification


Management options

Management Options


Passwords and storage

Passwords and Storage


File locations and backup recovery

File Locations and Backup Recovery


File location variables

File Location Variables


Content and initialization parameters

Content and Initialization Parameters


Database storage

Database Storage


Creation options and create

Creation Options and Create


Other actions with dbca

Other Actions with DBCA


Summary

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


Practice 3 creating an oracle database

Practice 3: Creating an Oracle Database

  • This practice covers creating an Oracle database by using DBCA.


  • Login