You are previewing OCA Oracle Database 12c Installation and Administration Exam Guide (Exam 1Z0-062), 2nd Edition.
O'Reilly logo
OCA Oracle Database 12c Installation and Administration Exam Guide (Exam 1Z0-062), 2nd Edition

Book Description

A Complete Study System for OCA Exam 1Z0-062

Prepare for the Oracle Certified Associate Oracle Database 12c Installation and Administration exam with this exclusive Oracle Press guide. Each chapter features challenging exercises, a certification summary, a two-minute drill, and a self-test to reinforce the topics presented. This authoritative resource helps you pass the exam and also serves as an essential, on-the-job reference. Get complete coverage of all OCA objectives for exam 1Z0-062, including:

  • Installing and upgrading Oracle Database software
  • Managing the database instance
  • Configuring the Oracle network environment
  • Managing database storage structures
  • Administering user security
  • Managing undo data and data concurrency
  • Implementing Oracle Database auditing
  • Performing database maintenance
  • Managing performance and tuning SQL
  • Managing resources using Oracle Database Resource Manager
  • Automating tasks
  • Moving data
  • Performing backup and recovery
  • Installing Oracle Grid Infrastructure for a standalone server

Electronic content includes:

  • 185+ practice exam questions with detailed answers and explanations
  • Test engine that provides custom exams by chapter or by domain
  • PDF copy of the book

