Shaw / Dyke Pro Oracle Database 10g RAC on Linux

Installation, Administration, and Performance
1. ed
ISBN: 978-1-4302-0214-1
Verlag: Apress
Format: PDF
Kopierschutz: 1 - PDF Watermark

E-Book, Englisch, 824 Seiten

* Only book on the market to actually show you how to build an Oracle RAC cluster on Linux. * Author expertise & quality: Steve Shaw's Hammerora project is one of the most visited sites in SourceForge.net. Julian Dyke is Chair of UK Oracle User Group RAC SIG and a member of the Oak Table Network. * Based on latest Oracle release (10g R2) which we anticipate being the release where the largest number of customers migrate from existing single instance databases to RAC clusters. * Linux is highest growth sector in relational database market and Oracle has 69% of that market (Gartner).

John Shaw has worked in business processing and integration for over 10 years and has architected some of the largest Microsoft integration projects in the U.S., U.K., and Australia. His technical expertise includes implementing Microsoft BizTalk and messaging standards for a variety of clients in finance, supply chain, and other sectors. Most recently, he founded SphereGen, a niche company that provides a blended model of low-cost onshore and offshore solutions for its clients. Prior to that, John worked as the U.S. BizTalk Practice Lead for Conchango, where he obtained BizTalk Virtual Technical Specialist (VTS) status within Microsoft.

Autoren/Hrsg.

Shaw, John

Dyke, Julian

Inhaltsverzeichnis

