Atjaunināt sīkdatņu piekrišanu

Expert Oracle RAC 12c 1st ed. [Mīkstie vāki]

4.83/5 (11 ratings by Goodreads)
, , ,
  • Formāts: Paperback / softback, 464 pages, height x width: 254x178 mm, weight: 8578 g, XXII, 464 p., 1 Paperback / softback
  • Izdošanas datums: 19-Aug-2013
  • Izdevniecība: APress
  • ISBN-10: 1430250445
  • ISBN-13: 9781430250449
Citas grāmatas par šo tēmu:
  • Mīkstie vāki
  • Cena: 78,14 €*
  • * ši ir gala cena, t.i., netiek piemērotas nekādas papildus atlaides
  • Standarta cena: 91,94 €
  • Ietaupiet 15%
  • Grāmatu piegādes laiks ir 3-4 nedēļas, ja grāmata ir uz vietas izdevniecības noliktavā. Ja izdevējam nepieciešams publicēt jaunu tirāžu, grāmatas piegāde var aizkavēties.
  • Daudzums:
  • Ielikt grozā
  • Piegādes laiks - 4-6 nedēļas
  • Pievienot vēlmju sarakstam
Expert Oracle RAC 12c 1st ed.Palielināt
  • Formāts: Paperback / softback, 464 pages, height x width: 254x178 mm, weight: 8578 g, XXII, 464 p., 1 Paperback / softback
  • Izdošanas datums: 19-Aug-2013
  • Izdevniecība: APress
  • ISBN-10: 1430250445
  • ISBN-13: 9781430250449
Citas grāmatas par šo tēmu:
Permanent link: https://www.kriso.lv/db/9781430250449.html
Keywords:
Expert Oracle RAC 12c is a hands-on book helping you understand and implement Oracle Real Application Clusters (RAC), and to reduce the total-cost-of-ownership (TCO) of a RAC database. As a seasoned professional, you are probably aware of the importance of understanding the technical details behind the RAC stack. This book provides deep understanding of RAC concepts and implementation details that you can apply toward your day-to-day operational practices. You’ll be guided in troubleshooting and avoiding trouble in your installation. Successful RAC operation hinges upon a fast-performing network interconnect, and this book dedicates a chapter solely to that very important and easily overlooked topic.

All four authors are experienced RAC engineers with a wealth of hard-won experience encountering and surmounting the challenges of running a RAC environment that delivers on its promise. In Expert Oracle RAC 12c they provide you a framework in which to avoid repeating their hard-won lessons. Their goal is for you to manage your own RAC environment with ease and expertise.

  • Provides a deep conceptual understanding of RAC
  • Provides best practices to implement RAC properly and match application workload
  • Enables readers to troubleshoot RAC with ease
