Deep Dive into Oracle Database Appliance with Oracle Database 12c Tammy Bednar, Director of Product Management Oracle Database Appliance November, 2014
Copyright © 2014, Oracle and/or its affiliates. All rights reserved. |
Safe Harbor Statement The following is intended to outline our general product direcLon. It is intended for informaLon purposes only, and may not be incorporated into any contract. It is not a commitment to deliver any material, code, or funcLonality, and should not be relied upon in making purchasing decisions. The development, release, and Lming of any features or funcLonality described for Oracle’s products remains at the sole discreLon of Oracle.
Copyright © 2014, Oracle and/or its affiliates. All rights reserved. |
Program Agenda 1
Oracle Database Appliance Overview
2
Appliance Manager 12.1.2.0.0
3
Virtualized PlaRorm Updates
4
Future: Monitoring with EM Plug-‐In
5
Q & A
Copyright © 2014, Oracle and/or its affiliates. All rights reserved. |
Oracle Database Appliance Vision • Simple: Automated deployment, patching, and support – Less Deployment Risk
• Reliable: Complete HA PlaRorm for DB and ApplicaLons in a Box – Less Performance Risk
• Affordable: Capacity-‐on-‐Demand licensing – Less OperaLng Risk
Copyright © 2014, Oracle and/or its affiliates. All rights reserved. |
Simple to Install, Manage, and Maintain
• Automated Deployment • Automated Patching • “Zero-‐Admin” Storage • Integrated VM Management • Single Vendor Support
Copyright © 2014, Oracle and/or its affiliates. All rights reserved. |
Reliable Highly Available Hardware • Two dual-‐socket Oracle Linux servers • Redundant private interconnect • Redundant public networks • Double-‐mirroring or triple-‐mirroring storage redundancy • Redundant hot-‐swappable power, cooling, and fans
So/ware • Oracle Database 12c & 11g R2 Enterprise EdiLon – Real ApplicaLon Clusters – RAC One Node – Single Instance • Oracle Grid Infrastructure – AutomaLc Storage Management – Oracle Clusterware • Oracle Linux and Oracle VM • Oracle Appliance Manager Copyright © 2014, Oracle and/or its affiliates. All rights reserved. |
Oracle Database Appliance X4-‐2 Simple. Reliable. Affordable. • 2 x 1RU x86 Servers. Each Server Contains: • 2 x 12-‐core Intel Xeon Processors • 256 GB RAM • 600 GB local storage • Redundant 10GbE Interconnect • OpLonal 10GBase-‐T or 10GbE SFP+ Public Network • 1 x 2RU Storage Shelf – Direct-‐AIached: • 800 GB SSDs for Redo • 18 TB HDDs for Data • OpLon for second storage shelf doubles capacity Copyright © 2014, Oracle and/or its affiliates. All rights reserved. |
Affordable Capacity On Demand Licensing OpLon 1: Build Your Own License 48 Cores for An/cipated Growth
OpLon 2: Buy Database Appliance License as You Grow and Save Significantly
48 Cores 32 Cores
Add Capacity When You Need It
24 Cores 16 Cores
OR
12 Cores 8 Cores 4 Cores
Year 1
Year 2
Year 3
Purchase Capacity Up Front
Year 1
Year 2
Year 3
Purchase Capacity-‐on-‐Demand Copyright © 2014, Oracle and/or its affiliates. All rights reserved. |
Support ApplicaLon Workloads Through VirtualizaLon • ULlizaLon of the full ODA capacity regardless of database core usage • Efficient sharing of the plaRorm with one or more applicaLons • Capacity-‐on-‐demand licensing for both database and applicaLons • IsolaLon between database and applicaLon workloads • Enables soluLon-‐in-‐a-‐box Copyright © 2014, Oracle and/or its affiliates. All rights reserved. |
Oracle Database Appliance EvoluLon Simple. Reliable. Affordable.
Oracle Database X4-2 Introduced
Oracle Database X3-2 Introduced
Oracle Database Appliance Introduced
Support for Oracle Database 12c
• Hardware Upgrade • 48 processor cores • Flexible networking options
• Hardware Upgrade Support for Oracle VM • 32 processor cores • Capacity of Demand Licensing • 512GB memory for Databases & Applications • Optional storage expansion shelf • Larger storage footprint
• Highly Available Database Solution • Simplified Deployment, Maintenance, Support • Capacity On Demand Database Licensing
2011
2012
2014
2013 Copyright © 2014, Oracle and/or its affiliates. All rights reserved. |
Appliance Manager 12.1.2.0.0 Oracle Database 12c Support, ACFS IntegraLon, Database Snapshots
Copyright © 2014, Oracle and/or its affiliates. All rights reserved. |
Oracle Database 12c support • Full support for Oracle Database Release 12c (12.1.0.2) – MulLtenant, In-‐Memory, … – Grid Infrastructure Upgraded to 12.1.0.2 – Support for database version: 12.1.0.2, 11.2.0.4, 11.2.0.3, 11.2.0.2 – Choice of CDB and non-‐CDB for new 12.1.0.2 databases
• All the ODA plaRorm advantages available for 12c databases – OAKCLI automated database creaLon – Sizing template support – Best pracLces compliance with 12c init parameters
Copyright © 2014, Oracle and/or its affiliates. All rights reserved. |
Provisioning IniLal ConfiguraLon • Download latest version ODA somware bundle for BM or VM (12.1.2.1.0 latest release) – Grid Infrastructure and Database (/w Linux OS image for VM) • Patched with current patch set, PSU and all criLcal one-‐off’s
• Gather configuraLon info through a Wizard • Deploys Oracle RAC in less than an hour
1
Create ASR
Create Cluster
Configure Networking
2 Configure Storage
3
4
5
Create Database Copyright © 2014, Oracle and/or its affiliates. All rights reserved. |
Complete Complete
Appliance Manager 12.1.2.1.0 Configurator includes Container Database OpLon
Copyright © 2014, Oracle and/or its affiliates. All rights reserved. |
Database Templates Sized for Performance Database Class
CPU Cores
Memory
# of Databases
XX Small
2
4 GB
64
X Small
2
8 GB
32
Small
4
16 GB
16
Medium
8
32 GB
8
Large
12
48 GB
5
X Large
24
96 GB
2
XX Large
32
128 GB
2
XXX Large
48
192 GB
1
• Provides well defined database configuraLon templates … – Sizing for CPU and Memory • Out of the box allocaLon for SGA and PGA
– Incorporates all best pracLce database init parameter – Advise on the storage characterisLcs – MulLple sizes to saLsfy various workloads
Copyright © 2014, Oracle and/or its affiliates. All rights reserved. |
Simple Commands to Patch System and Databases OAKCLI Interface
• Update system infrastructure and databases – oakcli update –patch 12.1.2.1.0 –-infra
– Updates all firmware, OS, ILOM, Appliance Manager, and ASR – oakcli update –patch 12.1.2.1.0 –-gi
– Updates Grid Infrastructure – oakcli update –patch 12.1.2.1.0 –-database
– Update one, set or all databases to the latest PSU
Copyright © 2014, Oracle and/or its affiliates. All rights reserved. |
Simple Commands to Create and Upgrade Databases OAKCLI Interface
• Create container databases – oakcli create database -db
-version 12.1.0.2.1 -cdb
– Leverages sizing templates and defaults to provide best pracLce compliant configuraLon
• Upgrade 11.2 databases to 12.1.0.2.1 – Create new 12.1.0.2.1 Oracle Home – oakcli create dbhome –version 12.1.0.2.1
– Upgrade the 11.2 database to the newly created 12.1.0.2.1 home – oakcli upgrade database –db –to
Copyright © 2014, Oracle and/or its affiliates. All rights reserved. |
ASM Cluster File System (ACFS) IntegraLon • New Oracle 12c and 11g databases are automaLcally created in ACFS • Benefits of using ACFS – High performance and highly available cluster file system – Built on top of Oracle ASM – Fully integrated with Grid Infrastructure – Database aware – Support advanced storage features like file system snapshots and replicaLon – Very high disk IO (naLve) performance for database workloads – OpLmal for both Database and non-‐database workloads
• ExisLng databases remain in ASM Copyright © 2014, Oracle and/or its affiliates. All rights reserved. |
Appliance Manager 12.1.2.0.0 Storage Architecture ASM Cluster File System (ACFS) data
reco
redo
repo1..N
ASM Disk Groups +DATA, +RECO, +REDO HDDs
Disk
Disk Group
Volumes
Used For
HDD Outer Rings
+DATA
data
Database data files
HDD Outer Rings
+DATA
Repo1.. repoN
Shared Repository for VMs, VDisk
HDD Inner Rings
+RECO
reco
Database archive logs, RMAN backups (Fast Recovery Area)
HDD Inner Rings
+RECO
Repo1.. repoN
Shared Repository for VMs, VDisk
HDD Inner Rings
+RECO
cloudfs
Clustered file system – files that need to be accessed by either server node
SSD
+REDO
redo
Database redo logs
SSDs
Copyright © 2014, Oracle and/or its affiliates. All rights reserved. |
Database Snapshots Rapid and Efficient Database Copies
• Rapid and efficient provisioning of database environments for development and tesLng of applicaLons • Complete OAKCLI integraLon – Very fast way to create database copies (less than 5 minutes)
• Snapshot databases only uses space for the data that changes – Only meta-‐data is originally created – Blocks are wriqen when data is changed
• Create large number of snapshots for a given database
Copyright © 2014, Oracle and/or its affiliates. All rights reserved. |
Database Snapshots Flexible
• Independent of database type – Single Instance EE -‐> Single Instance EE – RAC -‐> RAC One Node – RAC One Node -‐> RAC
• Independent of database template size – Small -‐> Medium – Large -‐> Very small – Medium -‐> Extra Large
Copyright © 2014, Oracle and/or its affiliates. All rights reserved. |
Database Snapshots Pre-‐Requisites
• Source database requirements – 11.2.0.4 or greater – Located on ACFS – ARCHIVE mode enabled – Primary database and open – All data files are online and no data file is missing – If data files are encrypted, wallet password is required
Copyright © 2014, Oracle and/or its affiliates. All rights reserved. |
Simple to Create Database Snapshots OAKCLI Interface
• Create database snapshots – oakcli create snapshotdb –db -from
• MulLtenant database snapshots are created with SQLPlus
Copyright © 2014, Oracle and/or its affiliates. All rights reserved. |
Use Case: Rapid Database Snapshots
ProducLon Environment
Test & Dev ODA
Exadata Server
Copy database From ProducLon
Database Refresh Database Master
DB
Before Snapshot Refresh Snap
ODA Server
Snapshot
Snapshot
DB 3rd-‐party server
Test Database
Test Database
Test Database
DB
oakcli create snapshotdb –db -from
Copyright © 2014, Oracle and/or its affiliates. All rights reserved. |
Virtualized PlaRorm Update VLAN IntegraLon, VDisk Support, VM Snapshots
Copyright © 2014, Oracle and/or its affiliates. All rights reserved. |
Oracle Database Appliance Virtualized PlaRorm EvoluLon
Jan 2013 (2.5) IniLal Release
Aug 2013 (2.7) OVM Server 3.2.3
Nov 2013 (2.8) VLAN, Shared repository
Copyright © 2014, Oracle and/or its affiliates. All rights reserved. |
Sep 2014 (12.1.2 ) VM Snapshot, VDISK
Oracle Database Appliance Virtualized PlaRorm Architecture Oracle Database Appliance Node 1
Node 0
Domain U
Domain U
Domain U
Domain U
Domain U
Domain U
DOM 0 ODA Base
VM Storage • Appliance Manager Repository • Grid Infrastructure • Database
DOM 0 ODA Base
VM Storage • Appliance Manager Repository • Grid Infrastructure • Database
• Domain 0 bootstraps the deployment process and maintains the local storage repository for VMs • ODA Base is a privileged VM domain that provides naLve disk performance for databases • Individual VM domains provide isolaLon to run applicaLons, middleware, etc.
Copyright © 2014, Oracle and/or its affiliates. All rights reserved. |
VLAN Support Provide Network Security IsolaLon for MulLple Workloads Sharing Common Network
• ODA X3-‐2 and ODA X4-‐2 for outbound communicaLon – Ships with 2 highly available preconfigured (bonded) network interfaces
• VLAN enables customer to create mulLple isolated, secure networks on these 2 interfaces • ApplicaLon VMs can have dedicated VLAN to ensure security and compliance • ODA_Base can also be configured to work with its own VLAN
Copyright © 2014, Oracle and/or its affiliates. All rights reserved. |
VLAN OAKCLI Interface
• Create VLAN – oakcli create vlan -vlanid -if –node <0|1>
• Show VLAN – oakcli show vlan
• Delete VLAN – oakcli delete vlan -node <0|1>
• Aqach VLAN network to DomU – oakcli modify vm -addnetwork
• Remove VLAN network from DomU – oakcli modify vm -deletenetwork Copyright © 2014, Oracle and/or its affiliates. All rights reserved. |
VDisk Add AddiLonal Guest VM Storage Node-‐0
Guest VM
VDisk-‐1
Node-‐1
ODA_BASE
VDisk-‐2
Guest VM
VDisk-‐3
ODA_BASE
VM Template
• Allows dynamic addiLon of storage to exisLng VM • Full OAKCLI integraLon • Support for VM exclusive and shared VDISK
Shared Repository
Copyright © 2014, Oracle and/or its affiliates. All rights reserved. |
VDisk OAKCLI Interface
• Create VDisk – oakcli create vdisk -repo -size -type
• Show VDisk – oakcli show vdisk -repo
• Delete VDisk – oakcli delete vdisk -repo
• Aqach VDISK to VM – oakcli modify vm -attachvdisk
• Remove VDisk from VM – oakcli modify vm -detachvdisk
Copyright © 2014, Oracle and/or its affiliates. All rights reserved. |
VM Snapshots New VM in seconds
• Space efficient way to clone VM and Template • Instantaneous VM in seconds even for large VM’s • Fully integrated with OAKCLI • Leverages ACFS snapshot technology
Copyright © 2014, Oracle and/or its affiliates. All rights reserved. |
VM Snapshots OAKCLI Interface
• Create VM Snapshot from VM template – oakcli clone vm -vmtemplate -snap
• Create VM Snapshot from exisLng VM – oakcli clone vm -vm -snap
Copyright © 2014, Oracle and/or its affiliates. All rights reserved. |
Use Case: Rapid VM Cloning Snapshot Node 1
Node 2
WebLogic Template WebLogic WebLogic VM WebLogic VM WebLogic VM VM
• Much faster provisioning with new ‘snap’ feature – 15 minutes • WebLogic templates for 11g (10.3.6), 12c (12.1.2 and 12.1.3) • Oracle Database 12c
WebLogic WebLogic VM WebLogic VM WebLogic VM VM
• MulL domain and mulL cluster opLons, including single instance • Coherence opLon during provisioning • New licensing opLons include a 'pool' of WebLogic licenses with min/max range, that can be allocated to WebLogic, Oracle Traffic Director and other Oracle Cloud ApplicaLon FoundaLon products.
hqp://www.oracle.com/technetwork/middleware/weblogic-‐oda/downloads/index.html Copyright © 2014, Oracle and/or its affiliates. All rights reserved. |
Use Case: Rapid Patch/Upgrade
WebLogic Server 1
WebLogic Server 2
WebLogic Server 3
WebLogic Server 4
VDisk VDisk (ApplicaLon –– (ApplicaLon WebLogic 111.2) WebLogic 2.1)
VDisk VDisk Detach –– (ApplicaLon (ApplicaLon VDisk 111.2) WebLogic WebLogic 2.1)
VDisk VDisk (ApplicaLon (ApplicaLon –– WebLogic 111.2) WebLogic 2.1)
VDisk VDisk (ApplicaLon –– (ApplicaLon WebLogic 111.2) WebLogic 2.1)
Upgrade applicaLon deployed on VDisk
Aqach upgraded Vdisk with applciaLon Copyright © 2014, Oracle and/or its affiliates. All rights reserved. |
Database and VM Snapshots Complete ApplicaLon Environment Ready in Minutes! Node-‐0 App VM ‘Gold’
Node-‐1 App VM Snap
App VM Snap
ODA BASE
ODA BASE
• Efficient database and applicaLon VM snapshots • Rapid full stack snapshots for development and test environments
Copyright © 2014, Oracle and/or its affiliates. All rights reserved. |
Oracle Database Appliance Simple. Reliable. Affordable.
• Simple to deploy, manage and maintain • Best-‐in-‐class availability • Best-‐in-‐class performance • Built-‐in scalability • Capacity-‐on-‐demand licensing • SoluLon-‐in-‐a-‐Box
Copyright © 2014, Oracle and/or its affiliates. All rights reserved. |
Copyright © 2014, Oracle and/or its affiliates. All rights reserved. |
