tailieunhanh - Course Objectives

Course Objectives 1-2 Suggested Schedule 1-3 Lesson Objectives 1-4 Oracle Products and Services 1-5 Oracle Database 10g: “g” Stands for Grid 1-6 | Preface 1 Introduction Course Objectives 1-2 Suggested Schedule 1-3 Lesson Objectives 1-4 Oracle Products and Services 1-5 Oracle Database 10g: “g” Stands for Grid 1-6 Oracle Database Architecture 1-8 Database Structures 1-9 Oracle Memory Structures 1-10 Process Structures 1-12 Oracle Instance Management 1-13 Server Process and Database Buffer Cache 1-14 Physical Database Structure 1-15 Tablespaces and Data Files 1-17 SYSTEM and SYSAUX Tablespaces 1-18 Segments, Extents, and Blocks 1-19 Logical and Physical Database Structures 1-20 Course Examples: The HR Schema 1-22 Database Architecture: Summary of Structural Components 1-23 Summary 1-24 2 Installing the Oracle Database Software Objectives 2-2 Tasks of an Oracle Database Administrator 2-3 Tools Used to Administer an Oracle Database 2-4 Installation: System Requirements 2-6 Checking the System Requirements 2-7 Optimal Flexible Architecture (OFA) 2-8 Using Optimal Flexible Architecture 2-9 Setting Environment Variables 2-11 Oracle . | Preface 1 Introduction Course Objectives 1-2 Suggested Schedule 1-3 Lesson Objectives 1-4 Oracle Products and Services 1-5 Oracle Database 10g: “g” Stands for Grid 1-6 Oracle Database Architecture 1-8 Database Structures 1-9 Oracle Memory Structures 1-10 Process Structures 1-12 Oracle Instance Management 1-13 Server Process and Database Buffer Cache 1-14 Physical Database Structure 1-15 Tablespaces and Data Files 1-17 SYSTEM and SYSAUX Tablespaces 1-18 Segments, Extents, and Blocks 1-19 Logical and Physical Database Structures 1-20 Course Examples: The HR Schema 1-22 Database Architecture: Summary of Structural Components 1-23 Summary 1-24 2 Installing the Oracle Database Software Objectives 2-2 Tasks of an Oracle Database Administrator 2-3 Tools Used to Administer an Oracle Database 2-4 Installation: System Requirements 2-6 Checking the System Requirements 2-7 Optimal Flexible Architecture (OFA) 2-8 Using Optimal Flexible Architecture 2-9 Setting Environment Variables 2-11 Oracle Universal Installer (OUI) 2-13 Installing the Oracle Software 2-14 Database Configuration Options 2-15 Executing Configuration Scripts 2-16 Completing Your Installation 2-17 Advanced Installation Options 2-18 Installation Option: Silent Mode 2-19 Summary 2-20 Practice Overview: Installing the Oracle Software 2-21 Contents iii 3 Creating an Oracle Database Objectives 3-2 Planning the Database 3-3 Databases: Examples 3-4 Database Configuration Assistant (DBCA) 3-5 Using the DBCA to Create a Database 3-6 Password Management 3-12 Creating a Database Design Template 3-13 Using the DBCA to Delete a Database 3-14 Summary 3-16 Practice Overview: Using the DBCA 3-17 4 Managing the Oracle Instance Objectives 4-2 Management Framework 4-3 Starting and Stopping Database Control 4-4 Oracle Enterprise Manager 4-5 Accessing Oracle Enterprise Manager 4-6 Database Home Page 4-7 Using SQL*Plus and iSQL*Plus to Access Your Database 4-8 Using iSQL*Plus 4-9 Setting Up iSQL*Plus for SYSDBA and SYSOPER Access .