Scribd Logo
Upload

Welcome to Scribd!

  • 26 views

    Slides RAC Tier0info Jan06

    Uploaded by

    info
    This document discusses using Oracle 10g RAC for a physics database. It outlines the main architectural components of Oracle 10g RAC including Oracle RAC, ASM, and networking. It then describes the installation process and provides examples of ASM configurations. Useful tools for performance testing, utilities, and the cluster verification utility are also mentioned.

    Copyright:

    © All Rights Reserved
    Download as PPT, PDF, TXT or read online from Scribd

    Slides RAC Tier0info Jan06

    Uploaded by

    info
    26 views11 pages
    This document discusses using Oracle 10g RAC for a physics database. It outlines the main architectural components of Oracle 10g RAC including Oracle RAC, ASM, and networking. It then describes the installation process and provides examples of ASM configurations. Useful tools for performance testing, utilities, and the cluster verification utility are also mentioned.

    Original Description:

    slides_RAC_tier0info_Jan06

    Original Title

    slides_RAC_tier0info_Jan06

    Copyright

    © © All Rights Reserved

    Available Formats

    PPT, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    This document discusses using Oracle 10g RAC for a physics database. It outlines the main architectural components of Oracle 10g RAC including Oracle RAC, ASM, and networking. It then describes the installation process and provides examples of ASM configurations. Useful tools for performance testing, utilities, and the cluster verification utility are also mentioned.

    Copyright:

    © All Rights Reserved
    Download as PPT, PDF, TXT or read online from Scribd
    Download as ppt, pdf, or txt
    26 views11 pages

    Slides RAC Tier0info Jan06

    Uploaded by

    info
    This document discusses using Oracle 10g RAC for a physics database. It outlines the main architectural components of Oracle 10g RAC including Oracle RAC, ASM, and networking. It then describes the installation process and provides examples of ASM configurations. Useful tools for performance testing, utilities, and the cluster verification utility are also mentioned.

    Copyright:

    © All Rights Reserved
    Download as PPT, PDF, TXT or read online from Scribd
    Download as ppt, pdf, or txt
    You are on page 1of 11

    Scalable Oracle 10g for the

    Physics Database Services

    Luca Canali, CERN IT


    January, 2006
    Outline

    • Oracle 10g RAC main architectural


    components
    • Installation overview
    • ASM examples
    • Utilities and Benchmark Tools
    • Q/A

    3D Meeting, January 2006 L.Canali, CERN 2


    Scalable Oracle Architecture
    Goal: A database infrastructure that provides the required system
    resources to the end-users and applications.
    How: A modular architecture that can scale up to a large number of
    components

    3D Meeting, January 2006 L.Canali, CERN 3


    Architectural Elements

    • Oracle RAC for HA and Performance


    – Multiple nodes
    – Services to balance and segment workload
    – Clients configured with TAF
    • Low cost scalable storage
    – SAN infrastructure
    – Oracle’s ASM (volume manager and RAID)
    • Network infrastructure
    – Cluster interconnects
    – Public network
    3D Meeting, January 2006 L.Canali, CERN 4
    Deployment Elements
    • Linux
    – Oracle certified Linux distribution RHEL 3 or 4
    – Processor architecture
    • At CERN so far 32 bit and Intel Xeon
    • Planned: 64 bit architectures
    • Monitoring and Manageability
    – EM for monitoring
    – Additional custom scripting/alerts
    – Backups with RMAN
    • to tape
    • to disk (flash backups)
    3D Meeting, January 2006 L.Canali, CERN 5
    Pre-Installation
    • SAN configuration
    – Attach storage arrays to the Linux servers (SAN network)
    – Configure the HBA drivers (possibly using multipathing)
    • Configure TCP/IP networks
    – Cluster interconnects
    – Public networks (possibly using teaming)
    • Setup ssh equivalence (logon without pass) for the cluster
    nodes
    • Create the necessary disk partitions
    • Setup raw devices
    – For RHEL 3 use devlabel to map rawdevices to obtain persistency
    • Setup asmlib to map disk partitions for ASM
    • Check OS prerequisites on Oracle’s installation guide
    (kernel parameters, etc)

    3D Meeting, January 2006 L.Canali, CERN 6


    Installation
    • Install CRS
    • Install RDBMS
    • Install latest Patchset
    • Install‘CPU’ (latest security update)
    • Install EM agents
    • Setup ASM (dbca can do it, but double
    check the results)
    – ASM instances
    – ASM diskgroups
    • Create DB
    3D Meeting, January 2006 L.Canali, CERN 7
    Useful Tools
    • Performance tools:
    – IO tests: ORION from otn.oracle.com
    – Hammerora (hammerora.sourceforge.net)
    – Bytemark (nbench port by U. Mayer )
    • Oracle RAC on VMWARE from
    OTN.oracle.com
    • Utilities and time savers
    – pconsole: allows to send keyboard input to
    multiple cluster nodes shell.
    – rlwrap: command history to sqlplus for Linux
    – Oracle’s CVU (cluster verification utility)
    3D Meeting, January 2006 L.Canali, CERN 8
    ASM’s Configuration – Examples 1
    • ASM is a volume manager, its output are disk groups (DG) that
    Oracle databases can mount to allocate their files

    DATA-DG RECOVERY-DG

    Config 1: Disk groups created Config 2: Disk groups created


    with dedicated disks by ‘horizontal’ slicing

    3D Meeting, January 2006 L.Canali, CERN 9


    ASM Configuration –Examples 2
    • ‘Coupled-RACs’ storage configuration:
    – High availability - Allows backups to disk
    – High performance - Allows clusterware mirroring (10.2)
    – DBs have dedicated resources

    DB N.1 DB N.2
    Oracle RAC
    Nodes

    Data DG-1 Recovery DG-2 Data DG-2 Recovery DG-1 Disk Groups
    (ASM)

    Storage
    Arrays

    3D Meeting, January 2006 L.Canali, CERN 10


    Conclusions

    • See also our wiki page


    – https://uimon.cern.ch/twiki/bin/view/PSSGroup/DbaArea
    • Installation procedures
    • Post install actions

    • Q/A

    3D Meeting, January 2006 L.Canali, CERN 11

    You might also like