3 Creating an Oracle Database Copyright 2004 Oracle
3 Creating an Oracle Database Copyright © 2004, Oracle. All rights reserved.
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 – – 3 -2 Create a database Configure a database Drop a database Manage templates Copyright © 2004, Oracle. All rights reserved.
Database Architecture Control files Data files Parameter file 3 -3 Online redo log files Password file Copyright © 2004, Oracle. All rights reserved. Archive log files
Exploring the Storage Structure Click on the links to view detailed information 3 -4 Copyright © 2004, Oracle. All rights reserved.
Control Files • • • Contain physical database structure information Multiplexed to protect against loss Required to start the instance Control files 3 -5 Copyright © 2004, Oracle. All rights reserved.
Redo Log Files • • Record changes to the database Multiplex to protect against loss Redo log buffer Log writer LGWR Group 1 3 -6 Group 2 Group 3 Copyright © 2004, Oracle. All rights reserved.
Tablespaces and Datafiles • • 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 Copyright © 2004, Oracle. All rights reserved.
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. Segment 3 -8 Extents Data blocks Copyright © 2004, Oracle. All rights reserved. OS blocks
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 DBW 0 Check point CKPT 3 -9 Log Writer LGWR Archiver ARC 0 Copyright © 2004, Oracle. All rights reserved.
Oracle Memory Structures Server Process 1 PGA Server Process 2 PGA Background Process SGA 3 -10 Shared Pool Streams Pool Large Pool Java Pool Database Buffer Cache Redo Log Buffer Copyright © 2004, Oracle. All rights reserved. PGA
Oracle Processes Server Process System Global Area SGA System Monitor SMON Process Database Monitor Writer PMON DBWn Check point CKPT Log Writer LGWR Background Processes 3 -12 Copyright © 2004, Oracle. All rights reserved. Archiver ARCn
Data Dictionary 3 -13 Copyright © 2004, Oracle. All rights reserved.
Database Control Database control 3 -14 Copyright © 2004, Oracle. All rights reserved.
Grid Control Grid control Management server Management repository Managed targets Agent Database control 3 -15 Agent Database OS/third-party application Agent Application server Copyright © 2004, Oracle. All rights reserved. Application server control
Database Configuration Assistant (DBCA) Overview 3 -16 Copyright © 2004, Oracle. All rights reserved.
Creating a Database 3 -17 Copyright © 2004, Oracle. All rights reserved.
Database Identification 3 -18 Copyright © 2004, Oracle. All rights reserved.
Management Options 3 -19 Copyright © 2004, Oracle. All rights reserved.
Passwords and Storage 3 -20 Copyright © 2004, Oracle. All rights reserved.
File Locations and Backup Recovery 3 -21 Copyright © 2004, Oracle. All rights reserved.
File Location Variables 3 -22 Copyright © 2004, Oracle. All rights reserved.
Content and Initialization Parameters 3 -23 Copyright © 2004, Oracle. All rights reserved.
Database Storage 3 -25 Copyright © 2004, Oracle. All rights reserved.
Creation Options and Create 3 -26 Copyright © 2004, Oracle. All rights reserved.
Other Actions with DBCA 3 -27 Copyright © 2004, Oracle. All rights reserved.
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 – – 3 -28 Create a database Configure a database Drop a database Manage templates Copyright © 2004, Oracle. All rights reserved.
Practice 3: Creating an Oracle Database This practice covers creating an Oracle database by using DBCA. 3 -29 Copyright © 2004, Oracle. All rights reserved.
- Slides: 27