The Thefollowing followingisisintended intendedtotooutline outlineour ourgeneral general product productdirection. direction.ItItisisintended intendedfor forinformation information purposes purposesonly, only,and andmay maynot notbe beincorporated incorporatedinto into any anycontract. contract.ItItisisnot notaacommitment commitmenttotodeliver deliver any anymaterial, material,code, code,or orfunctionality, functionality,and andshould should not notbe berelied reliedupon uponininmaking makingpurchasing purchasing decisions. decisions. The Thedevelopment, development,release, release,and andtiming timingofofany any features featuresor orfunctionality functionalitydescribed describedfor forOracle’s Oracle’s products productsremains remainsatatthe thesole solediscretion discretionofof Oracle. Oracle. 1 | © 2011 Oracle Corporation – Proprietary and Confidential © 2011 Oracle Corporation <Insert Picture Here> Oracle Database Appliance Gian Luigi Cavalli PreVendita Oracle Growing Business Critical Services and Data High Availability solutions desiderable, but not easily deployed Complex and Costly Specific Skills Required 3 | © 2011 Oracle Corporation – Proprietary and Confidential High Risk of Failure Value Proposition Simple High Availability Database • Easy to Implement – One Box: server, storage, networking – One Button Install of SW • Easy to manage & maintain – One button patching – Self-managing storage – Auto-detects and auto-corrects • Easy to diagnose and support – Automated Service Request filing (phone home) – Relevant logs gathered and packaged for support 4 | © 2011 Oracle Corporation – Proprietary and Confidential Highly Available Database Appliance • Simple, quick, complete, affordable HA Cluster Database System in a single enclosure • Plug-n-Go – Plug the power – Plug the network – Name the system • Key Features – Triple-mirrored storage with Oracle Automatic Storage Manager – Hot serviceable customer replaceable components – Redundant Power, Server Nodes, Cooling, Networking… – Oracle Real Application Cluster – Oracle Appliance Manger • Oracle Database Appliance also known as – ODA 5 | © 2011 Oracle Corporation – Proprietary and Confidential Engineered Systems for Oracle Database Oracle Red Stack Full Rack Half Rack Quarter Rack Oracle Database Appliance 6 | © 2011 Oracle Corporation – Proprietary and Confidential Oracle Exadata Database Machine Oracle Database Appliance Ideal for SMBs and Departmental Systems • Simple to implement • Designed and priced to scale • Performance improves as you scale • Highest levels of serviceability • Highest availability for this class of machine 7 | © 2011 Oracle Corporation – Proprietary and Confidential © 2011 Oracle Corporation <Insert Picture Here> Oracle Database Appliance Hardware 8 | © 2011 Oracle Corporation – Proprietary and Confidential Oracle RAC architecture in ODA RAC-in-a-box Node 0 Node 1 Interconnect Shared Storage 9 | © 2011 Oracle Corporation – Proprietary and Confidential Low Entry Cost To High Availability Low cost, no complexity, high availability DB Server DB Server HP Externa l Networ k Redundant SAS or FC HBA’s • • • • Storage HA-Controller + DiskArray 24 processor cores Manual configuration & installation Multiple-vendor support contracts Minimum 12 processor core licenses 10 | © 2011 Oracle Corporation – Proprietary and Confidential Installation Expertise Optimization Expertise Network Administration Savings Storage Administration System Administration Database Administration Oracle Appliance Manager • 24 processor cores • One-button configuration & installation • Single-vendor support contract • Minimum 2 processor core licenses Chassis • 4U Redundant Storage Server • 2 Server Nodes (SN) – Two internal boot disks per SN • 24 3.5” dual ported SAS/SATA/SSD disk slots – 20x 600GB 15K RPM SAS (slots 0-19) (Triple-mirrored:12 TB RAW, 4 TB Usable) – 4x 73GB STEC GEN3 SSD (slots 20-23) for redo logs (Triple-mirrored) FRONT VIEW REAR VIEW • 2 Hot-swap redundant power • Redundant 5V and 12V disk backplane power • Independent power, locate buttons and status per SN • Fixed configuration • One order number for the hardware + another for the power cord • Plus SFP+ Transceivers and/or cables when using 10GbE 11 | © 2011 Oracle Corporation – Proprietary and Confidential Chassis - Rear View SN1 SN0 12 | © 2011 Oracle Corporation – Proprietary and Confidential Server Node Hardware Architecture Hardware Elements Features Description Compute • • 2 Server Nodes On each Server Node • 2x 6-Core Intel Xeon 5675 3.06GHz 95Watt CPUs • 2-12 CPU cores per SN enabled on demand • 12MB L3 cache per socket • 3x full-width bi-directional Intel QuickPath Interconnects per socket • Upto 25.6GB/s per QPI Ports • 96 GB RAM (12 x DDR3-1333 8GB DIMMs) • 3x Channel per socket and 2x DIMMs per channel I/O • • • • • 4x 73GB SAS2 SSDs 20x 600GB SAS2 15K RPM Disks (12 TB Raw) 2x 500GB SATA boot disks (rear accessed) per Server Node 3x PCIe Gen2 8-lanes slots per Server Node 2x LSI SAS PCIe Erie HBA per Server Node Network • Dual GigE as the Cluster Interconnect (within chassis for SN to SN connectivity) 2 x on-board GigE per Server Node 1 x Quad GigE (Intel Northstar) per Server Node (2^ PCIe slot) 1 x 10GigE Dual-ports (Intel Niantic) per Server Node (3^ PCIe slot) • • • 13 | © 2011 Oracle Corporation – Proprietary and Confidential © 2011 Oracle Corporation Server Node View OS Boot Disk Interna l HBA Interna l USB CPU1 CPU0 PCI Riser 14 | © 2011 Oracle Corporation – Proprietary and Confidential SAS, Chassis, FIM, +5V disk, PSU Signals Network port bonding 15 | © 2011 Oracle Corporation – Proprietary and Confidential Architectural Overview • Each Node – plugs into the chassis – operates independent of the other – has full access to the 24 front mounted disks – contains a dual port Ethernet controller internally connected • eliminates the need for external cables • Failure on one Node will not result in a service interruption on the other Node • Any service requests on a failed Node are maintained through the surviving Node 16 | © 2011 Oracle Corporation – Proprietary and Confidential Four possible Backup Strategies • • • • Back up to a Flash Recovery Area (FRA) on disk Back up to a file system such as NAS (RMAN) Back up to tape (OSB: Oracle Secure BackUp; 3 rd BU SW) Remote replication using Data Guard (Disaster Recovery) Immediate restore if still on disk, Gb/s or 10Gb/s fast restore from tape ODA Backup to disk or tape Media server Oracle StorageTek Disk: ZFSSA Oracle StorageTek Tape library 17 | © 2011 Oracle Corporation – Proprietary and Confidential - RMAN backup sets on external Third-party media server - DRP if in other location - Long-term data protection on tape Supported Third Party Agents for the ODA Company Backup Application Version RMAN Client Media Server OS Symantec Netbackup 7.1 New 7.1 Client OEL 5.7 release, all Oracle or 5.7 3rdCommVault• Beginning Simpanaimmediately 9 SP3 softwareiDA for Oracle OEL party software agents, includingDatabases management, monitoring, Linux and authorization agents, will be supported on ODA EMC Networker "SP2" Networker OELwill 5.7 • We will no longer 7.6.2 maintain a white list of agents that Module for be supported Databases and • Customers may load any software agent, or write and Application deploy their own agents (NMDA) V1.1 IBM • Oracle Tivoliwill provide6.3 patches for Oracle Data Protection software and OEL Linux 5.7 StorageAgents that ship as part for of Oracle 6.3 Linux libraries. the Oracle Manager will be automatically patched as part of our distribution appliance patching process Data A.06.20 A.06.20 Client OEL 5.5 Protector HP 18 | © 2011 Oracle Corporation – Proprietary and Confidential Deployment Overview Build System Connect System to Network & Power ON Deploy Grid, DB with best Practices Image Firmware Install OS Download SW from MOS Provide Basic info to Configurator Initiate Health Check Fully Configured Database 19 | © 2011 Oracle Corporation – Proprietary and Confidential Three Tiers of Availability 20 | © 2011 Oracle Corporation – Proprietary and Confidential © 2011 Oracle Corporation ‘Pay-as-you-Grow’ Database Licensing • • • • • Purchase single hardware configuration Start with minimum of 2 processor core licenses Scale to maximum of 24 processor core licenses No hardware upgrades required License database software just for the cores you use 21 | © 2011 Oracle Corporation – Proprietary and Confidential © 2011 Oracle Corporation ‘Pay-as-you-Grow’ Database Licensing Oracle Database Appliance Server Node 1 Server Node 2 • 4 cores must be activated at a time Server Node 1 Server Node 2 • Customer can license only 2 cores for EE or RAC One Node 22 | © 2011 Oracle Corporation – Proprietary and Confidential © 2011 Oracle Corporation - Activated - Licensed ‘Pay-as-you-Grow’ Database Licensing Oracle Database Appliance: Enterprise Edition SingleInstance/RacOneNode • 2 Cores activated • 1x Processor License EE: 37 K oppure 25 NamedUser EE: 18.5 K • 1x RacOneNode: 8K • 1x Advanced Compression: 9K • 1x Partitioning: 9K • 1x Diagnostic&Tuning: 8K Server Node 1 Costo del SW a Listino: Costo dell’HW a Listino: • TOT EE NU: 18.5K • TOT EE: 37K • TOT EE+RacOne: 45K • ODA+SisOp+Mngt: 39K Manut: 22% Anno Server Node 2 • Customer can license 2 cores for EE or RAC One Node 23 | © 2011 Oracle Corporation – Proprietary and Confidential © 2011 Oracle Corporation Manut: 12% Anno - Activated - Licensed ‘Pay-as-you-Grow’ Database Licensing Oracle Database Appliance: Enterprise Edition RAC • 4 Cores activated • 2x Processor License EE: 74K oppure 50 Named User EE: 37K • 2x RAC: 36K oppure 50 RAC NamedUser: 18K • 2x Advanced Compression: 18K • 2x Partitioning: 18K • 2x Diagnostic&Tuning: 16K Server Node 1 Costo del SW a Listino: Costo dell’HW a Listino: • TOT EENU +RACNU = 56K • TOT EE+RAC: 110 K • TOT EE+RAC+OPT: 162K • ODA+SisOp+Mngt: 39K Manut: 22% Anno Server Node 2 • Customer can license 4 cores for EE or RAC 24 | © 2011 Oracle Corporation – Proprietary and Confidential © 2011 Oracle Corporation Manut: 12% Anno - Activated - Licensed <Insert Picture Here> Oracle Database Appliance Software 25 | © 2011 Oracle Corporation – Proprietary and Confidential Oracle Database Appliance Full Oracle Stack • Oracle Linux 5.5 • Choice of Oracle Database EE, RAC, or RAC One Node (11.2.0.2) and other options • Oracle Grid Infrastructure 11g Release 2 (11.2.0.2) – Oracle Clusterware – Oracle Automatic Storage Management • Oracle Enterprise Manager Database Control • Oracle Automatic Service Requests (Phone home) • Oracle Appliance Manager 26 | © 2011 Oracle Corporation – Proprietary and Confidential Oracle Clusterware • Allows clustering of independent servers so that they cooperate as a single system – Presented as one server to applications and end users • Capable of protecting any kind of application in a failover cluster – Increased HA • Fully integrated with Oracle RAC 27 | © 2011 Oracle Corporation – Proprietary and Confidential Oracle Automatic Storage Management • Volume manager and file system for Oracle database – Single-Instance Oracle Database – Oracle RAC configurations • Uses disk groups to store datafiles – ASM presents a file system for Oracle database files • Provides flexible server-based mirroring options – Enables two-way and three-way mirroring for increased HA – Can replace failed or pre-failed drives without affecting operation of file system • Improves I/O performance 28 | – Consolidates data storage into small number of disk groups – Provides dynamic rebalancing ensuring every file is evenly spread across all the disks in a disk group © 2011 Oracle Corporation – Proprietary and Confidential Oracle Enterprise Manager Database Control • Provides interface to perform database administrative tasks – – – – Creating schema objects (tablespaces, tables, indexes) Managing user security Backing up and recovery of the databases Importing and exporting of data • Provides performance and status information about databases 29 | © 2011 Oracle Corporation – Proprietary and Confidential Automatic Service Request (ASR) • Optional offering for enhanced support experience • Automatically opens service requests with Oracle for specific hardware faults – Service requests filed electronically and securely – Fast and accurate resolution of the hardware faults – Improved availability, less downtime • Can be integrated with existing monitoring tools – ASR manager can send SR notifications via SNMP traps to existing monitoring tools 30 | © 2011 Oracle Corporation – Proprietary and Confidential Oracle Appliance Manager • Provides One Button functionality to easily install, manage, maintain & validate the system. • Performs discovery of the storage subsystem. • Monitors disks for hard & soft failures. • Recovers ASM disk groups on shared disk failure. • Automates procedures after remove/replace disks 31 | © 2011 Oracle Corporation – Proprietary and Confidential Oracle Appliance Manager • • • • • Configurator Module Deployment Module Storage Management Module Patching Module Validation & Diagnostic Tools Module 32 | © 2011 Oracle Corporation – Proprietary and Confidential Oracle Appliance Manager Configurator • Hides the complexity of setting up the cluster • GUI-based enquiry collects configuration information - Cluster name Domain Networking information Database size • Validates gathered information • Configures OS & Networks • Deploys the Grid Infrastructure & Database 33 | © 2011 Oracle Corporation – Proprietary and Confidential Oracle Appliance Manager Configurator Setup the customized System Name Select from three Database Deployment Configurations: RAC, RAC One Node, or Single Instance 34 | © 2011 Oracle Corporation – Proprietary and Confidential Oracle Appliance Manager Configurator VIP Name & IP information automatically generated & filled for both nodes SCAN name is auto generated 35 | © 2011 Oracle Corporation – Proprietary and Confidential Node and IP information for 2nd Node is automatically generated & filled Oracle Appliance Manager Configurator Setup the customized Database Name Select the Database Class type 36 | © 2011 Oracle Corporation – Proprietary and Confidential Oracle Appliance Manager Deployment Module • Oracle Database Class Options - Very Small 200 Processes, 16 MB log buffer, SGA: 4096-8192 MB, PGA: 2048-4096 MB. 1 GB redo log file - Small 400 Processes, 16 MB log buffer, SGA: 8192-16384 MB, PGA: 4096-8192 MB, 1 GB redo log file - Medium 800 Processes, 32 MB log buffer, SGA:16384-24576 MB, PGA: 8192-12288 MB, 2 GB redo log file - Large 1200 Processes, 64 MB log buffer, SGA: 24576-49152 MB, PGA: 12288-24576 MB, 4 GB redo log file - Very Large 2400 Processes, 64 MB log buffer, SGA:49152 MB, PGA: 24576 MB, 4 GB redo log file SGA= System Global Area, PGA= Program Global Area 37 | © 2011 Oracle Corporation – Proprietary and Confidential Oracle Appliance Manager Deployment Module • Deploys OS, Oracle Appliance Manager, Grid Infrastructure & Database • Configures GI & RDBMS (Oracle Database) • Ensures correct configuration of disks & networks • Consistent implementation of known Best Practices • Configures optimal disk layout for ASM • Performs initial configuration of disks & ASM DG(s) 38 | © 2011 Oracle Corporation – Proprietary and Confidential Oracle Appliance Manager Storage Management Module • Oracle Appliance Manager Daemon (oakd) is started during boot • Discovers storage subsystem • Tracks configuration by storing metadata • Monitors status of disks • Generates alerts on failures • Takes corrective action on appropriate events • Interacts with ASM for complete automation 39 | © 2011 Oracle Corporation – Proprietary and Confidential Oracle Appliance Manager Patching Module • Patching Module provides tools to patch OS, Oracle Application Manager Modules, Grid Infrastructure(GI), RDBMS • Provides a single interface and command to patch all the components including OS, firmware, BIOS , GI and RDBMS • Patching Module will update the repository to reflect the newly installed patches and firmware's • Bundle Patches for all components that is to be patched. 40 | © 2011 Oracle Corporation – Proprietary and Confidential Oracle Appliance Manager Validation & Diagnostic Tools Module • A set of tools for validation & diagnostics • Validation tool provides detailed information about the components – both HW & SW • Diagget tool collects all the diagnostics information and can be used when experiencing problems. • Healthcheck can be used to check the health of OS, DB, Clusterware and other Oracle Database Appliance components to ensure they are healthy and functionally optimally. 41 | © 2011 Oracle Corporation – Proprietary and Confidential Oracle Application Manager Command Line (oakcli) • OAKCLI leverages current OneCommand Toolset with Oracle Database Appliance specific enhancements. • Commands oakcli show - show storage, license, expander, controller, diskgroup, disk oakcli locate - locates a disk oakcli apply - applies the core_configuration_key <key file location> oakcli deploy - deploys the Database Appliance oakcli update - updates the Database Appliance oakcli validate - validates the Database Appliance oakcli manage - manages the oak repository, diagcollect e.t.c oakcli unpack - unpack the given bundle to oak repository oakcli configure - configures the network oakcli copy - copies the deployment config file 42 | © 2011 Oracle Corporation – Proprietary and Confidential Le Business Issues indirizzabili • Business Continuity • Storage Optimization • System Management • Database Security 43 | © 2011 Oracle Corporation – Proprietary and Confidential Le Business Issues indirizzabili • Business Continuity • Storage Optimization • System Management • Database Security 44 | © 2011 Oracle Corporation – Proprietary and Confidential DB Appliance: Business Continuity Durante l’installazione possibile scegliere fra tre tipologie di installazione automatica con differenti livelli di protezione dal punto della Alta Affidabilita’. Single Instance Active – Passive Active – Active • Good Availability • Better Availability • Best Availability • Oracle Database 11g Enterprise Edition • Oracle Database 11g Enterprise Edition • Oracle Database 11g Enterprise Edition • Oracle Real Application Clusters One Node • Oracle Real Application Clusters • Can have mutual failover 45 | © 2011 Oracle Corporation – Proprietary and Confidential © 2011 Oracle Corporation • Mutual failover and loadbalancing Real Application cluster public network Node1 VIP1 Service VIPn Service Listener Listener instance 1 instance n ASM ASM cluster interconnect Clusterware Operating System Node 2 Grid Clusterware Operating System Infr re u t c u ast r shared storage Redo / Archive logs all instances Database / Control files OCR and Voting Disks 46 | © 2011 Oracle Corporation – Proprietary and Confidential Oracle Database 11g Release 2 RAC ONE Node – RAC for mass consolidation D • • • • BC DB D DB E DB F Automated Failover within Grid Live migration of across Grid Rolling Patches Online Upgrade to multi-node RAC instances 47 | © 2011 Oracle Corporation – Proprietary and Confidential DB A DB B RAC-One Node Server A DB1 Server B DB2 DB3 Common Shared Storage Single Cluster 48 | © 2011 Oracle Corporation – Proprietary and Confidential Data Guard Standby Database Production Database Sync or Async Transaction Shipping Optional Delay Network Recovery O ReadOnly 49 | © 2011 Oracle Corporation – Proprietary and Confidential Backup DIGITAL DATA STORAGE DIGITAL DATA STORAGE Active Data Guard Standby Database Backup Production Database Sync or Async Transaction Shipping Optional Delay DIGITAL DATA STORAGE DIGITAL DATA STORAGE Network Recovery O ReadOnly Standby Database Optional Recovery E ReadOnly Delay Continuously Open for Reports DIGITAL DATA STORAGE DIGITAL DATA STORAGE 50 | © 2011 Oracle Corporation – Proprietary and Confidential Le Business Issues indirizzabili • Business Continuity • Storage Optimization • System Management • Database Security 51 | © 2011 Oracle Corporation – Proprietary and Confidential DB Appliance: Storage Optimization Advanced Compression Option Relativamente alla slide appena mostrata che elenca alcune delle Business Issues indirizzate dalla Enteprise Edition con le sue Features ed Opzioni e avendo notato che la macchina dispone di 4 Terabyte di spazio disco utile, come posso eventualmente ottimizzare lo storage? • Oracle 9i Data Compressio comprime i dati solamente durante le operazioni “bulk load”, quindi utile per DW e ILM • Oracle 11g Advanced Compression comprime anche su operazioni di insert e update • La “compression ratio” tipica e’ 2x to 3x • Il DB legge direttamente i dati in formato compresso eliminando l’overhead delle decompressione. 52 | © 2011 Oracle Corporation – Proprietary and Confidential Le Business Issues indirizzabili • Business Continuity • Storage Optimization • System Management • Database Security 53 | © 2011 Oracle Corporation – Proprietary and Confidential DB Appliance: System Management Oltre alle opzioni prima elencate, riconducibili alle aree evidenziate, con Oracle EE sono inoltre disponibili alcune opzioni dello strumento di amministrazione : • EM MANAGEMENT PACKS: funzionalita’ avanzate per la gestione ed il monitoraggio dell’intero ecosistema Oracle - Diagnostic Pack Tuning Pack Database Lifecycle Management Pack Test Data Management Pack Data Masking Pack 54 | © 2011 Oracle Corporation – Proprietary and Confidential DB Appliance: System Management Real Application Testing End-to-End Workflow Create Test Capture Workload Replay Workload System Deploy Replay Clients • SQL Performance Analyzer (SPA) • SQL unit testing for response time tuning • Database Replay • Concurrent load testing using production workloads 55 | © 2011 Oracle Corporation – Proprietary and Confidential Real Application Testing SQL Performance Analyzer SQL Plans + Stats Pre-Change Trial SQL Workload STS • • • • • SQL Plans + Stats Post-Change Trial Compare SQL Performance Analysis Report Test and predict impact of system changes on SQL query performance Analyze performance changes for improvements or regression Comprehensive performance analysis and reporting Re-execute SQL queries in test environment End-to-end solution: STS, SQL Plan Baselines, & SQL Tuning Advisor 56 | © 2011 Oracle Corporation – Proprietary and Confidential Database Load Testing Today Test – 1-2 testers trying to be 1,000s of users PRODUCTION 57 | © 2011 Oracle Corporation – Proprietary and Confidential TEST • Infrastructure load testing not adequately performed • Many issues go undetected • Testing expensive in time and money with poor results • Changes such as db upgrades, platform migrations, etc., can produce issues uncovered during proper load testing only • Challenge is to generate a test workload that is representative of production environment Real Application Testing Database Replay Production Clients Test Replay Driver • Reduce costs and risks of database changes • Fully automated workflow • Change Assurance for – Database and O/S upgrades – Configuration changes, e.g., conversion from SI to RAC – Storage changes – O/S migrations • Supports upgrades from Oracle 9iR2 to 10gR2 and 11g! Storage 58 | © 2011 Oracle Corporation – Proprietary and Confidential Storage Le Business Issues indirizzabili • Business Continuity • Storage Optimization • System Management • Database Security 59 | © 2011 Oracle Corporation – Proprietary and Confidential Oracle Database Security Defense-in-Depth Encryption and Masking • Oracle Advanced Security • Oracle Secure Backup • Oracle Data Masking Access Control • Oracle Database Vault • Oracle Label Security Auditing and Tracking • Oracle Audit Vault • Oracle Configuration Management • Oracle Total Recall Monitoring and Blocking • Oracle Database Firewall 60 | © 2011 Oracle Corporation – Proprietary and Confidential Summary • Simple to deploy – Pre-configured with validated components – Best practices implemented – Reduced risk in deploying HA • Simple to manage – Automatically detects problems & takes corrective actions – Patch all components with single command – End-to-end management – hardware to software • Simple to troubleshoot – ASR configuration – Validates system configuration – Gathers relevant logs for support 61 | © 2011 Oracle Corporation – Proprietary and Confidential © 2011 Oracle Corporation – Proprietary and Confidential 62 | © 2011 Oracle Corporation – Proprietary and Confidential 63 | © 2011 Oracle Corporation – Proprietary and Confidential