Oracle 10g RAC Grid, Services & Clustering
Regular price
22.750 KD
inc. VAT
Couldn't load pickup availability
Table of contents
- Cover
- Copyright Pageiv
- Table of Contentsvii
- About the Authorxv
- About the Technical Contributorsxvi
- About the Technical Reviewersxvi
- Acknowledgmentsxix
- Prefacexxiii
- About This Bookxxiii
- How to Use This Bookxxiv
- Chapter 1. Oracle Grid1
- 1.1 Electric power grid3
- 1.2 Computational grids4
- 1.3 Evolution5
- 1.4 Enterprise grid computing6
- 1.5 Globus Toolkit8
- 1.6 Oracle grid8
- 1.7 Conclusion13
- Chapter 2. Real Application Cluster Architecture15
- 2.1 RAC components15
- 2.2 Real Application Cluster30
- 2.3 Background processes in RAC32
- 2.4 Database files in RAC35
- 2.5 Maintaining read consistency in RAC39
- 2.6 Cache fusion40
- 2.7 Global Resource Directory42
- 2.8 Mastering of resources46
- 2.9 Lock management49
- 2.10 Multi-instance transaction behavior50
- 2.11 Recovery65
- 2.12 Conclusion68
- Chapter 3. Storage Management69
- 3.1 Disk fundamentals70
- 3.2 Data operations76
- 3.3 SAME76
- 3.4 Oracle Managed Files78
- 3.5 Storage options for RAC78
- 3.6 Automatic storage management (ASM)79
- 3.7 Migration to ASM121
- 3.8 ASM performance monitoring using EM126
- 3.9 ASM implementations127
- 3.10 ASM instance crash132
- 3.11 ASM disk administration132
- 3.12 Client connection to an ASM instance133
- 3.13 Conclusion135
- Chapter 4. Installation and Configuration137
- 4.1 Optimal Flexible Architecture137
- 4.2 Selecting the clusterware140
- 4.3 Operating system configuration142
- 4.4 Network configuration143
- 4.5 NIC bonding147
- 4.6 Verify interprocess communication buffer sizes155
- 4.7 Jumbo frames157
- 4.8 Remote access setup159
- 4.9 Configuring the kernel161
- 4.10 Configuring the hangcheck timer on Linux systems163
- 4.11 Configuring and synchronizing the system clock164
- 4.12 Installing Oracle164
- 4.13 Additional information208
- 4.14 Conclusion208
- Chapter 5. Services and Distributed Workload Management209
- 5.1 Service framework209
- 5.2 Distributed workload management223
- 5.3 Fast Application Notification242
- 5.4 Conclusion257
- Chapter 6. Failover and Load-Balancing259
- 6.1 Failover261
- 6.2 Load-balancing298
- 6.3 Conclusion308
- Chapter 7. Oracle Clusterware Administration Quick Reference311
- 7.1 Node verification using olsnodes312
- 7.2 Oracle Control Registry314
- 7.3 ONS control (onsctl) utility328
- 7.4 EVMD verification333
- 7.5 Oracle Clusterware interface335
- 7.6 Conclusion343
- Chapter 8. Backup and Recovery345
- 8.1 Recovery Manager347
- 8.2 RMAN components347
- 8.3 Recovery features350
- 8.4 Configuring RMAN for RAC356
- 8.5 Backup and recovery strategy361
- 8.6 Configuring RMAN363
- 8.7 Reporting in RMAN370
- 8.8 Recovery373
- 8.9 Conclusion380
- Chapter 9. Performance Tuning381
- 9.1 Methodology382
- 9.2 Storage subsystem389
- 9.3 Automatic Storage Management394
- 9.4 Cluster interconnect395
- 9.5 Interconnect transfer rate397
- 9.6 SQL*Net tuning404
- 9.7 SQL tuning407
- 9.8 Sequences and index contention415
- 9.9 Undo block considerations416
- 9.10 Load-balancing416
- 9.11 Resource availability421
- 9.12 Response time423
- 9.13 Oracle Wait Interface423
- 9.14 Server/database statistics432
- 9.15 Service-level metrics435
- 9.16 Identifying blockers across instances441
- 9.17 Identifying hot blocks442
- 9.18 Monitoring remastering443
- 9.19 Operating system tuning444
- 9.20 Automatic workload repository448
- 9.21 Automatic Database Diagnostic Monitor455
- 9.22 Active session history458
- 9.23 EM Grid Control460
- 9.24 Conclusion462
- Chapter 10. MAA and More463
- 10.1 Data Guard464
- 10.2 Oracle Streams496
- 10.3 Extended clusters516
- 10.4 Conclusion520
- Chapter 11. Best Practices521
- 11.1 Planning522
- 11.2 Implementation529
- 11.3 Database creation536
- 11.4 Application deployment539
- 11.5 Operations541
- 11.6 Conclusion545
- A References547
- B Utilities and Scripts549
- B.1 SRVCTL – Server Control549
- B.2 Cluster ready service (CRS) utility555
- B.3 ORADEBUG - Oracle Debugger557
- B.4 Perl Script558
- B.5 RMAN Scripts561
- C Oracle Clustered File System563
- C.1 OCFS 1.0563
- C.2 OCFS2569
- C.3 Conclusion579
- D TAF and FCF using Java581
- D.1 TAF example using Java581
- E Migration(s)593
- E.1 Oracle 9iR2 to 10gR2 RAC593
- E.2 Data migration from OCFS to ASM614
- E.3 Conclusion624
- F Adding Additional Nodes to an Existing Oracle 10g R2 Cluster on Linux625
- F.1 Current environment625
- F.2 Conclusion647
- Index649
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
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