Oracle Database 10g Linux Administration

Name: Oracle Database 10g Linux Administration
Brand: McGraw-Hill Education
Price: 126.69 EUR
Availability: OnlineOnly

Edward Whalen(Autor*in)

McGraw-Hill Education (Verlag)

1. Auflage

Erschienen am 6. Oktober 2005

445 Seiten

E-Book

ePUB mit Adobe-DRM

Systemvoraussetzungen

978-0-07-150674-8 (ISBN)

126,69 €inkl. 7% MwSt.

Systemvoraussetzungen

für ePUB mit Adobe-DRM

E-Book Einzellizenz

Als Download verfügbar

Beschreibung

Weitere Details

Weitere Ausgaben

Inhalt

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

Systemvoraussetzungen

Als PDF speichern Als Link merken