Table of Contents

  1. CoverĀ 
  2. About the Authors
    1. About the Technical Editor
  3. Title Page
  4. Copyright Page
  5. Contents at a Glance
  6. ContentsĀ 
  7. Preface
  8. Introduction
  9. 1. Installing Oracle Database Software
    1. Plan for an Oracle Database Software Installation
      1. Supported Platforms
      2. Obtain the Oracle Database Software
      3. User Accounts
      4. Disk Space and Directories
      5. The Prerequisite Checks
    2. Install the Oracle Database Software
      1. The OUI Inventory
      2. The OUI Dialog: Interactive Install
      3. Silent Install and Response Files
      4. Windows and Linux Variations
      5. Exercise 1-1: Install the Oracle Database Software
    3. Two-Minute Drill
    4. Q&A Self Test
    5. Lab Question
    6. Self Test Answers
    7. Lab Answer
  10. 2. Creating an Oracle Database Using DBCA
    1. Create a Database by Using the Database Configuration Assistant (DBCA)
      1. The Instance, the Database, and the Data Dictionary
      2. Using the DBCA to Create a Database
      3. The DBCA Dialog
      4. Exercise 2-1: Create a Database with DBCA
    2. Generate Database Creation Scripts by Using DBCA
      1. Generating the Scripts
      2. The Creation Scripts
      3. The Initialization Parameter File
      4. Exercise 2-2: Generate Database Creation Scripts by Using DBCA
    3. Manage Database Design Templates by Using DBCA
      1. Exercise 2-3: Manage Database Design Templates by Using DBCA
    4. Configure Database Options by Using DBCA
      1. Exercise 2-4: Configure Database Options by Using DBCA
    5. Two-Minute Drill
    6. Q&A Self Test
    7. Lab Question
    8. Self Test Answers
    9. Lab Answer
  11. 3. Exploring the Oracle Database Architecture
    1. List the Architectural Components of an Oracle Database
      1. Single-Instance Database Architecture
      2. Distributed Systems Architectures
      3. Exercise 3-1: Identify the Components of the Database Server
    2. Explain the Memory Structures
      1. The Database Buffer Cache
      2. The Log Buffer
      3. The Shared Pool
      4. The Large Pool
      5. The Java Pool
      6. The Streams Pool
      7. Exercise 3-2: Investigate the Memory Structures of the Instance
    3. Describe the Background Processes
      1. SMON, the System Monitor
      2. PMON, the Process Monitor
      3. DBWn, the Database Writer
      4. LGWR, the Log Writer
      5. CKPT, the Checkpoint Process
      6. MMON, the Manageability Monitor
      7. MMNL, the Manageability Monitor Light
      8. MMAN, the Memory Manager
      9. LREG, the Listener Registration Process
      10. ARCn, the Archiver
      11. RECO, the Recoverer Process
      12. Some Other Background Processes
      13. Exercise 3-3: Investigate the Processes Running in Your Instance
    4. Explain the Relationship Between Logical and Physical Storage Structures
      1. The Physical Database Structures
      2. The Logical Database Structures
      3. The Data Dictionary
      4. Exercise 3-4: Investigate the Storage Structures in Your Database
    5. Two-Minute Drill
    6. Q&A Self Test
    7. Lab Question
    8. Self Test Answers
    9. Lab Answer
  12. 4. Managing the Database Instance
    1. Use Database Management Tools
      1. Working with SQL*Plus
      2. Log On as a Normal or Privileged User
      3. Working with Database Express
      4. Working with SQL Developer
      5. Exercise 4-1: Use Database Management Tools
    2. Understand Initialization Parameter Files
      1. Static and Dynamic Parameter Files
      2. Static and Dynamic Parameters and the Initialization Parameter File
      3. The Basic Parameters
      4. Changing Parameters
      5. Exercise 4-2: Query and Set Initialization Parameters
    3. Start Up and Shut Down an Oracle Database Instance
      1. Starting the Database Listener
      2. Database Startup and Shutdown
      3. Exercise 4-3: Start Up and Shut Down an Oracle Database Instance
    4. View the Alert Log and Access Dynamic Performance Views
      1. The Alert Log
      2. The DDL Log
      3. The Dynamic Performance Views
      4. Exercise 4-4: Use the Alert Log and Dynamic Performance Views
    5. Two-Minute Drill
    6. Q&A Self Test
    7. Lab Question
    8. Self Test Answers
    9. Lab Answer
  13. 5. Configuring the Oracle Network Environment
    1. Configure Oracle Net Services
      1. Oracle Net and the Client-Server Paradigm
      2. Establishing a Session
      3. Creating a Database Listener
      4. Dynamic Service Registration
      5. Shared Server
    2. Use Tools for Configuring and Managing the Oracle Network
      1. The Net Manager
      2. The Net Configuration Assistant
      3. The Listener Control Utility
      4. The TNS_ADMIN Environment Variable
    3. Configure Client-Side Network
      1. Easy Connect Name Resolution
      2. Local Naming Name Resolution
      3. Directory Naming and External Naming
      4. Testing Oracle Net Connectivity
      5. Exercise 5-1: Configure Oracle Net
    4. Understand Database Resident Connection Pooling
    5. Configure Communication Between Databases
      1. Exercise 5-2: Create and Use a Database Link
    6. Two-Minute Drill
    7. Q&A Self Test
    8. Lab Question
    9. Self Test Answers
    10. Lab Answer
  14. 6. Managing Database Storage Structures
    1. Describe the Storage of Table Row Data in Blocks
      1. The Oracle Data Storage Model
      2. Segments, Extents, Blocks, and Rows
      3. Exercise 6-1: Investigate Storage Structures
    2. Create and Manage Tablespaces
      1. Tablespace Creation
      2. Exercise 6-2: Create, Alter, and Drop Tablespaces
      3. Altering Tablespaces
      4. Dropping Tablespaces
      5. Extent Management
      6. Segment Space Management
      7. Oracle Managed Files (OMF)
      8. Exercise 6-3: Change Tablespace Characteristics
    3. Two-Minute Drill
    4. Q&A Self Test
    5. Lab Question
    6. Self Test Answers
    7. Lab Answer
  15. 7. Managing Space
    1. Explain How Oracle Database Server Automatically Manages Space
      1. Extent Management
      2. Exercise 7-1: Segment Space Management
      3. Automatic Segment Space Management (ASSM)
    2. Save Space by Using Compression
      1. Exercise 7-2: Investigate Compression
    3. Proactively Monitor and Manage Tablespace Space Usage
    4. Use the Segment Advisor
    5. Reclaim Wasted Space from Tables and Indexes by Using the Segment Shrink Functionality
    6. Manage Resumable Space Allocation
      1. Exercise 7-3: Use Resumable Space Allocation
    7. Two-Minute Drill
    8. Q&A Self Test
    9. Lab Question
    10. Self Test Answers
    11. Lab Answer
  16. 8. Administering User Security
    1. Create and Manage Database User Accounts
      1. User Account Attributes
      2. Authentication Methods
      3. Creating Accounts
      4. Exercise 8-1: Create Users
    2. Grant and Revoke Privileges
      1. System Privileges
      2. Object Privileges
      3. Exercise 8-2: Grant Direct Privileges
    3. Create and Manage Roles
      1. Creating and Granting Roles
      2. Predefined Roles
      3. Enabling Roles
      4. Privilege Analysis
      5. Exercise 8-3: Create and Grant Roles
    4. Create and Manage Profiles
      1. Password Profile Limits
      2. Creating and Assigning Profiles
      3. Exercise 8-4: Create and Use Profiles
    5. Two-Minute Drill
    6. Q&A Self Test
    7. Lab Question
    8. Self Test Answers
    9. Lab Answer
  17. 9. Managing Undo Data
    1. Explain DML and Undo Data Generation
      1. Database Transactions
      2. Undo Generation
      3. Executing SQL Statements
      4. How Transactions Use Undo Segments
      5. Exercise 9-1: Use Undo Data
    2. Monitor and Administer Undo Data
      1. Error Conditions Related to Undo
      2. Parameters for Undo Management
      3. Sizing and Monitoring the Undo Tablespace
      4. Temporary Undo
      5. Creating and Managing Undo Tablespaces
      6. Exercise 9-2: Work with Undo Tablespaces
    3. Describe the Difference Between Undo Data and Redo Data
    4. Configure Undo Retention
      1. Configuring Undo Retention to Support Long-Running Queries
      2. Flashback Query and Undo Retention
      3. Exercise 9-3: Work with Transactions and Flashback Query
    5. Two-Minute Drill
    6. Q&A Self Test
    7. Lab Question
    8. Self Test Answers
    9. Lab Answer
  18. 10. Managing Data Concurrency
    1. Describe the Locking Mechanism and How Oracle Manages Data Concurrency
      1. Shared and Exclusive Locks
      2. The Enqueue Mechanism
      3. Automatic and Manual Locking
    2. Monitor and Resolve Locking Conflicts
      1. The Causes of Lock Contention
      2. Detecting Lock Contention
      3. Solving Lock Contention
      4. Deadlocks: A Special Case
      5. Exercise 10-1: Monitor and Resolve Locking Conflicts
    3. Two-Minute Drill
    4. Q&A Self Test
    5. Lab Question
    6. Self Test Answers
    7. Lab Answer
  19. 11. Implementing Oracle Database Auditing
    1. Explain DBA Responsibilities for Security and Auditing
      1. Reasons for Audit
      2. Auditing Techniques
    2. Enable Standard Database Auditing and Unified Auditing
      1. Enable Standard Auditing
      2. Enable Unified Auditing
      3. Exercise 11-1: Use Unified Auditing
    3. Two-Minute Drill
    4. Q&A Self Test
    5. Self Test Answers
  20. 12. Performing Database Maintenance
    1. Manage the Automatic Workload Repository (AWR)
      1. Gathering AWR Statistics
      2. Managing the AWR
      3. Exercise 12-1: Monitor the Automatic Workload Repository
    2. Use the Automatic Database Diagnostic Monitor (ADDM)
      1. Exercise 12-2: Generate an ADDM Report
    3. Describe and Use the Advisory Framework
      1. The Memory Advisors
      2. The SQL Advisors
      3. The Automatic Undo Advisor
      4. The Mean Time to Recover (MTTR) Advisor
      5. The Data Recovery Advisor
      6. The Segment Advisor
      7. The SQL Repair Advisor
    4. Set Alert Thresholds
      1. Alert Condition Monitoring and Notifications
      2. Setting Thresholds
      3. Exercise 12-3: Configure Alerts
    5. Use Automated Tasks
      1. The Autotasks
      2. Controlling the Autotasks
    6. Two-Minute Drill
    7. Q&A Self Test
    8. Lab Question
    9. Self Test Answers
    10. Lab Answer
  21. 13. Managing Performance
    1. Use Enterprise Manager to Monitor Performance
      1. A Performance Tuning Methodology
      2. Performance Monitoring Data
      3. The Database Express Performance Pages
      4. Exercise 13-1: Use Enterprise Manager to Monitor Activity
    2. Use Automatic Memory Management
      1. PGA Memory Management
      2. SGA Memory Management
      3. Automatic Memory Management
      4. Exercise 13-2: Set the Memory Management Parameters
    3. Use the Memory Advisor to Size Memory Buffers
      1. Exercise 13-3: Use the Memory Advisors
    4. Two-Minute Drill
    5. Q&A Self Test
    6. Lab Question
    7. Self Test Answers
    8. Lab Answer
  22. 14. Managing Performance: SQL Tuning
    1. Manage Optimizer Statistics
      1. Object Statistics
      2. How the Optimizer Uses Statistics
      3. Gathering Statistics Manually
      4. Exercise 14-1: Gather Optimizer Statistics
    2. Use the SQL Tuning Advisor
      1. The Capabilities of the SQL Tuning Advisor
      2. The SQL Tuning Advisor API: The DBMS_SQLTUNE Package
      3. Exercise 14-2: Run the SQL Tuning Advisor for a SQL Statement
    3. Use the SQL Access Advisor to Tune Workload
      1. The Capabilities of the SQL Access Advisor
      2. Using the SQL Access Advisor with DBMS_ADVISOR
    4. Two-Minute Drill
    5. Q&A Self Test
    6. Lab Question
    7. Self Test Answers
    8. Lab Answer
  23. 15. Managing Resources Using Database Resource Manager
    1. Configure the Database Resource Manager
      1. The Need for Resource Management
      2. The Resource Manager Architecture
      3. Resource Manager Configuration
    2. Access and Create Resource Plans
      1. CPU Method
      2. Use of the Ratio CPU Method
      3. The Active Session Pool Method
      4. Limiting the Degree of Parallelism
      5. Controlling Jobs by Execution Time
      6. Terminating Sessions by Idle Time
      7. Restricting Generation of Undo Data
      8. Exercise 15-1: Create and Implement a Resource Manager Plan
    3. Monitor the Resource Manager
      1. Exercise 15-2: Test and Monitor a Resource Manager Plan
    4. Two-Minute Drill
    5. Q&A Self Test
    6. Lab Question
    7. Self Test Answers
    8. Lab Answer
  24. 16. Automating Tasks by Using Oracle Scheduler
    1. Use Oracle Scheduler to Simplify Management Tasks
      1. The Scheduler Architecture
      2. Scheduler Objects
      3. Exercise 16-1: Creating a Job with the Scheduler API
    2. Use Job Chains to Perform a Series of Related Tasks
    3. Use Scheduler Jobs on Remote Systems
    4. Use Advanced Scheduler Features to Prioritize Jobs
      1. Using Job Classes
      2. Using Windows
      3. Exercise 16-2: Use Scheduler Windows to Control the Resource Manager
    5. Two-Minute Drill
    6. Q&A Self Test
    7. Lab Question
    8. Self Test Answers
    9. Lab Answer
  25. 17. Moving Data
    1. Describe Ways to Move Data
    2. Create and Use Directory Objects
    3. Use SQL*Loader to Load Data from a Non-Oracle Database
      1. Using SQL*Loader
      2. SQL*Loader Express Mode
    4. Use External Tables to Move Data via Platform-Independent Files
      1. Exercise 17-1: Use Directories, SQL*Loader, and External Tables
    5. Explain the General Architecture of Oracle Data Pump
    6. Use Data Pump Export and Import to Move Data between Oracle Databases
      1. Capabilities
      2. Using Data Pump with the Command-Line Utilities
      3. Tablespace Export and Import
      4. Exercise 17-2: Use Data Pump Export/Import
    7. Two-Minute Drill
    8. Q&A Self Test
    9. Lab Question
    10. Self Test Answers
    11. Lab Answer
  26. 18. Backup and Recovery: Concepts and Configuration
    1. Identify the Importance of Checkpoints, Redo Logfiles, and Archive Logfiles
      1. Instance Recovery
      2. The Impossibility of Database Corruption
      3. Checkpointing
      4. Protecting the Online Redo Logfiles
      5. Archivelog Mode and the Archiver Process(es)
    2. Backup and Recovery: Configuration
      1. Exercise 18-1: Investigate and Adjust the Redo Log Configuration
    3. Configure the Fast Recovery Area
    4. Configure Archivelog Mode
      1. Exercise 18-2: Enable Archivelog Mode
    5. Two-Minute Drill
    6. Q&A Self Test
    7. Lab Question
    8. Self Test Answers
    9. Lab Answer
  27. 19. Backup and Recovery Operations
    1. Create Consistent Database Backups
      1. Exercise 19-1: Consistent Server-Managed Backup
    2. Back Up Your Database Without Shutting It Down
      1. Exercise 19-2: Perform Server-Managed Open Backups
    3. Create Incremental Backups
    4. Automate Database Backups
    5. Manage Backups
      1. The RMAN Repository
      2. Reports on Backups
      3. Administering Backups
    6. Determine the Need for Performing Recovery
    7. Use Recovery Manager (RMAN) and the Data Recovery Advisor to Perform Recovery of the Controlfile, Redo Logfile, and Datafile
      1. The Health Monitor and the ADR
      2. Using the DRA
      3. Exercise 19-3: Use the DRA to Diagnose and Repair a Problem
    8. Two-Minute Drill
    9. Q&A Self Test
    10. Lab Question
    11. Self Test Answers
    12. Lab Answer
  28. 20. Installing Oracle Grid Infrastructure for a Standalone Server
    1. Configure Storage for Oracle Automatic Storage Management (ASM)
      1. GI Architecture
      2. ASM Architecture
      3. ASM Disks
      4. Creating ASM Disks
    2. Install Oracle Grid Infrastructure for a Standalone Server
      1. Exercise 20-1: Install Grid Infrastructure
    3. Two-Minute Drill
    4. Q&A Self Test
    5. Lab Exercise
    6. Self Test Answers
    7. Lab Answer
  29. 21. Using Oracle Restart
    1. Use Oracle Restart to Manage Components
      1. Administering the Oracle Restart Processes
      2. Administering Registered Resources
      3. The Restart Capability
      4. Exercise 21-1: Configure a Database for Oracle Restart
    2. Two-Minute Drill
    3. Q&A Self Test
    4. Lab Exercise
    5. Self Test Answers
    6. Lab Answer
  30. 22. Upgrading Oracle Database Software and Migrating Data
    1. Describe Upgrade Methods
      1. Software Upgrade
      2. Database Upgrade: DBUA or Manual
    2. Describe Data Migration Methods
    3. Describe the Upgrade Process
    4. Migrating Data by Using Oracle Data Pump
      1. Exercise 22-1: Perform a Data Pump Full Database Migration
    5. Two-Minute Drill
    6. Q&A Self Test
    7. Self Test Answers
  31. 23. Database Upgrade: Preparation, Upgrading, and Post-Upgrade Tasks
    1. Describe Upgrade Requirements when Certain Features or Options Are Used in Oracle Database
      1. Oracle Label Security and Oracle Data Vault
      2. Oracle Warehouse Builder
    2. Use the Pre-Upgrade Information Tool Before Performing an Upgrade
    3. Prepare the New Oracle Home Prior to Performing an Upgrade
    4. Upgrade the Database to Oracle Database 12c by Using the Database Upgrade Assistant (DBUA)
    5. Perform a Manual Upgrade to Oracle Database 12c by Using Scripts and Tools
    6. Migrate to Unified Auditing
    7. Perform Post-Upgrade Tasks
      1. Exercise 23-1: Simulate Some Upgrade Tasks
    8. Two-Minute Drill
    9. Q&A Self Test
    10. Lab Question
    11. Self Test Answers
    12. Lab Answer
  32. A. About the Download
    1. System Requirements
    2. Installing and Running Total Tester
    3. About Total Tester
    4. Technical Support
  33. Glossary
  34. Index