1 / 26

Oracle 11g R2 RAC: New Features Review & Implementation Guide

Explore the key changes in Oracle 11g R2 RAC with detailed insights on installation, Grid Plug and Play, ASM, GNS, SCAN, SSH connectivity, and IPMI support. Enhance your knowledge for effective deployment.

cmontalvo
Download Presentation

Oracle 11g R2 RAC: New Features Review & Implementation Guide

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. RAC, Grid, Cloudor on the way to Oracle Cloud11GR2 RAC features review By: Ahmed Baraka (Independent) Yury Velikanov(Pythian) & All of you

  2. 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 

  3. Oracle 11g R2 RAC Features Review

  4. The speaker Ahmed Baraka • 8 years working with Oracle (DBA and Developer) • OCP in Oracle DBA 9i, 10g and 11g • www.ahmedbaraka.com

  5. 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

  6. 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.

  7. 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.

  8. 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

  9. 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

  10. 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

  11. 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

  12. 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

  13. 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

  14. Oracle 11g R2 RAC Sample With No GNS or IPMI

  15. 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

  16. Automatic SSH Connectivity

  17. OCR and Voting on ASM storage • OCR and Voting can now be configured on an ASM diskgroup. • Supports up to five copies of OCR

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

  19. 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.

  20. 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.

  21. 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

  22. Hands On Session ...

  23. Hands on ...

  24. 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.

  25. # 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 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

More Related