RAC_ Grid_ Cloud 8-Spe-2010_03

Document Sample
RAC_ Grid_ Cloud 8-Spe-2010_03 Powered By Docstoc
					                       SOM Sponsors:


                                 Ahmed Baraka (Independent)
                                    Yury Velikanov (Pythian)
                                                & All of you
RAC, Grid, Cloud ...
•It isn’t just Real Applications Cluster anymore ...
 - Clusterware Administration and Deployment Guide

•ASM file system and volume manager
 - Storage Administrator's Guide

•Grid Infrastructure
•One node RAC 

                                               SOM Sponsors:
Oracle 11g R2 RAC Features Review

                                    SOM Sponsors:
The speaker

Ahmed Baraka
 - 8 years working with Oracle (DBA and Developer)
 - OCP in Oracle DBA 9i, 10g and 11g

                                        SOM Sponsors:
Main Changes in Oracle 11g R2 RAC
•Oracle RAC One Node
•Grid Plug and Play
•ASM Cluster File System (ACFS)
•Grid Naming Service (GNS)
•Changes on Oracle 11g R2 RAC Installation

                                   SOM Sponsors:
Oracle RAC One Node

 Server A                    Server B                  Server C

      DB1      DB2                         DB3             DB4         DB5

                                 shared storage

A single instance database offering better availability than a standalone
single instance database.
                                                       SOM Sponsors:
Always on single-instance database

  Server A                    Server B                  Server C

       DB1      DB2               DB2        DB3            DB4         DB5

                                   shared storage

 Oracle RAC One Node combines Omotion, shared storage, and a
 clustered infrastructure to provide powerful availability features.
                                                        SOM Sponsors:
Always on single-instance database
• Omotion enables customers to online migrate from
  one generation of servers to another—no downtime
• Online maintenance for both database and OS
• Enhanced Protection from Failures: cold failover (5 to
  30 minutes)
• Better Server Consolidation
• White Paper: Oracle Real Application Clusters One

                                       SOM Sponsors:
Grid Plug and Play
•Reduce cost of adding and removing nodes
•Powered by GNS
•DBCA, NETCA, OME and SRVCTL have been
 updated to support Grid Plug and Play

  srvctl add instance

                                  SOM Sponsors:
ASM Cluster File System (ACFS)
•General purpose files, such as Oracle binaries, can
 now be saved on Oracle ASM volumes
•64-bit file system data structure
•NFS and CIFS compatible
•Journaling file system

                                     SOM Sponsors:
Grid Naming Service (GNS)
•Enables using DHCP, which must be configured in
 the subdomain in which the cluster resides.
•Proivdes self-management of the network
 requirements for the cluster.
•Adds complexity to RAC architecture

                                  SOM Sponsors:
Changes on Oracle 11g R2 RAC
•Oracle Grid Infrastructure: includes ASM
 (Clusterware and ASM Homes)
•OCR and Voting on ASM storage: not supported in
 11g Release 1.
•Automatic SSH Connectivity
•Hangchecktimer Not Needed

                                    SOM Sponsors:
Oracle 11g R2 RAC Installation Plan
•Oracle Grid Infrastructure Install
•Grid Infrastructure Home Patching
•RDBMS Software Install
•RAC Home Patching
•Run ASMCA to create diskgroups
•Run DBCA to create the database

                                      SOM Sponsors:
Oracle 11g R2 RAC Sample

                       SOM Sponsors:
With No GNS or IPMI
Single Client Access Name (SCAN)
•SCAN is a domain name used by all clients
 connecting to the cluster.
•Registered to three IP addresses in DNS or GNS

                                   SOM Sponsors:
Automatic SSH Connectivity

                        SOM Sponsors:
OCR and Voting on ASM storage
•OCR and Voting can now be configured on an ASM
•Supports up to five copies of OCR

                                     SOM Sponsors:
Fixup Scripts
•For an incomplete task that is marked "fixable",
 fixup script can be generated.

                                    SOM Sponsors:
Hangchecktimer Not Needed
•Replaced by the cluster synchronization service
 daemon Agent and Monitor to provide more
 accurate recognition of hangs and to avoid false

                                   SOM Sponsors:
Supporting IPMI
•Supporting Intelligent Platform Management
 Interface (IPMI) is an industry standard
 management protocol that is included with many
 servers today.
•Operates independently of the OS.
•Uses baseboard management controller (BMC) to
 communicate to the server.
•Clusterware uses it when node fencing is required
 and the server it not responding.
                                     SOM Sponsors:
•Oracle 11g Release 2 Changes:
 -   Oracle RAC One Node
 -   ASM Cluster File System (ACFS)
 -   Grid Naming Service (GNS)
 -   SCAN
 -   Automatic SSH Connectivity
 -   Fixup Scripts
 -   OCR and Voting on ASM Storage
 -   Hangchecktimer Not Needed
 -   Supporting IPMI

                                      SOM Sponsors:
Hands On Session ...

                       SOM Sponsors:
Hands on ...

               SOM Sponsors:
SOM Sponsors:
• Cluster Verification Utility (CVU): cluvfy
• Server Control (SRVCTL)
• Oracle Clusterware Control (CRSCTL)
• Oracle Interface Configuration Tool (OIFCFG)
• Oracle Cluster Registry Configuration Tool (OCRCONFIG)
• You can also use the OCRCHECK and OCRDUMP utilities to
  troubleshoot configuration problems that affect OCR.

                                               SOM Sponsors:
• # ps -ef | grep gns
• root 26790 1 2 14:41 ? 00:00:00 /u01/app/11.2.0/grid/bin/gnsd.bin -trace-level 0 -ip-
  address -startup-endpoint ipc://GNS_hostrac01_23867_408c49e351f1f6a8
• root 26825 17210 0 14:41 pts/1 00:00:00 grep gns

• Unfortunately there is no description as of now in the documentation or MOS on how to
  change it to generate invaluable diagnostic information.
• NOTE: I am sure the documentation will be updated in Database 12c version (c for
  Cloud ;)

• For a time being the following should work for you:

• # /u01/app/11.2.0/grid/bin/crsctl modify resource ora.gns -attr "TRACE_LEVEL=6"
• # /u01/app/11.2.0/grid/bin/srvctl stop gns
• # /u01/app/11.2.0/grid/bin/srvctl start gns

                                                             SOM Sponsors:

Shared By: