1 / 11

Scalable Oracle 10g for the Physics Database Services

This resource outlines Oracle 10g RAC's main architectural components, installation overview, ASM examples, utilities, and benchmark tools.

blanks
Download Presentation

Scalable Oracle 10g for the Physics Database Services

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. Scalable Oracle 10g for the Physics Database Services Luca Canali, CERN IT January, 2006

  2. Outline • Oracle 10g RAC main architectural components • Installation overview • ASM examples • Utilities and Benchmark Tools • Q/A L.Canali, CERN

  3. 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 L.Canali, CERN

  4. 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 L.Canali, CERN

  5. 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) L.Canali, CERN

  6. 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) L.Canali, CERN

  7. 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 L.Canali, CERN

  8. 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) L.Canali, CERN

  9. ASM’s Configuration – Examples 1 DATA-DG RECOVERY-DG • ASM is a volume manager, its output are disk groups (DG) that Oracle databases can mount to allocate their files Config 1: Disk groups createdwith dedicated disks Config 2: Disk groups createdby ‘horizontal’ slicing L.Canali, CERN

  10. ASM Configuration –Examples 2 Data DG-2 Data DG-1 Recovery DG-1 Recovery DG-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 Disk Groups (ASM) Storage Arrays L.Canali, CERN

  11. Conclusions • See also our wiki page • https://uimon.cern.ch/twiki/bin/view/PSSGroup/DbaArea • Installation procedures • Post install actions • Q/A L.Canali, CERN

More Related