You are previewing Oracle Database 10g Linux Administration.
O'Reilly logo
Oracle Database 10g Linux Administration

Book Description

Oracle's Mr. Linux details everything from installing the OS (Red Hat and United Linux) to installing the database to debugging and troubleshooting to performance, availability, and scalability. Wim is the Director of Linux Engineering at Oracle.

Table of Contents

  1. Cover Page
  2. Oracle Database 10g Linux Administration
  3. Copyright Page
  4. About the Author
  5. Contents
  6. Acknowledgments
  7. Introduction
  8. Part I Oracle on Linux Overview
    1. 1 Linux Architecture
      1. Operating System Overview
        1. The Monolithic Kernel
        2. The Microkernel
      2. Linux Overview
        1. The Linux Directory Structure
        2. Linux Utilities and Directories
        3. The Development Environment
      3. The Linux User Interface
        1. X Windows
        2. GUI Environments
      4. Linux Web Server Utilities
        1. The Apache Web Server
        2. CGI Programming in Linux
        3. The Linux Boot Process
        4. Linux Source Code
        5. Rebuilding the Linux Kernel
      5. Processes and Threads
        1. What Is a Process?
        2. Oracle’s Use of Processes
        3. What Is a Thread?
      6. Devices
        1. Character Devices
        2. Block Devices
        3. Logical Volume Managers
        4. Automatic Storage Management
      7. Filesystems
        1. ext3
        2. OCFS
        3. Raw Devices
      8. Summary
    2. 2 Oracle Architecture
      1. The Oracle Database Server
      2. The Oracle Database
        1. Physical Data Structures
        2. Logical Data Structures
      3. The Oracle Instance
        1. The Instance Defined
        2. Components of the Instance
      4. User Processes
        1. Server Processes
        2. PGA Memory
        3. MTS vs. Dedicated Server Processes
      5. Oracle 10g New Features
        1. Performance and Scalability Features
        2. Clustering
        3. Availability
        4. Manageability
        5. Business Intelligence
        6. Application Development
        7. Linux 64-Bit Support
      6. Grid Computing
      7. Summary
    3. 3 Transaction Management and the Oracle Schema Objects
      1. Oracle Functionality
        1. Reading from the Database
        2. Concurrency
        3. Writing to the Database
        4. Locking
        5. Read Consistency
        6. Data Integrity
        7. The Redo Log
        8. Undo
      2. Introduction to Transaction Management
        1. Transactions
      3. Introduction to the Oracle Schema Objects
        1. Tables
        2. Indexes
        3. Views
        4. Sequences
        5. Clusters
        6. Synonyms
      4. Summary
  9. Part II Deploying Oracle 10g on Linux
    1. 4 Sizing Oracle 10g on Linux Systems
      1. An Introduction to Sizing
        1. Sizing for Peak Utilization and Steady-State Utilization
        2. Service-Level Agreements
      2. System Resources, Capacity, and Queuing
        1. CPU Performance and Queuing
        2. I/O Performance and Queuing
        3. Network Performance
        4. Memory
      3. Metrics
      4. Oracle Sizing
        1. Limitation Parameters
        2. Resource Parameters
      5. Hardware Sizing
        1. CPU Sizing
        2. Memory Sizing
        3. I/O Subsystem Sizing
      6. RAID Disk Subsystems
        1. Hardware vs. Software RAID
        2. Striping
        3. Parity Overview
      7. Capacity Planning
      8. Summary
    2. 5 Configuring the Linux System for Oracle
      1. Preinstallation Procedures for Linux
        1. Minimum Requirements
        2. Configuring the Filesystems
        3. Choosing Linux Components
      2. Post-Installation Procedures for Linux
        1. Configuring Kernel Parameters
        2. Adding Users and Groups
        3. Configuring Shell Limits for the Oracle User
        4. Creating Directory Structures
        5. Setting Up the Oracle Environment
      3. Installation Checklists
        1. Installation Checklist for Oracle 10g R1
        2. Installation Checklist for Oracle 10g R2
      4. Summary
    3. 6 Installing Oracle 10g on Linux
      1. Preinstallation Steps
        1. Kernel Configuration Parameters
        2. Storage Requirements
        3. Device Names Might Change
          1. Configuring the ASM Library Driver
          2. Setting Up ASM Drives
      2. The Installation Process
        1. Staging the Install
        2. Running the Installer
      3. Postinstallation Steps
        1. Downloading and Installing Patches
        2. Configuration Steps
        3. Testing and Validating
        4. Additional Miscellaneous Configuration Steps
      4. Summary
  10. Part III Oracle RAC on Linux
    1. 7 Oracle Real Application Cluster Concepts
      1. What Is Clustering?
        1. Cluster Terminology
        2. Cluster Definition
      2. RAC (Real Application Clusters)
        1. Overview of RAC
        2. Oracle RAC 10g Components
        3. RAC Database Components
        4. Oracle 10g RAC’s Use of Shared Storage
        5. Using NAS as Shared Storage
      3. Summary
    2. 8 Deploying Oracle Real Application Clusters on Linux
      1. Planning the RAC System
        1. The RAC Components
        2. Sizing the RAC System
      2. Configuring Linux
        1. Verifying Hardware
        2. Verifying Network Requirements
        3. Setting Up the Linux Kernel
        4. Setting Up the Linux System
      3. Configuring Linux Modules/Programs
        1. Oracle Directories
        2. Setting Environment Variables
        3. Networking
      4. Configuring RAC
        1. Configuring the Cluster Ready Services (CRS)
        2. Configuring the Interconnect
        3. Configuring the Shared Disk
        4. Testing and Managing the RAC
      5. Oracle 10g RAC Help
      6. Summary
    3. 9 Administering Oracle and RAC on Linux
      1. Configuring the Linux Kernel
        1. Configuring Shared Memory
        2. Configuring Semaphores and Other Kernel Parameters
        3. Monitoring and Changing Linux Configuration Parameters
      2. Configuring the Network
      3. Monitoring Linux
        1. sar
        2. vmstat
        3. top
        4. iostat
      4. Upgrading the Linux Operating System
      5. Starting Up the Instance
        1. Database Startup
        2. Database Mounted
        3. Database Opened
        4. Starting Up from the Enterprise Manager Database Control
      6. Oracle Database 10g and CSSD
      7. User Authentication
        1. Database Authentication
        2. Operating System Authentication
        3. Network Authentication
        4. Remote Authentication
        5. Mid-Tier Authentication
        6. Authentication by SSL
        7. User Authorization
        8. User Profiles
        9. Privileges
      8. Adding a User Account
      9. Summary
    4. 10 Tuning Oracle and RAC on Linux
      1. Performance Tuning Methodology
        1. Step 1: Initial Assessment
        2. Step 2: Monitor the System
        3. Step 3: Analyze Results
        4. Step 4: Create a Hypothesis
        5. Step 5: Propose a Solution
        6. Step 6: Implementation of Solution
        7. Step 7: Test and Monitor
        8. Further Analysis and Testing
      2. Tuning Oracle on Linux
        1. Application Tuning
        2. Instance Tuning Basics
        3. Monitoring the Oracle Instance
        4. Tuning for Wait Events
        5. Hardware Tuning
        6. Monitoring the Linux System
        7. Monitoring Linux with ps
        8. Monitoring Linux Using vmstat
        9. Monitoring Linux Using iostat
        10. Monitoring Linux Using sar
        11. Monitoring Linux Using Top
      3. Using Large Memory Models
        1. Configuring Linux for > 1.7GB (and <= 2.7GB) of SGA
        2. Configuring Oracle for > 2.7GB SGA
      4. Using Load Testing for Performance Validation
        1. Why Is the System Being Tested?
        2. Load-Testing Batch Jobs
        3. Load-Testing Loading
        4. Load-Testing OLTP Applications
        5. Performance Metrics
        6. Load Testing Tips
      5. Summary
  11. Part IV Administering and Tuning Oracle Database 10g on Linux
    1. 11 Backup and Recovery
      1. Backup Overview
      2. Backup and Recovery Concepts
        1. Instance Recovery
        2. Data Recovery or Media Recovery
        3. Online and Archived Redo Log File Recovery
        4. How Transactions Work
        5. RDBMS Functionality
      3. Introduction to Backup
        1. Archivelog Backup
        2. Controlfile Backup
        3. Full Backup
        4. Tablespace and Datafile Backups
        5. Incremental Backups
      4. How to Back Up the Database
        1. Recovery Manager (RMAN)
        2. Automatic Disk-Based Backup and Recovery (Flash Recovery Area)
        3. OS Facilities: Online Backup
        4. Export and Data Pump
        5. Commercially Available Backup Utilities
      5. Backup Strategies
        1. When and What to Back Up
        2. Examples of Backup Strategies
      6. Summary
    2. 12 Restore
      1. Recovering the Database
        1. Recovery vs. Restoration
      2. How to Recover Your Database
        1. Instance Recovery
        2. Media Recovery
        3. Log File Recovery
        4. Point-in-Time Recovery
        5. Using the Flashback Features of Oracle 10g
      3. Developing a Recovery Strategy
        1. Planning for Instance Recovery
        2. Planning for Media Recovery
        3. Planning for Operator Error Recovery
      4. Summary
    3. 13 Oracle Data Guard on Linux
      1. Data Guard Concepts
        1. Data Guard Services
        2. Physical Standby Database
        3. Logical Standby Database
      2. Configuring and Managing Oracle Data Guard
        1. Physical Standby Database Configuration
        2. Logical Standby Database Configuration
      3. Summary
    4. 14 Oracle Advanced Replication on Linux
      1. Introduction to Oracle Replication
        1. Multimaster Replication
        2. Materialized View Replication
        3. Hybrid Replication
      2. Oracle Replication on Linux
        1. I/O Capacity
        2. Database Layout
        3. Sufficient Network Capacity
      3. Summary
    5. 15 Configuring the Hardware for Linux and Oracle
      1. Hardware Tuning Fundamentals
        1. Choosing the Right Hardware
        2. Tuning Hardware for Linux
      2. Network Tuning on Linux
      3. Choosing the Right Network
        1. Tuning Linux for Network Performance
      4. Summary
    6. 16 Tuning SQL
      1. Examining the Execution Plan
        1. Plan Table Review
        2. Viewing the Execution Plan
      2. Understanding the Explain Plan
      3. Understanding the Optimizer Decision Process
        1. A Working Example
        2. Controlling the Optimizer Decisions
        3. SQL Tuning Tips
      4. Summary
    7. 17 Indexes and Partitioning
      1. Introduction to Oracle 10g Indexing Options
      2. Oracle 10g Index Options
        1. The Index Clustering Factor
        2. Oracle 10g Partitioning
        3. Index Partitioning Options
        4. IOT Partitioning Options
        5. Using Partitioned Indexes for Performance
      3. Summary
  12. Part V Oracle Products on Linux
    1. 18 Oracle Application Server 10g on Linux
      1. What Components Make Up Oracle Application Server 10g?
        1. Java 2 Enterprise Edition
        2. Management and Security
        3. Portals
        4. Wireless
        5. Business Intelligence
        6. E-Business Integration
      2. Using Oracle Application Server 10g
      3. Installing and Configuring Oracle Application Server 10g on Linux
        1. Installation
        2. Configuration
      4. Summary
    2. 19 The Oracle E-Business Suite on Linux
      1. Overview of the Oracle E-Business Suite on Linux
        1. What Is the Oracle E-Business Suite?
        2. E-Business Suite Architecture
        3. What Modules Are Available on Linux
        4. Using the Oracle E-Business Suite on Linux
        5. The E-Business Suite in a RAC Environment
      2. Installing and Configuring the E-Business Suite on Linux
        1. Installation
      3. Migrating to the E-Business Suite on Linux
        1. Migrating the Application Tier
        2. Migrating the Database Tier
        3. Converting the Database Tier to RAC
        4. Testing
      4. Summary
  13. Index