1;Contents at a Glance;4
2;Contents;6
3;About the Authors;22
4;About the Technical Reviewers;23
5;Acknowledgments;24
6;Introduction;25
6.1;Coverage and Audience;26
6.2;Standards and Conventions;26
6.3;Errata and Additional Material;26
7;Introduction to RAC;27
7.1;What Is Real Application Clusters?;27
7.2;Clustered Database Concepts;28
7.3;Why Deploy RAC?;33
7.4;Alternatives to RAC;41
7.5;Differences Between Single- Instance and RAC Databases;42
7.6;Differences Between Oracle 9i and Oracle 10g;43
7.7;History of Real Application Clusters;45
7.8;Summary;46
8;Introduction to Linux;47
8.1;History of Linux;47
8.2;Oracle, Open Source, and Linux;51
8.3;Summary;55
9;RAC Concepts;56
9.1;Oracle Clusterware;56
9.2;Node Applications;58
9.3;Database Structure;59
9.4;Instances;61
9.5;Parameters;62
9.6;Background Processes;67
9.7;Workload Management;73
9.8;Administration;75
9.9;Monitoring;76
9.10;Tools and Utilities;78
9.11;Backup and Recovery;80
9.12;Disaster Recovery;80
9.13;Summary;82
10;RAC Design;83
10.1;Business Requirements;83
10.2;Architecture;86
10.3;Storage Requirements;89
10.4;Hardware Requirements;94
10.5;Application Design;94
10.6;Database Design;96
10.7;Summary;105
11;Benchmarking Concepts;106
11.1;Load Testing and Benchmarks;106
11.2;TPC Benchmarks;109
11.3;Summary;121
12;Hardware;122
12.1;Oracle Availability;123
12.2;Server Architecture;124
12.3;Network and Private Interconnect;140
12.4;Summary;147
13;Storage;148
13.1;RAC I/ O Characteristics;148
13.2;Storage Fundamentals;153
13.3;Storage Protocols for Linux;161
13.4;SAN Storage Example;169
13.5;NFS and iSCSI Storage Example;181
13.6;Summary;193
14;Oracle Cluster File System ( OCFS);194
14.1;Cluster File Systems and OCFS;194
14.2;OCFS Version 1;195
14.3;Summary;223
15;Automatic Storage Management ( ASM);224
15.1;Introducing ASM;224
15.2;ASM Installation;225
15.3;ASM Instance Configuration;229
15.4;ASM Components;235
15.5;ASM Administration;243
15.6;Monitoring ASIVI;254
15.7;Summary;256
16;Installing Linux;257
16.1;Linux Software Selection;257
16.2;Hardware Requirements;258
16.3;Networlcing Requirements;258
16.4;Installing Red Hat Enterprise Linux 4 AS;259
16.5;Installing SUSE Linux Enterprise Server;272
16.6;Summary;280
17;Configuring and Verifying Linux;281
17.1;Operating System and RPM Package Checks;281
17.2;Hostnames and Name Resolution;282
17.3;NTP;283
17.4;Hangcheck- Timer;285
17.5;Kernel Parameters;286
17.6;Oracle User Configuration;294
17.7;Secure Shell Configuration;301
17.8;Shared Storage Configuration;303
17.9;Channel Bonding;309
17.10;Cluster Verification;312
17.11;Summary;321
18;Installing and Configuring Oracle Software;322
18.1;Preparing to Install;322
18.2;Oracle Clusterware;324
18.3;Oracle Database Software Installation;336
18.4;Troubleshooting;341
18.5;Configuration Files;344
18.6;Deinstallation;345
18.7;Summary;346
19;Creating and Configuring Databases;347
19.1;Using DBCA As a GUI Tool;347
19.2;Creating a Database Using Scripts;371
19.3;Summary;382
20;Installing and Configuring Enterprise Manager;383
20.1;Manageability Infrastructure;384
20.2;Database Control;385
20.3;Grid Control;386
20.4;Summary;404
21;Linux Administration;405
21.1;Run Levels;405
21.2;Services;407
21.3;Terminal Sessions;408
21.4;IVIanual Pages;408
21.5;Bash Sliell;409
21.6;Packages;413
21.7;Kernel Parameters;414
21.8;Swap Space and File Systems;415
21.9;Booting the System;418
21.10;Log Files, Tracing, and Debugging;419
21.11;Summary;420
22;Oracle Clusterware;421
22.1;Oracle Clusterware Components;421
22.2;Oracle Clusterware Files;422
22.3;Oracle Clusterware High Availability Framework;423
22.4;Oracle Clusterware Installation and Configuration;424
22.5;Administering Oracle Clusterware;428
22.6;Administering Voting Disks;442
22.7;Oracle Clusterware Logging;443
22.8;Summary;443
23;Application Development;444
23.1;RAC- Specific Development Considerations;444
23.2;Transparent Application Fallover;449
23.3;Fast Application Notification;456
23.4;Oracle Clusterware High Availability Framework;465
23.5;Summary;482
24;Using Administrative Tools;483
24.1;Using EM;483
24.2;Using SRVCTL;493
24.3;Using SQL*PIus;505
24.4;Summary;510
25;Workload Management;511
25.1;Workload Distribution;511
25.2;Database Services;515
25.3;Summary;537
26;Adding and Deleting Nodes and Instances;538
26.1;Running GUI Tools;538
26.2;Adding a Node;539
26.3;Adding an Instance;552
26.4;Deleting an Instance;557
26.5;Deleting a Node;561
26.6;Summary;569
27;Trace and Diagnostics;570
27.1;Trace File Locations;570
27.2;ORADEBUG;576
27.3;Summary;591
28;RAC Internals;592
28.1;Global Enqueue Services;593
28.2;Global Cache Services;598
28.3;Instance Recovery;621
28.4;Summary;622
29;Benchmarking Tools: Hammerora and Swingbench;623
29.1;Hammerora;623
29.2;Swingbench;649
29.3;Summary;663
30;Performance Monitoring;664
30.1;Oracle Performance Monitoring;664
30.2;Linux Performance Monitoring;687
30.3;Summary;696
31;Backup and Recovery;697
31.1;Backup and Recovery Strategy;697
31.2;Recovery Manager ( RMAN);699
31.3;RAG Considerations;728
31.4;Summary;730
32;Disaster Recovery;731
32.1;Oracle Data Guard;732
32.2;Data Protection Modes;733
32.3;Redo Transport Services;734
32.4;Standby Redo Logs;736
32.5;Log Apply Services;737
32.6;Role Management;737
32.7;RAC and Physical Standby;738
32.8;RMAN;739
32.9;NOLOGGING Attribute;739
32.10;Archive Log Gaps;740
32.11;Initialization Parameters;740
32.12;Creating a Physical Standby Database;743
32.13;Role Management;753
32.14;Summary;755
33;Third- Party Clustering Solutions;756
33.1;Clusterware;756
33.2;PolyServe Matrix Server;758
33.3;Summary;764
34;Index;765