You are previewing Oracle Database 12c: Install, Configure & Maintain Like a Professional.
O'Reilly logo
Oracle Database 12c: Install, Configure & Maintain Like a Professional

Book Description

Master the Fundamentals of Oracle Database 12c Filled with easy-to-follow tutorials, this Oracle Press guide provides detailed coverage of core database concepts, the role of the administrator, and enterprise database capabilities. Oracle Database 12c: Install, Configure & Maintain Like a Professional walks you through database configuration, administration, programming, backup and recovery, and high availability. You'll get in-depth introductions to SQL and PL/SQL as well as important information on managing large databases and using Oracle's engineered systems. This essential beginner's resource features:

  • Critical Skills--Lists of specific skills covered in each chapter

  • Projects--Practical exercises that show how to apply the critical skills learned in each chapter

  • Progress Checks--Quick self-assessment sections to check your progress

  • Ask the Expert--Q&A sections filled with helpful tips

  • Notes--Extra information related to the topic being covered

  • Mastery Checks--Chapter-ending quizzes to test your knowledge

Table of Contents

  1. Cover 
  2. Title Page
  3. Copyright Page
  4. About the Authors
  5. Contents at a Glance
  6. Contents 
  7. Acknowledgments
  8. Introduction
    1. What’s in This Book
    2. Chapter 1: The Database: The Foundations of 12c
    3. Chapter 2: Installing Oracle
    4. Chapter 3: SQL: Accessing and Retrieving Data
    5. Chapter 4: Programming in the Database
    6. Chapter 5: The Database Administrator
    7. Chapter 6: Backup and Recovery
    8. Chapter 7: High Availability: RAC, ASM, and Data Guard
    9. Chapter 8: Using and Managing Large Databases
    10. Chapter 9: Oracle’s Engineered Systems: From the Database Appliance to Exadata
    11. Intended Audience
  9. Chapter 1: The Database: The Foundations of 12c
    1. CRITICAL SKILL 1.1. Define a Database
    2. CRITICAL SKILL 1.2. Become Familiar with the Characteristics of a Database
      1. Sharing
      2. Storage
      3. Data Consistency
      4. Data Integrity
    3. CRITICAL SKILL 1.3. Learn When to Use a Database
    4. CRITICAL SKILL 1.4. Learn the Oracle Database 12c Architecture
      1. Shared Memory
      2. System Support Processes
      3. Operating System Files
    5. CRITICAL SKILL 1.5. Work with Objects in the Oracle Database
      1. Tables
      2. Views
      3. Synonyms
      4. Stored Objects
    6. CRITICAL SKILL 1.6. Work with Data Types in an Oracle Database
      1. Variable Length Character—varchar2
      2. Number
      3. Datetime
      4. CLOB/BLOB
    7. CRITICAL SKILL 1.7. Pull It All Together: Objects and Data Types
    8. CRITICAL SKILL 1.8. Interact with the Data
      1. SQL*Developer
      2. sqlplus
    9. CRITICAL SKILL 1.9. Learn the New Features of Oracle Database 12c
      1. Pluggable Databases
      2. Application Development
      3. Availability
      4. Business Intelligence and Data Warehousing
      5. Compression and Archiving
      6. Overall Database Features
      7. Grid Features
      8. Manageability
      9. Performance
      10. Security
      11. XML DB
    10. Chapter 1: Mastery Check
  10. Chapter 2: Installing Oracle
    1. CRITICAL SKILL 2.1. Research and Plan the Installation
      1. Define System Requirements
      2. Linux Installation
    2. CRITICAL SKILL 2.2. Set Up the Operating System
    3. Project 2-1: Configure Kernel Parameters
      1. Step by Step
      2. Project Summary
    4. CRITICAL SKILL 2.3. Get Familiar with Linux
    5. CRITICAL SKILL 2.4. Choose Components to Install
    6. CRITICAL SKILL 2.5. Install the Oracle Software
      1. Database Configuration Assistant
      2. Verify the Installation
      3. Tie It All Together
    7. Chapter 2: Mastery Check
  11. Chapter 3: SQL: Accessing and Retrieving Data
    1. CRITICAL SKILL 3.1. Learn the SQL Statement Components
      1. DDL
      2. DML
    2. CRITICAL SKILL 3.2. Use Basic Insert and Select Statements
      1. Insert
      2. Select
    3. CRITICAL SKILL 3.3. Use Simple WHERE Clauses
      1. A WHERE Clause with AND/OR
      2. The WHERE Clause with NOT
      3. The WHERE Clause with a Range Search
      4. The WHERE Clause with a Search List
      5. The WHERE Clause with a Pattern Search
      6. The WHERE Clause: Common Operators
    4. CRITICAL SKILL 3.4. Use Basic Update, Delete, and Merge Statements
      1. Update
      2. Delete
      3. Insert
      4. Use Basic Merge Statements
    5. CRITICAL SKILL 3.5. Order Data
    6. CRITICAL SKILL 3.6. Employ Functions: String, Numeric, Aggregate (No Grouping)
      1. String Functions
      2. Numeric Functions
      3. Aggregate Functions
    7. CRITICAL SKILL 3.7. Use Dates and Data Functions (Formatting and Chronological)
      1. Date Functions
      2. Special Formats with the Date Data Type
      3. Nested Functions
    8. CRITICAL SKILL 3.8. Employ Joins (ANSI vs. Oracle): Inner, Outer, Self, Apply
      1. Inner Joins
      2. Outer Joins
    9. Project 3-1: Join Data Using Inner and Outer Joins
      1. Step by Step
      2. Project Summary
    10. Project 3-2: Join Data Using ANSI SQL Joins
      1. Step by Step
      2. Project Summary
      3. Self-Joins
    11. CRITICAL SKILL 3.9. Learn the Group By and Having Clauses
      1. Group By
      2. Having
    12. Project 3-3: Group Data in Your Select Statements
      1. Step by Step
      2. Project Summary
    13. CRITICAL SKILL 3.10. Learn Subqueries: Simple and Correlated Comparison with Joins
      1. Simple Subquery
      2. Correlated Subqueries with Joins
    14. CRITICAL SKILL 3.11. Use Set Operators: Union, Intersect, Minus
      1. Union
      2. Union All
      3. Intersect
      4. Minus
    15. Project 3-4: Use the Union Function in Your SQL
      1. Step by Step
      2. Project Summary
    16. CRITICAL SKILL 3.12. Use Views
    17. CRITICAL SKILL 3.13. Learn Sequences: Just Simple Stuff
    18. CRITICAL SKILL 3.14. Employ Constraints: Linkage to Entity Models, Types, Deferred, Enforced, Gathering Exceptions
      1. Linkage to Entity Models
      2. Types
      3. Deferred
    19. CRITICAL SKILL 3.15. Format Your Output with SQL*Plus
      1. Page and Line Size
      2. Page Titles
      3. Page Footers
      4. Formatting Columns
    20. Project 3-5: Format Your SQL Output
      1. Step by Step
      2. Project Summary
      3. Writing SQL*Plus Output to a File
    21. Chapter 3: Mastery Check
  12. Chapter 4: Programming in the Database
    1. CRITICAL SKILL 4.1. Define PL/SQL and Learn Why We Use It
    2. CRITICAL SKILL 4.2. Describe the Basic PL/SQL Program Structure
    3. CRITICAL SKILL 4.3. Define PL/SQL Data Types
      1. Valid Characters
      2. Arithmetic Operators
      3. The VARCHAR2 Data Type
      4. The NUMBER Data Type
      5. The DATE Data Type
      6. The BOOLEAN Data Type
      7. The VARRAY Data Type
    4. CRITICAL SKILL 4.4. Write PL/SQL Programs in SQL*Plus
    5. Project 4-1: Create a PL/SQL Program
      1. Step by Step
      2. Project Summary
      3. SQL in Your PL/SQL Programs
      4. PL/SQL Cursors
      5. The Cursor FOR Loop
    6. CRITICAL SKILL 4.5. Handle Error Conditions in PL/SQL
    7. CRITICAL SKILL 4.6. Include Conditions in Your Programs
      1. Program Control
      2. IF Logic Structures
      3. CASE Statements
      4. Loops
      5. The WHILE Loop
      6. The FOR Loop
    8. Project 4-2: Use Conditions and Loops in PL/SQL
      1. Step by Step
      2. Project Summary
    9. CRITICAL SKILL 4.7. Create Stored Procedures—How and Why
    10. CRITICAL SKILL 4.8. Create and Use Functions
    11. Project 4-3: Create and Use a Function
      1. Step by Step
      2. Project Summary
    12. CRITICAL SKILL 4.9. Call PL/SQL Programs
    13. Chapter 4: Mastery Check
  13. Chapter 5: The Database Administrator
    1. CRITICAL SKILL 5.1. Learn What a DBA Does
    2. CRITICAL SKILL 5.2. Perform Day-to-Day Operations
      1. Architecture and Design
      2. Capacity Planning
      3. Backup and Recovery
      4. Security
      5. Performance and Tuning
      6. Managing Database Objects
      7. Storage Management
      8. Change Management
      9. Schedule Jobs
      10. Network Management
      11. High Availability
      12. Troubleshooting
    3. CRITICAL SKILL 5.3. Understand the Oracle Database 12c Architecture
      1. Schemas
      2. Segments, Extents, and Blocks
      3. Pluggable Databases
      4. Logical Schema Structures
      5. Storage Structures
    4. CRITICAL SKILL 5.4. Operate Modes for an Oracle Database 12c
      1. Modes of Operation
      2. Container Database STARTUP
      3. Other Ways to Open the Database
      4. Forcing a Startup
      5. Database and Instance Shutdown
    5. CRITICAL SKILL 5.5. Get Started with Oracle Enterprise Manager
      1. Instance Configuration
      2. User Sessions
      3. Resource Consumer Groups
      4. Other Tools
    6. CRITICAL SKILL 5.6. Understand Database Connections
      1. Oracle Net Services
      2. Command-Line Utilities
      3. Connections
      4. Maintain Connections
      5. Define a Location
      6. A Connect Descriptor
      7. Define a Connect Descriptor
    7. CRITICAL SKILL 5.7. Manage Database Objects
      1. Control Files
      2. Redo Logs
      3. Undo Management
      4. Schema Objects
    8. CRITICAL SKILL 5.8. Manage Space
      1. Archive Logs
      2. Tablespaces and Data Files
    9. CRITICAL SKILL 5.9. Manage Users
      1. Create a User
      2. Edit Users
    10. CRITICAL SKILL 5.10. Manage Privileges for Database Users
      1. Grant Authority
      2. Types of Grants
      3. Take Away Authority
      4. Roles
      5. Oracle-Defined Roles
      6. Create and Grant a Role
      7. Profiles
      8. Tie It All Together
    11. Project 5-1: Create Essential Objects
      1. Step by Step
      2. Project Summary
    12. Chapter 5: Mastery Check
  14. Chapter 6: Backup and Recovery
    1. CRITICAL SKILL 6.1. Understand Rman
      1. RMAN Metadata
    2. CRITICAL SKILL 6.2. See Reasons to Use Rman
    3. CRITICAL SKILL 6.3. Understand Storage Media
    4. CRITICAL SKILL 6.4. Examine RMAN Components
      1. Backup
      2. Restore
      3. Recovery
    5. CRITICAL SKILL 6.5. Invoke Rman
    6. CRITICAL SKILL 6.6. Learn RMAN Commands
    7. CRITICAL SKILL 6.7. Review RMAN Channels
    8. CRITICAL SKILL 6.8. Examine RMAN Configuration
    9. CRITICAL SKILL 6.9. Explore Backup Commands
      1. Database
      2. Tablespace
      3. Datafile
      4. Control File
      5. Server Parameter File
      6. Archived Redo Logs
    10. CRITICAL SKILL 6.10. Conduct Incremental Backups
    11. CRITICAL SKILL 6.11. List Backups
    12. CRITICAL SKILL 6.12. See RMAN Metadata
    13. CRITICAL SKILL 6.13. Use RMAN Restore
    14. CRITICAL SKILL 6.14. Understand RMAN Recover
    15. CRITICAL SKILL 6.15. Learn About Backup Retention
    16. CRITICAL SKILL 6.16. Check Syntax
    17. CRITICAL SKILL 6.17. Recover a Table
    18. CRITICAL SKILL 6.18. Pull It All Together
      1. Backup Script
      2. Restore and Recovery Script
    19. Chapter 6: Mastery Check
  15. Chapter 7: High Availability: RAC, ASM, and Data Guard
    1. CRITICAL SKILL 7.1. Define High Availability
    2. CRITICAL SKILL 7.2. Understand Real Application Clusters
    3. CRITICAL SKILL 7.3. Install RAC
    4. CRITICAL SKILL 7.4. Test RAC
      1. Workload Manager
      2. ASM
    5. CRITICAL SKILL 7.5. Set Up the ASM Instance
    6. Project 7-1: Install ASMLib
      1. Step by Step
      2. Project Summary
      3. CRITICAL SKILL 7.6. Create ASM Disk Groups
    7. Project 7-2: Create Disk Groups
      1. Step by Step
      2. Project Summary
    8. CRITICAL SKILL 7.7. Use ASMCMD and ASMLib
    9. CRITICAL SKILL 7.8. Convert an Existing Database to ASM
    10. CRITICAL SKILL 7.9. Understand Data Guard
    11. CRITICAL SKILL 7.10. Explain Data Guard Protection Modes
    12. CRITICAL SKILL 7.11. Create a Physical Standby Server
    13. Project 7-3: Create a Physical Standby Server
      1. Step by Step
      2. Project Summary
    14. Chapter 7: Mastery Check
  16. Chapter 8: Using and Managing Large Databases
    1. CRITICAL SKILL 8.1. Learn to Identify a Very Large Database
    2. CRITICAL SKILL 8.2. How and Why to Use Data Partitioning
      1. Why Use Data Partitioning
      2. Manageability
      3. Performance
      4. Implement Data Partitioning
      5. Ask the Expert
    3. Project 8-1: Create a Range-Partitioned Table and a Local-Partitioned Index
      1. Step by Step
      2. Project Summary
    4. CRITICAL SKILL 8.3. Compress Your Data
      1. Data Compression
      2. Index Key Compression
      3. Automatic Data Optimization
    5. CRITICAL SKILL 8.4. Use Parallel Processing to Improve Performance
      1. Parallel Processing Database Components
      2. Parallel Processing Configuration
      3. Invoke Parallel Execution
    6. CRITICAL SKILL 8.5. Use Materialized Views
      1. Uses for Materialized Views
      2. Query Rewrite
      3. When to Create Materialized Views
      4. Create Materialized Views
    7. CRITICAL SKILL 8.6. Use SQL Aggregate and Analysis Functions
      1. Aggregation Functions
      2. rollup
      3. cube
      4. Analytic Functions
      5. Windowing Functions
      6. Other Functions
    8. CRITICAL SKILL 8.7. Create SQL Models
    9. Project 8-2: Use Analytic SQL Functions and Models
      1. Project Summary
    10. Chapter 8: Mastery Check
  17. Chapter 9: Oracle’s Engineered Systems: From the Database Appliance to Exadata
    1. CRITICAL SKILL 9.1. Understand Oracle Database Appliance
    2. CRITICAL SKILL 9.2. Manage Oracle Database Appliance
      1. Initial Configuration
    3. CRITICAL SKILL 9.3. Learn about Exadata’s Main Components
    4. CRITICAL SKILL 9.4. Understand Exadata Storage
      1. Exadata Storage Concepts
    5. CRITICAL SKILL 9.5. Accelerate Large Queries with Storage Offload
      1. Smart Scan in Action
      2. Why Smart Scans May Not Happen
    6. CRITICAL SKILL 9.6. Understand Storage Indexes
      1. Storage Indexes in Action
    7. CRITICAL SKILL 9.7. Use the Exadata Flash Cache
      1. Trying Out the Flash Cache
    8. CRITICAL SKILL 9.8. Save Storage Space with Hybrid Columnar Compression
      1. Hybrid Columnar Compression in Action
      2. Using DBMS_COMPRESSION to Estimate Compression
    9. CRITICAL SKILL 9.9. Enable Database Consolidation with I/O Resource Management
    10. Project 9-1: Create an Interdatabase IORM Plan
      1. Step by Step
      2. Project Summary
    11. CRITICAL SKILL 9.10. Perform Common Exadata Management Tasks
      1. User Accounts on Exadata Storage Servers
      2. Using DCLI to Retrieve Metrics from the Storage Server
      3. Using EXACHK to Validate Exadata Configurations
    12. CRITICAL SKILL 9.11. Manage Exadata with Oracle Enterprise Manager
      1. Wrapping Up
    13. Chapter 9: Mastery Check
  18. Appendix: Mastery Check Answers
    1. Chapter 1: The Database: The Foundations of 12c
    2. Chapter 2: Installing Oracle
    3. Chapter 3: SQL: Accessing and Retrieving Data
    4. Chapter 4: Programming in the Database
    5. Chapter 5: The Database Administrator
    6. Chapter 6: Backup and Recovery
    7. Chapter 7: High Availability: RAC, ASM, and Data Guard
    8. Chapter 8: Using and Managing Large Databases
    9. Chapter 9: Oracle’s Engineered Systems: From the Database Appliance to Exadata
  19. Index