Oracle 11g R1/R2 Real Application Clusters Essentials
eBook - ePub

Oracle 11g R1/R2 Real Application Clusters Essentials

  1. 552 pages
  2. English
  3. ePUB (mobile friendly)
  4. Available on iOS & Android
eBook - ePub

Oracle 11g R1/R2 Real Application Clusters Essentials

About this book

In Detail

Oracle RAC or Real Application Clusters is a grid computing solution that allows multiple nodes (servers) in a clustered system to mount and open a single database that resides on shared disk storage. Should a single system (node) fail, the database service will still be available on the remaining nodes. Oracle RAC is an integral part of the Oracle database setup. You have one database with multiple users accessing it, in real time. This book will enable DBAs to get their finger on the pulse of the Oracle 11g RAC environment quickly and easily.

This book will cover all areas of the Oracle RAC environment and is indispensable if you are an Oracle DBA who is charged with configuring and implementing Oracle11g R1, with bonus R2 information included. This book presents a complete method for the configuration, installation, and design of Oracle 11g RAC, ultimately enabling rapid administration of Oracle 11g RAC environments.

This practical handbook documents how to administer a complex Oracle 11g RAC environment. Packed with real world examples, expert tips and troubleshooting advice, the book begins by introducing the concept of Oracle RAC and High Availability. It then dives deep into the world of RAC configuration, installation and design, enabling you to support complex RAC environments for real world deployments. Chapters cover Oracle RAC and High Availability, Oracle 11g RAC Architecture, Oracle 11g RAC Installation, Automatic Storage Management, Troubleshooting, Workload Management and much more.

By following the practical examples in this book, you will learn every concept of the RAC environment and how to successfully support complex Oracle 11g R1 and R2 RAC environments for various deployments within real world situations.

This book is the updated release of our previous Oracle 11g R1/R2 Real Application Clusters Handbook. If you already own a copy of that Handbook, there is no need to upgrade to this book.

Approach

This book documents how to administer a complex Oracle 11g RAC environment. It covers new RAC components such as ASM's new features, performance tuning, and troubleshooting. It contains real world examples, expert tips, and troubleshooting advice. This book focuses on Oracle RAC 11g R1 with additional 11g R2 information included.

Who this book is for

If you are an Oracle DBA who wants to administer Real Application Clusters, then this book is for you. Basic understanding of Oracle DBA is required. No experience of Oracle RAC is required.

Trusted by 375,005 students

Access to over 1.5 million titles for a fair monthly price.

Study more efficiently using our study tools.

Information

Publisher
Packt Publishing
Year
2011
Edition
1
eBook ISBN
9781849682664
Topic
Computer Science
Subtopic
Desktop Applications
Index
Computer Science

Oracle 11g R1/R2 Real Application Clusters Essentials

Table of Contents

Oracle 11g R1/R2 Real Application Clusters Essentials
Credits
About the Authors
About the Reviewers
www.PacktPub.com
Support files, eBooks, discount offers and more
Why Subscribe?
Free Access for Packt account holders
Instant Updates on New Packt Books
Preface
What this book covers
What you need for this book
Who this book is for
Conventions
Reader feedback
Customer support
Downloading the example code for this book
Errata
Piracy
Questions
1. High Availability
High availability concepts
Planned versus unplanned downtime
Service Level Agreements for high availability
High availability interpretations
Recovery time and high availability
System design for high availability
Business Continuity and high availability
Disaster Recovery
Business Continuity and Disaster Recovery guidelines
Fault-tolerant systems and high availability
Requirements for implementing fault tolerance
Fault tolerance and replication
High availability solutions for Oracle
Oracle Data Guard
Oracle Streams
Oracle Application Server Clustering
High availability: Oracle 11g R1 Real Application Clusters (RAC)
High availability: Oracle 11g R2 Real Application Clusters (RAC)
Summary
2. Oracle 11g RAC Architecture
Oracle 11g RAC architecture
Certification matrix for Oracle 11g RAC architecture
Hardware architecture for Oracle 11g RAC
Server configurations for Oracle 11g RAC
CPU processors
Choosing between 32-bit and 64-bit CPU architectures
Dual core and multicore processors
Network architecture for Oracle 11g RAC
The private network and the Oracle 11g RAC interconnect
Choices for private interconnect and 11g RAC
Ethernet choices for 11g RAC interconnect
Alternatives to Gigabit Ethernet for the interconnect (Infiniband)
Interconnect choices for 11g RAC—how to decide?
Redundancy for Ethernet interconnects with 11g RAC
Network bonding (NIC teaming)
Storage architecture for Oracle 11g RAC
RAID configurations for Oracle 11g RAC
RAID 0 (striping)
RAID 1 (mirroring)
RAID 5 (striped with parity)
RAID 10 (striped mirrors)
Differences between RAID 10 and RAID 0+1
Third-party RAID implementations
IBM AIX LPAR disk volume management for RAID
Linux volume management for RAID configuration
Storage protocols for RAC
SCSI
Fibre Channel
Point-to-Point (FC-P2P)
Fibre Channel Arbitrated Loop (FC-AL)
Fibre Channel Switched Fabric (FC-SW)
Which Fibre Channel topology is best?
Fibre Channel Ports
Fibre Channel Generic Node Ports
iSCSI
Which storage protocol is best for RAC?
Asynchronous I/O versus Direct I/O for Oracle 11g RAC
Oracle 11g RAC components
Voting Disk
Oracle Cluster Registry
Oracle 11g R1 RAC background processes
ACMS Atomic Controlfile to Memory Service
GTX0-j Global Transaction Process
LMON Global Enqueue Service Monitor
LMD Global Enqueue Service Daemon
LMS Global Cache Service Process
LCK0 Instance Enqueue Process
RMSn Oracle RAC Management Processes
RSMN Remote Slave Monitor
Oracle 11g R2 RAC background processes
Grid Plug and Play
Grid Interprocess Communication
Multicast Domain Name Service
Oracle Grid Naming Service
How RAC differs from Oracle 11g single-instance implementations
New ASM features and RAC
New SYSASM privilege for Oracle 11g R1 ASM
Oracle 11g R2 ASM features
OCR and Voting Disk stored in ASM
Oracle Automatic Storage Management Cluster Filesystem (Oracle ACFS)
New Oracle 11g ASM Disk Group compatibility features
Summary
3. Clusterware Installation
Preparing for a cluster installation
Server (node) requirements
Network requirements
Kernel parameters
Operating system packages
OS groups and users
OS user settings
Configuring Secure Shell (SSH)
Verifying prerequisites with the CLUVFY utility
Oracle 11g R1 Clusterware installation
Initiating Oracle Universal Installer for Oracle 11g R1 Clusterware
What happens when orainstRoot.sh and root.sh is run?
Oracle 11g R1 Clusterware post-installation checks
Installing Oracle 11g R1 RAC software
Initiating Oracle Universal Installer for Oracle 11g R1 RAC software
Post-installation tasks
Oracle 11g R2 Clusterware installation
Initiating Oracle Universal Installer for 11g R2 Clusterware
What happens when the root.sh is run?
Oracle 11g R2 Clusterware post-installation checks
Installing Oracle 11g R2 RAC software
Initiating Oracle Universal Installer for Oracle 11g R2 RAC software
Post-installation tasks
Oracle 11g R2 Clusterware new features highlights
Removing/Reconfiguring a Grid Infrastructure configuration
Removing a successful Grid Infrastructure configuration
Reconfiguring a failed Grid Infrastructure configuration
Summary
4. Automatic Storage Management
Overview of Automatic Storage Management (ASM)
Filesystem versus ASM storage architecture
ASM disk
ASM disk group
ASM instance configuration and management
ASM initialization parameters
Creating an ASM instance
Initializing DBCA
ASM background processes
ASM dynamic views
V$ASM_DISK
V$ASM_DISKGROUP
V$ASM_OPERATION
V$ASM_DISK_STAT
V$ASM_DISKGROUP_STAT
V$ASM_CLIENT
ASM instance startup/shutdown
ASM disk group administration
Creating a disk group
Altering a disk group
Dropping a disk group
Overview of ASMCMD
ASMCMD in action
ASM 11g R1 new features
ASM fast mirror resync
ASM preferred mirror read
ASM fast rebalance
ASM disk group compatibility attributes
ASM performance enhancements
New SYSASM role
ASM 11g R2 new features
Automatic Storage Management Configuration Assistant (ASMCA)
Initiating ASMCA
Configuring a new ASM instance
Managing an ASM instance
Managing an ASM disk group
Creating an ASM disk group
Creating an ASM disk group in silent mode
Automatic Storage Management Dynamic Volume Manager (ADVM)
ADVM volume trivia
Creating ASM volumes
Creating an ASM volume with ASMCA
Creating an ASM Volume with ASMCMD
Creating an ASM volume with the ALTER DISKGROUP SQL statement
Querying V$ASM views to obtain information about ASM volumes
Automatic Storage Management Cluster File System (ACFS)
Using ACFS as Oracle database home
Oracle ACFS drivers
Prerequisites for creating ACFS
ACFS creation methods
Creating an ACFS filesystem using ASMCA
Creating ACFS for Oracle Binaries with ASMCA
Creating an ACFS filesystem with ASMCMD
ACFS mount registry
Managing ACFS
Acfsutil utility
ASM new background processes to support ACFS
Volume Driver Background (VDBG)
Volume Background process (VBGn)
ACFS Background process (ACFS)
Volume Membership Background processes (VMB0)
Querying V$ASM views to obtain information about ACFS
ACFS snap...

Table of contents

  1. Oracle 11g R1/R2 Real Application Clusters Essentials

Frequently asked questions

Yes, you can cancel anytime from the Subscription tab in your account settings on the Perlego website. Your subscription will stay active until the end of your current billing period. Learn how to cancel your subscription
No, books cannot be downloaded as external files, such as PDFs, for use outside of Perlego. However, you can download books within the Perlego app for offline reading on mobile or tablet. Learn how to download books offline
Perlego offers two plans: Essential and Complete
  • Essential is ideal for learners and professionals who enjoy exploring a wide range of subjects. Access the Essential Library with 800,000+ trusted titles and best-sellers across business, personal growth, and the humanities. Includes unlimited reading time and Standard Read Aloud voice.
  • Complete: Perfect for advanced learners and researchers needing full, unrestricted access. Unlock 1.5M+ books across hundreds of subjects, including academic and specialized titles. The Complete Plan also includes advanced features like Premium Read Aloud and Research Assistant.
Both plans are available with monthly, semester, or annual billing cycles.
We are an online textbook subscription service, where you can get access to an entire online library for less than the price of a single book per month. With over 1.5 million books across 990+ topics, we’ve got you covered! Learn about our mission
Look out for the read-aloud symbol on your next book to see if you can listen to it. The read-aloud tool reads text aloud for you, highlighting the text as it is being read. You can pause it, speed it up and slow it down. Learn more about Read Aloud
Yes! You can use the Perlego app on both iOS and Android devices to read anytime, anywhere — even offline. Perfect for commutes or when you’re on the go.
Please note we cannot support devices running on iOS 13 and Android 7 or earlier. Learn more about using the app
Yes, you can access Oracle 11g R1/R2 Real Application Clusters Essentials by Ben Prusinski, Syed Jaffer Hussain in PDF and/or ePUB format, as well as other popular books in Computer Science & Desktop Applications. We have over 1.5 million books available in our catalogue for you to explore.