1 / 27

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

takoda
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. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Creating an Oracle Database

  2. 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. Database Architecture • Data files Control files • Online redo log files • Archive log files • Parameter file • Password file

  4. Exploring the Storage Structure Click on the links to view detailed information

  5. Control Files • Contain physical database structure information • Multiplexed to protect against loss • Required to start the instance Control files

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

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

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

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

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

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

  12. Data Dictionary

  13. Database Control Database control

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

  15. Database Configuration Assistant (DBCA) Overview

  16. Creating a Database

  17. Database Identification

  18. Management Options

  19. Passwords and Storage

  20. File Locations and Backup Recovery

  21. File Location Variables

  22. Content and Initialization Parameters

  23. Database Storage

  24. Creation Options and Create

  25. Other Actions with DBCA

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

  27. Practice 3: Creating an Oracle Database • This practice covers creating an Oracle database by using DBCA.

More Related