Transcript SOM Sponsors: RAC, GRID, CLOUD OR ON THE WAY TO ORACLE CLOUD 11GR2 RAC FEATURES REVIEW By: Ahmed Baraka (Independent) Yury Velikanov (Pythian) & All of you.

SOM Sponsors:
RAC, GRID, CLOUD
OR
ON THE WAY TO ORACLE CLOUD
11GR2 RAC FEATURES REVIEW
By:
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
•SCAN, GNS, DHCP, DNS,
•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
- www.ahmedbaraka.com
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
DB1
Server B
DB2
Server C
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
DB1
Server B
DB2
DB2
Server C
DB3
DB4
shared storage
Oracle RAC One Node combines Omotion, shared storage, and a
clustered infrastructure to provide powerful availability features.
SOM Sponsors:
DB5
Always on single-instance database
• Omotion enables customers to online migrate from
one generation of servers to another—no downtime
required
• 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
Node
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
Installation
•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
With No GNS or IPMI
SOM Sponsors:
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
diskgroup.
•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
termination.
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:
Summary
•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:
Tools
• 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 -ipaddress 10.10.193.201 -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: