Oracle 10g RAC Grid, Services and Clustering (eBook)
704 Seiten
Elsevier Science (Verlag)
978-0-08-049203-2 (ISBN)
Oracle 10g RAC focuses on RAC-specific topics including ASM, operating system configuration, installation and configuration of RAC and much more. Coverage includes network configuration for high availability, FAN, TAF, ONS, implementation of maximum availability architecture (MAA), EM Grid Control, AWR, ADDM and other performance-related tools. The author includes several scripts for performance tuning and implementation that the reader can use to configure a RAC environment either on a 2, 4, 8, 60 or 99 node configuration.
* Focuses on implementing, testing and tuning features of Real Application Clusters (RAC) database
version 10g Release 2
* Provides extensive coverage of usage, day-to-day functions and operations
* Includes tips and techniques such as script samples
to illustrate various features of RAC
* A jumpstart into all the key features of 10g R2 RAC
Grid architecture is Oracle's strategy for high-end computing and RAC is the stepping stone into this arena. This book focuses on current technology including all valid RAC features up through Oracle Database 10g Release 2, with a primary focus on deploying it in a high-end grid environment. The book discusses this technology at length which users will find beneficial when researching, implementing or monitoring a RAC environment. The author covers workshop implementation of services and the distribution of workload across instances, with threshold definitions and the new load balancing algorithms. In addition it includes detailed discussions on ASM that complements the implementation of RAC in Oracle Grid strategy. The book also includes discussions on new Oracle Clusterware, its components and its integration with RAC. Oracle 10g RAC focuses on RAC-specific topics including ASM, operating system configuration, installation and configuration of RAC and much more. Coverage includes network configuration for high availability, FAN, TAF, ONS, implementation of maximum availability architecture (MAA), EM Grid Control, AWR, ADDM and other performance-related tools. The author includes several scripts for performance tuning and implementation that the reader can use to configure a RAC environment either on a 2, 4, 8, 60 or 99 node configuration. - Focuses on implementing, testing and tuning features of Real Application Clusters (RAC) database version 10g Release 2- Provides extensive coverage of usage, day-to-day functions and operations- Includes tips and techniques such as script samples to illustrate various features of RAC- A jumpstart into all the key features of 10g R2 RAC
Front Cover 1
Oracle® 10g RAC Grid, Services & Clustering
Copyright Page 5
Table of Contents 8
About the Author 16
About the Technical Contributors 17
About the Technical Reviewers 17
Acknowledgments 20
Preface 24
About This Book 24
How to Use This Book 25
Chapter 1. Oracle Grid 28
1.1 Electric power grid 30
1.2 Computational grids 31
1.3 Evolution 32
1.4 Enterprise grid computing 33
1.5 Globus Toolkit 35
1.6 Oracle grid 35
1.7 Conclusion 40
Chapter 2. Real Application Cluster Architecture 42
2.1 RAC components 42
2.2 Real Application Cluster 57
2.3 Background processes in RAC 59
2.4 Database files in RAC 62
2.5 Maintaining read consistency in RAC 66
2.6 Cache fusion 67
2.7 Global Resource Directory 69
2.8 Mastering of resources 73
2.9 Lock management 76
2.10 Multi-instance transaction behavior 77
2.11 Recovery 92
2.12 Conclusion 95
Chapter 3. Storage Management 96
3.1 Disk fundamentals 97
3.2 Data operations 103
3.3 SAME 103
3.4 Oracle Managed Files 105
3.5 Storage options for RAC 105
3.6 Automatic storage management (ASM) 106
3.7 Migration to ASM 148
3.8 ASM performance monitoring using EM 153
3.9 ASM implementations 154
3.10 ASM instance crash 159
3.11 ASM disk administration 159
3.12 Client connection to an ASM instance 160
3.13 Conclusion 162
Chapter 4. Installation and Configuration 164
4.1 Optimal Flexible Architecture 164
4.2 Selecting the clusterware 167
4.3 Operating system configuration 169
4.4 Network configuration 170
4.5 NIC bonding 174
4.6 Verify interprocess communication buffer sizes 182
4.7 Jumbo frames 184
4.8 Remote access setup 186
4.9 Configuring the kernel 188
4.10 Configuring the hangcheck timer on Linux systems 190
4.11 Configuring and synchronizing the system clock 191
4.12 Installing Oracle 191
4.13 Additional information 235
4.14 Conclusion 235
Chapter 5. Services and Distributed Workload Management 236
5.1 Service framework 236
5.2 Distributed workload management 250
5.3 Fast Application Notification 269
5.4 Conclusion 284
Chapter 6. Failover and Load-Balancing 286
6.1 Failover 288
6.2 Load-balancing 325
6.3 Conclusion 335
Chapter 7. Oracle Clusterware Administration Quick Reference 338
7.1 Node verification using olsnodes 339
7.2 Oracle Control Registry 341
7.3 ONS control (onsctl) utility 355
7.4 EVMD verification 360
7.5 Oracle Clusterware interface 362
7.6 Conclusion 370
Chapter 8. Backup and Recovery 372
8.1 Recovery Manager 374
8.2 RMAN components 374
8.3 Recovery features 377
8.4 Configuring RMAN for RAC 383
8.5 Backup and recovery strategy 388
8.6 Configuring RMAN 390
8.7 Reporting in RMAN 397
8.8 Recovery 400
8.9 Conclusion 407
Chapter 9. Performance Tuning 408
9.1 Methodology 409
9.2 Storage subsystem 416
9.3 Automatic Storage Management 421
9.4 Cluster interconnect 422
9.5 Interconnect transfer rate 424
9.6 SQL*Net tuning 431
9.7 SQL tuning 434
9.8 Sequences and index contention 442
9.9 Undo block considerations 443
9.10 Load-balancing 443
9.11 Resource availability 448
9.12 Response time 450
9.13 Oracle Wait Interface 450
9.14 Server/database statistics 459
9.15 Service-level metrics 462
9.16 Identifying blockers across instances 468
9.17 Identifying hot blocks 469
9.18 Monitoring remastering 470
9.19 Operating system tuning 471
9.20 Automatic workload repository 475
9.21 Automatic Database Diagnostic Monitor 482
9.22 Active session history 485
9.23 EM Grid Control 487
9.24 Conclusion 489
Chapter 10. MAA and More 490
10.1 Data Guard 491
10.2 Oracle Streams 523
10.3 Extended clusters 543
10.4 Conclusion 547
Chapter 11. Best Practices 548
11.1 Planning 549
11.2 Implementation 556
11.3 Database creation 563
11.4 Application deployment 566
11.5 Operations 568
11.6 Conclusion 572
A References 574
B Utilities and Scripts 576
B.1 SRVCTL – Server Control 576
B.2 Cluster ready service (CRS) utility 582
B.3 ORADEBUG - Oracle Debugger 584
B.4 Perl Script 585
B.5 RMAN Scripts 588
C Oracle Clustered File System 590
C.1 OCFS 1.0 590
C.2 OCFS2 596
C.3 Conclusion 606
D TAF and FCF using Java 608
D.1 TAF example using Java 608
E Migration(s) 620
E.1 Oracle 9iR2 to 10gR2 RAC 620
E.2 Data migration from OCFS to ASM 641
E.3 Conclusion 651
F Adding Additional Nodes to an Existing Oracle 10g R2 Cluster on Linux 652
F.1 Current environment 652
F.2 Conclusion 674
Index 676
| Erscheint lt. Verlag | 4.7.2006 |
|---|---|
| Sprache | englisch |
| Themenwelt | Sachbuch/Ratgeber |
| Informatik ► Datenbanken ► Data Warehouse / Data Mining | |
| Informatik ► Datenbanken ► Oracle | |
| Mathematik / Informatik ► Informatik ► Software Entwicklung | |
| ISBN-10 | 0-08-049203-7 / 0080492037 |
| ISBN-13 | 978-0-08-049203-2 / 9780080492032 |
| Haben Sie eine Frage zum Produkt? |
PDF (Adobe DRM)Kopierschutz: Adobe-DRM
Adobe-DRM ist ein Kopierschutz, der das eBook vor Mißbrauch schützen soll. Dabei wird das eBook bereits beim Download auf Ihre persönliche Adobe-ID autorisiert. Lesen können Sie das eBook dann nur auf den Geräten, welche ebenfalls auf Ihre Adobe-ID registriert sind.
Details zum Adobe-DRM
Dateiformat: PDF (Portable Document Format)
Mit einem festen Seitenlayout eignet sich die PDF besonders für Fachbücher mit Spalten, Tabellen und Abbildungen. Eine PDF kann auf fast allen Geräten angezeigt werden, ist aber für kleine Displays (Smartphone, eReader) nur eingeschränkt geeignet.
Systemvoraussetzungen:
PC/Mac: Mit einem PC oder Mac können Sie dieses eBook lesen. Sie benötigen eine
eReader: Dieses eBook kann mit (fast) allen eBook-Readern gelesen werden. Mit dem amazon-Kindle ist es aber nicht kompatibel.
Smartphone/Tablet: Egal ob Apple oder Android, dieses eBook können Sie lesen. Sie benötigen eine
Geräteliste und zusätzliche Hinweise
Buying eBooks from abroad
For tax law reasons we can sell eBooks just within Germany and Switzerland. Regrettably we cannot fulfill eBook-orders from other countries.
aus dem Bereich