About the Authors xvii
About the Technical Reviewers xix
Acknowledgments xxi
Chapter 1 Overview of Oracle RAC
1(28)
High Availability and Scalability
1(1)
What Is High Availability?
2(1)
Database Scalability
3(1)
Oracle RAC
4(1)
Database Clustering Architecture
4(1)
RAC Architecture
5(1)
Hardware Requirements for RAC
6(2)
RAC Components
8(3)
Oracle RAC: Cache Fusion
11(3)
RAC Background Processes
14(2)
Achieving the Benefits of Oracle RAC
16(1)
High Availability Against Unplanned Downtime
16(3)
High Availability Against Planned Downtime
19(2)
Oracle RAC One Node to Achieve HA
21(1)
RAC Scalability
21(2)
Consolidating Database Services with Oracle RAC
23(2)
Considerations for Deploying RAC
25(1)
Cost of Ownership
25(1)
High Availability Considerations
26(1)
Scalability Considerations
26(1)
RAC or Not
27(1)
Summary
28(1)
Chapter 2 Clusterware Stack Management and Troubleshooting
29(40)
Clusterware 12cR1 and Its Components
30(1)
Storage Components of Oracle Clusterware
30(1)
Clusterware Software Stack
31(2)
Clusterware Startup Sequence
33(2)
ASM and Clusterware: Which One is Started First?
35(1)
Clusterware Management
36(1)
Clusterware Management Tools and Utilities
36(1)
Start Up and Stop Clusterware
37(1)
Managing Oracle Clusterware
38(2)
Managing OCR and the Voting Disk
40(2)
Managing CRS Resources
42(1)
Adding and Removing Cluster Nodes
43(2)
Troubleshooting common Clusterware Stack Start-Up Failures
45(4)
Diagnose, Debug, Trace Clusterware and RAC Issues
49(1)
Debugging Clusterware Components and Resources
50(2)
Grid Infrastructure Component Directory Structure
52(3)
Oracle Clusterware Troubleshooting - Tools and Utilities
55(5)
CHM
60(7)
Summary
67(2)
Chapter 3 RAC Operational Practices
69(28)
Workload Management
69(1)
Services
70(1)
Service Metrics
71(2)
Load Balancing Goals
73(2)
Runtime Failover
75(1)
Service in Second Network
75(1)
Guidelines for Services
76(1)
SCAN and SCAN Listeners
76(4)
SCAN Listener in Second Network (12c)
80(1)
Guidelines for SCAN Listeners
81(1)
Global Database Services (12c)
81(1)
Failover in RAC
82(1)
TAF
82(2)
Fast Connection Failover
84(1)
WebLogic Active Gridlink
84(1)
Transaction Guard (12c)
85(1)
Application Continuity (12c)
85(1)
Policy-Managed Databases
86(1)
Temporary Tablespaces
86(2)
Massive Data Changes
88(1)
Performance Metrics Collection
88(1)
Parameter File Management
88(1)
Password File Management
89(1)
Managing Databases and Instances
90(2)
Managing VIPs, Listeners
92(1)
Miscellaneous Topics
93(1)
Process Priority
93(1)
Memory Starvation
94(1)
SGA size
94(1)
Filesystem Caching
94(1)
Summary
95(2)
Chapter 4 New Features in RAC 12c
97(26)
Oracle Flex Clusters
98(1)
Oracle Flex Cluster Architecture
98(1)
Scalability and Availability of Flex Clusters
99(2)
Configuring Flex Clusters
101(4)
Flex ASM Architecture
105(1)
Oracle Flex ASM Architecture
105(2)
Flex ASM and Flex Clusters
107(1)
Configuring Flex ASM
107(2)
ASM Clients and Relocating
109(1)
New ASM Storage Limits
109(1)
Replacing ASM Disk in Disk Group
110(1)
Scrubbing ASM Disk Groups and Files
110(1)
Reading Data Evenly in ASM Disk Group
110(1)
Measure and Tune Rebalance Operation
110(1)
What-If Command Evaluation
111(1)
PDBs on Oracle RAC
112(1)
PDB Architecture Overview
113(3)
PDBs on Oracle RAC
116(3)
12cR1: Miscellaneous New Features for RAC
119(1)
Public Networks for RAC: IPv6 Support Added
120(1)
Global Data Services
120(1)
Online Resource Attribute Modification
120(1)
RAC 12cR1: Policy-Based Management and Administration
120(1)
ASM Disk Group: Shared ASM Password File
120(1)
Valid Node Checking: Restricting Service Registration
120(1)
12cR1: Shared GNS
121(1)
RAC 12cR1: Restricting Service Registration
121(1)
Oracle ASM, ACFS, and ADVM: Improvements and New Features
121(1)
NFS High Availability
121(1)
12cR1: CHM Enhancements?
121(1)
Windows: Support for Oracle Home User
121(1)
OUI: Enhancements and Improvements
121(1)
12cR1: Installations/Upgrades---Running Scripts Automatically
122(1)
12cR1: Introducing Application Continuity
122(1)
Transaction Idempotence and Java Transaction Guard
122(1)
Deprecated and Desupported Features
122(1)
Summary
122(1)
Chapter 5 Storage and ASM Practices
123(42)
Storage Architecture and Configuration for Oracle RAC
124(1)
Storage Architecture and I/O for RAC
125(2)
RAID Configuration
127(2)
Storage Protocols
129(3)
Multipath Device Configuration
132(2)
Set Ownership of the Devices
134(1)
ASM
135(1)
ASM Instance
136(7)
ASM Storage Structure
143(8)
Manage ASM Using SQL Command and V$ASM Views
151(1)
Store OCR and Voting Disk in ASM
151(1)
Choose ASM for OCR and Voting Disk at GI Installation
152(3)
Move OCR and Voting Disk Files to a New ASM Diskgroup
155(2)
ACFS
157(2)
Create ACFS
159(2)
Create ACFS for Oracle RAC Home with ASMCA
161(3)
Summary
164(1)
Chapter 6 Application Design Issues
165(16)
Localized Inserts
165(3)
Excessive Truncate or DROP Statements
168(1)
Sequence Cache
169(3)
Freelists and ASSM
172(1)
Excessive Commits
173(1)
Long Pending Transactions
174(1)
Localized Access
174(1)
Small Table Updates
175(1)
Index Design
176(1)
Inefficient Execution Plan
176(1)
Excessive Parallel Scans
177(1)
Full Table Scans
177(1)
Application Affinity
178(1)
Pipes
178(1)
Application Change Deployment
178(1)
Summary
179(2)
Chapter 7 Managing and Optimizing a Complex RAC Environment
181(36)
Shared vs. Non-Shared Oracle Homes
182(1)
Server Pools
183(1)
Types of Server Pools
184(1)
System-Defined Server Pools
184(1)
User-Defined Server Pools
184(1)
Creating and Managing Server Pools
185(3)
Planning and Designing RAC Databases
188(1)
Policy-Managed Databases
188(3)
Instance Caging
191(2)
Small- vs. Large-Scale Cluster Setups
193(1)
Split-Brain Scenarios and How to Avoid Them
194(2)
Understanding, Debugging, and Preventing Node Evictions
196(1)
Node Evictions---Synopsis and Overview
196(3)
Extended Distance (Stretch) Clusters---Synopsis, Overview, and Best Practices
199(1)
Extended Distance (Stretch) Clusters: Setup/Configuration Best Practices
200(1)
Setup and Configuration---Learning the New Way of Things
201(1)
OUI
201(3)
Oracle Enterprise Manager Cloud Control 12c
204(2)
RAC Installation and Setup---Considerations and Tips for OS Families: Linux, Solaris, and Windows
206(2)
RAC Database Performance Tuning: A Quick `n' Easy Approach
208(1)
The 3 A's of Performance Tuning
208(7)
Summary
215(2)
Chapter 8 Backup and Recovery in RAC
217(26)
RMAN Synopsis
217(1)
Media Management Layer
218(1)
Online Backup and Recovery Prerequisites
219(2)
Non-RAC vs. RAC Database
221(1)
Shared Location for Redo and Archive Logs
221(1)
Snapshot Control File Configuration
222(1)
Multiple Channels Configuration for RAC
223(3)
Parallelism in RAC
226(1)
Instance/Crash Recovery in RAC
226(4)
Real-World Examples
230(3)
Manage RMAN with OEM Cloud Control 12c
233(6)
OCR recovery
239(2)
Summary
241(2)
Chapter 9 Network Practices
243(42)
Types of Network
243(1)
Network Layers
244(2)
Protocols
246(4)
VIPS
250(1)
Subnetting
250(2)
Cluster Interconnect
252(2)
Jumbo Frames
254(5)
Load Balancing and Failover
259(2)
Kernel Parameters
261(1)
Network Measurement Tools
262(4)
GC Lost Block Issue
266(2)
Configuring Network for Oracle RAC and Clusterware
268(3)
Establishing IP Address and Name Resolution
271(3)
Network Specification in Grid Infrastructure Installation
274(3)
Network Configuration in Clusterware
277(6)
Network Failover
283(1)
Second Network
284(1)
Summary
284(1)
Chapter 10 RAC Database Optimization
285(36)
Introduction to Cache Fusion
285(1)
Cache Fusion Processing
286(2)
GRD
288(1)
BL Resources and Locks
288(4)
Performance Analysis
292(1)
Analysis of the Receiving Side
292(7)
RAC Wait Events
299(1)
GC Current Block 2-Way/3-Way
299(2)
GC CR Block 2-Way/3-Way
301(1)
GC CR Grant 2-Way/GC Current Grant 2-Way
302(1)
GC CR Block Busy/GC Current Block Busy
302(1)
GC CR Block Congested/GC Current Block Congested
302(1)
Placeholder Wait Events
303(1)
Sending-Side Analysis
303(3)
Block Types Served
306(1)
GCS Log Flush Sync
307(1)
Defending LMS Process
308(1)
GC Buffer Busy Acquire/Release
308(2)
Unique Indexes
310(1)
Table Blocks
311(2)
DRM
313(1)
Overview of DRM Processing
314(2)
DRM Stages
316(1)
GRD Freeze
316(1)
Parameters
317(1)
Changes in 12c
317(1)
DRM and Undo
317(1)
Troubleshooting DRM
318(1)
AWR Reports and ADDM
318(1)
ASH Reports
319(1)
Summary
320(1)
Chapter 11 Locks and Deadlocks
321(32)
Resources and Locks
321(2)
SGA Memory Allocation
323(2)
Resource Types
325(2)
Lock Modes
327(1)
Lock-Related Views
327(1)
Pluggable Databases (12c)
328(1)
Troubleshooting Locking Contention
328(3)
Enqueue Contention
331(1)
TX Enqueue Contention
331(3)
TM Enqueue Contention
334(1)
HW Enqueue Contention
335(1)
DFS Lock Handle
336(1)
SV Resources
337(3)
CI Resources
340(2)
DFS Lock Handle Summary
342(1)
Library Cache Locks/Pins
342(2)
Troubleshooting Library Cache Lock Contention
344(2)
Enqueue Statistics
346(1)
v$wait_chains
346(1)
Hanganalyze
347(1)
Deadlocks
348(1)
LMD Trace File Analysis
349(3)
Summary
352(1)
Chapter 12 Parallel Query in RAC
353(28)
Overview
353(4)
PX Execution in RAC
357(1)
Placement of PX Servers
358(3)
Measuring PX Traffic
361(2)
PX and Cache Fusion
363(1)
PEMS
364(1)
Parallelism Features and RAC
364(11)
Debugging PX Execution
375(1)
Index Creation in RAC
376(1)
Parallel DML in RAC
377(1)
Concurrent Union Processing (12c)
378(1)
Partition-Wise Join
379(1)
Summary
380(1)
Chapter 13 Clusterware and Database Upgrades
381(30)
Configuration
381(2)
Pre-Upgrade Checklist
383(2)
Initiating an Oracle Clusterware Upgrade
385(11)
The Importance of the Rootupgrade.sh Script
396(2)
Post-Upgrade Tasks
398(1)
Clusterware Downgrade
399(3)
Database Upgrade
402(1)
Deploying Manual Database Upgrade
403(2)
Post-Database Upgrade Steps
405(1)
Database Upgrade Using the DBUA
406(3)
DBUA Advantages
409(1)
Database Downgrade
409(1)
Summary
410(1)
Chapter 14 RAC One Node
411(20)
The Big Picture
411(1)
Upgrading to 11.2.0.2 or Higher
412(1)
Deploying RAC One Node Binaries
412(3)
Deploying a RAC One Node Database
415(1)
Satisfying Prerequisites
415(1)
Initiating DBCA's Creation Process
416(2)
Parameters Specific to RAC One Node
418(1)
Managing RAC One Node Database
419(1)
Verifying Configuration Details
419(1)
Verifying the Online Relocation Status
420(1)
Stop and Start the Database
420(1)
Performing Online Database Relocation
420(3)
Handling Unplanned Node and Cluster Reboots
423(1)
Converting Between RAC One Node and Standard RAC
423(1)
Scaling Up to Standard RAC
424(1)
Scaling Down to RAC One Node
425(1)
Managing RAC One Node with Cloud Control 12c
425(1)
Database Relocation with Cloud Control 12c
425(3)
Third-Party Cold Failover vs. RAC One Node
428(1)
Summary
429(2)
Index 431
Riyaj Shamsudeen is an industry-recognized RAC expert and performance tuning specialist with 19+ years of experience in implementing, using, and tuning RAC and Oracle products. He is an Oracle ACE Director and proud member of the OakTable network. Riyaj has co-authored many books about Oracle Database. He is an active blogger (at http://orainternals.wordpress.com) and frequent international speaker in major conferences such as UKOUG, HOTSOS, Open World, and RMOUG.