EXACC ORACLE DATABASE EXADATA CLOUD AT CUSTOMER SESSION

EXACC - ORACLE DATABASE EXADATA CLOUD AT CUSTOMER SESSION 7037 November 6 th, 2019 CANADA ALLIANCE 4 - 6 NOVEMBER 2019

PRESENTERS Joe Giardine Paul Laurent Laura Seely Database Administrator Mc. Master University giardin@mcmaster. c a laurenp@mcmaster. ca seelyl@mcmaster. ca Oracle DBA and People. Soft Administrator working at Mc. Master for 23 years with a background in application development. Oracle DBA with sixteen years of Oracle experience in both higher education and manufacturing sectors. People. Soft Administrator and Oracle DBA, working at Mc. Master for 11 years with a strong systems integration background. CANADA ALLIANCE 4 - 6 NOVEMBER 2019

MCMASTER UNIVERSITY Founded in 1887, in Toronto, through a bequest from the estate of Senator William Mc. Master Relocated from Toronto to Hamilton in 1930 CANADA ALLIANCE 4 - 6 NOVEMBER 2019

ORGANIZATION & ORACLE Oracle 12 c R 2 People. Tools 8. 55. 22 Interactive Hub 9. 2. 2 FSCM 9. 2. 25 HCM 9. 2. 24 CS 9. 2. 7 CANADA ALLIANCE 4 - 6 NOVEMBER 2019

EXACC – MCMASTER’S EXPERIENCE AGENDA 1. What is EXACC Brief discussion of EXACC architecture and licensable feature set. 2. EXACC Implementation, Installation and Operational Roles From hardware delivery to operational readiness, standing up EXACC at Mc. Master. 3. Migration To EXACC How do we get there from here, tooling and migration strategies. 4. EXACC and High Impact Database Features. Review of licensable database features that were implemented as part of initial EXACC rollout. 5. Transformative impact of EXACC at Mc. Master Direct and indirect transformative impact of EXACC implementation at Mc. Master CANADA ALLIANCE 4 - 6 NOVEMBER 2019

WHAT IS EXACC Overview of EXACC and it’s core components. CANADA ALLIANCE 4 - 6 NOVEMBER 2019

WHAT IS EXACC – SYSTEM ARCHITECTURE EXACC Exadata is a combined hardware and software solution that is optimized for running Oracle Database Exa. Data includes four core components: Compute Nodes Exadata Storage Servers Low Latency Infini. Band Network Exa. Data System Software CANADA ALLIANCE 5 -7 NOVEMBER 2017

WHAT IS EXACC – SYSTEM ARCHITECTURE EXACC – EXADATA CLOUD AT CUSTOMER Cloud at Customer keeps data physically on site while allowing Oracle to manage and support the database servers. Mc. Master has two Exa. Data X 7 -2 Servers on campus CANADA ALLIANCE 4 - 6 NOVEMBER 2019

WHAT IS EXACC – SYSTEM ARCHITECTUR Oracle Cloud Control Plane (OCC) is a E separate component of an EXACC deployment. • Separate hardware rack that consists of infrastructure and software components needed to run Oracle Cloud. These would include, but not be limited to: • DNS Services • Oracle Cloud UI • OCC is installed and managed by Oracle. CANADA ALLIANCE 5 -7 NOVEMBER 2017

WHAT IS EXACC – MCMASTER SPECS Gilmor Hall JHE Supported Oracle DB Versions • 11. 2. 0. 4 • 12. 1. 0. 2, 12. 2. 0. 1 • 18 Bursting • Can temporarily scale up the processing power • Up to 60 OCPU per Rack or to the max allowable OCPU limit Rack 1: ¼ RACK • 30 OCPU (cores) • 1, 440 GB RAM • 106 TB Storage • Scale up to 92 OCPUs Rack 2: 1/8 th RACK • 30 OCPU (cores) • 480 GB RAM • 42 TB Storage • Scale up to 44 OCPUs CANADA ALLIANCE 5 -7 NOVEMBER 2017

WHAT IS EXACC – SYSTEM ARCHITECTURE ORACLE ADVANCED SUPPORT GATEWAY (OASG) Oracle hardware and software that connects a Cloud at Customer environment to Oracle Operations Team OASG Exa. Data OCC Oracle Operations team monitors hardware on day to day basis. CANADA ALLIANCE 5 -7 NOVEMBER 2017

EXACC IMPLEMENTATION, INSTALLATION AND OPERATIONAL ROLES Standing up EXA at Mc. Master CANADA ALLIANCE 4 - 6 NOVEMBER 2019

EXACC IMPLEMENTATION AT MAC • Getting Ready – Pre – Hardware Delivery Tasks • Hardware Delivery and Software Installation. • Handover and Integration into Mc. Master Ecosystem • EXACC at Mc. Master and Operational Roles CANADA ALLIANCE 4 - 6 NOVEMBER 2019

EXACC IMPLEMENTATION AT MAC PRE-DELIVERY TASKS Clear floor space. Run Electrical Network Configuration and Firewall Rules Install and Configure New Version of Cloud Control CANADA ALLIANCE 4 - 6 NOVEMBER 2019

EXACC IMPLEMENTATION AT MAC – DELIVERY AND SOFTWARE INSTALLATION Hardware Delivery: Arranged with via Oracle and Mc. Master Project and Operations Team Hardware installation performed by Oracle Software Installation: Installation software installation and associated patching performed of EXACC and the OCC performed by Oracle. CANADA ALLIANCE 5 -7 NOVEMBER 2017

EXACC IMPLEMENTATION AT MAC – HANDOVER AND INTEGRATION Oracle Specific Handover Items Workshops on new features and functionality associated EXA and associated licensable products. EXA hardware and tooling overview conducted by CSM. Integration into Mc. Master management and monitoring system OEM 13 C – Push 13 c agents and perform associated configuration Installation of backup agents and installation of Oracle specific backup plugins. CANADA ALLIANCE 5 -7 NOVEMBER 2017

EXACC IMPLEMENTATION AT MAC - OPERATIONAL ROLES Role Group Oracle • OCC and EXACC Patching • Remote Hardware Monitoring • Hardware Replacement (disk, memory etc) • Customer liasing via CSM Mc. Master Operations • Co-ordination of onsite part replacement. • Provide physical access to Oracle personnel to Mc. Master Data Centres DBA Team • Creation, monitoring, PSU and maintenance of databases • PSU patches • Performance tuning • Additional sys admin tasks CANADA ALLIANCE 5 -7 NOVEMBER 2017

EXACC IMPLEMENTATION AT MAC - OPERATIONAL ROLES Group Role Enterprise Systems • Provide access to leverage Mc. Master infrastructure • Backup Appliance • Access to additional storage (NFS) Enterprise Networks • F/W rules – On Going • Initial network config required for EXACC. • Primary DNS services for scan aliases, EXACC VIPS and EXACC compute node host. CANADA ALLIANCE 5 -7 NOVEMBER 2017

MIGRATION TO EXACC Journey from Commodity Hardware to EXACC CANADA ALLIANCE 4 - 6 NOVEMBER 2019

EXACC IMPLEMENTATION AT MAC – MIGRATION TO EXACC Migration Tools Cloud UI Migrations Import/Export Strategies DBCA Transportable Tablespaces Restore and Clone CANADA ALLIANCE 5 -7 NOVEMBER 2017

EXACC IMPLEMENTATION AT MAC – MIGRATION TO EXACC Cloud UI • Used to create service instances. • Allows DBA’s to perform EXACC Specific Management and Monitoring • Burst for capacity on demand. • Start and stop databases and compute nodes. • Some limited monitoring capabilities CANADA ALLIANCE 5 -7 NOVEMBER 2017

EXACC IMPLEMENTATION AT MAC – MIGRATION TO EXACC Cloud UI (Continued) • Used to create EXACC Databases • Recommend way to create all databases on EXACC. • For 12 CR 1 and above, CDB’s and a starter PDB are created. • All databases RACed (all versions) • Used to create MAA databases. • Can be used to apply databases patches. CANADA ALLIANCE 5 -7 NOVEMBER 2017

EXACC IMPLEMENTATION AT MAC – MIGRATION TO EXACC DBCA • More traditional tool used for database creation. • For the purposes of People. Soft migrations at make, used to create a standalone staging database. • On EXACC must be run from an existing Oracle Home created via the Cloud UI. CANADA ALLIANCE 5 -7 NOVEMBER 2017

EXACC IMPLEMENTATION AT MAC – MIGRATION TO EXACC Factors Influencing the Migration Strategy Mc. Master is not a 24 X 7 shop. Production People. Soft Streams at Mc. Master have negotiated monthly weekends. Non. People. Soft environment outages negotiated with stakeholders around business cycles. Relative size of database also contributes to the choice of migration strategy. CANADA ALLIANCE 5 -7 NOVEMBER 2017

EXACC IMPLEMENTATION AT MAC – MIGRATION TO EXACC Creating a Database on EXACC VIA Cloud UI All strategies required the creation of database via Cloud UI. Access to Cloud UI is via a web interface hosted by the OCC. EXACC rack location, version and availability requirements need to be known prior to creation of database. CANADA ALLIANCE 5 -7 NOVEMBER 2017

EXACC IMPLEMENTATION AT MAC – MIGRATION TO EXACC CANADA ALLIANCE 5 -7 NOVEMBER 2017

EXACC IMPLEMENTATION AT MAC – MIGRATION TO EXACC MIGRATION METHODS Import/Export • Useful when migrating small databases. • Use Data pump to export application schemas from source database. • Use database pump to import database into pdb. Tranportable Tablespaces Restore/Clone • Mc. Master Use Case: PDB unplug/plug migration failed on EXACC due to Data. Patch Roll back issue. • Place source application tablespaces in read only mode. • Copy application datafiles to staging location. • Perform Metadata export of source database. • Copy datafiles from staging location into • Create non CDB staging database off existing EXACC home using DBCA. • Perform RMAN backup of source database. • Restore RMAN backup to staging database. • Clone database as PDB to target CDB. • Perform PDB conversion activities. • Patch PDB

EXACC HIGH IMPACT FEATURES SHORT DESCRIPTION CANADA ALLIANCE 4 - 6 NOVEMBER 2019

EXACC HIGH IMPACT FEATURES CANADA ALLIANCE 5 -7 NOVEMBER 2017

EXACC HIGH IMPACT FEATURES Key Features Immediatel y Adopted At Mc. Master • Multitenanc y • Partitioning • Active Data Guard CANADA ALLIANCE 5 -7 NOVEMBER 2017

EXACC HIGH IMPACT FEATURES MUTLITENANCY Pre 12 C database architecture Multitenancy architecture CANADA ALLIANCE 5 -7 NOVEMBER 2017

EXACC HIGH IMPACT FEATURES Mc. Master Multitenancy Use Cases • Rapid Provisioning • Inter and Intra PDB Cloning Operations for rapid Refreshes. • Snap cloning via test master • Patching and upgrade • Increased speed/rollout time • Lower risk – no big bang approach CANADA ALLIANCE 5 -7 NOVEMBER 2017

EXACC HIGH IMPACT FEATURES Mc. Master Multitenancy Use Cases Consolidation: • Reduced Resource footprint • Memory • Storage • Manage many as one • Reduction in overall hardware footprint. CANADA ALLIANCE 5 -7 NOVEMBER 2017

EXACC HIGH IMPACT FEATURES Partitioning • What is partitioning • Benefits of partitioning • Mc. Master’s Partitioning Implementation Strategy CANADA ALLIANCE 5 -7 NOVEMBER 2017

EXACC HIGH IMPACT FEATURES What is Partitioning • Decomposition of a very large table in smaller set of tables that are related to each other. CANADA ALLIANCE 5 -7 NOVEMBER 2017

EXACC HIGH IMPACT FEATURES Advantages of Partitioning • Improved Availability • Reduced Costs • Improved Performance Partitioning - Mc. Master Implementation Approach • • • Identify candidate partitioning tables Identify partitioning key(s) Pre partitioning performance baseline testing Partition table Re-run baseline tests CANADA ALLIANCE 5 -7 NOVEMBER 2017

EXACC HIGH IMPACT FEATURES Active Data Guard • What is Active Data Guard • Active Data Guard use cases and current use in our Peoplesoft environment CANADA ALLIANCE 5 -7 NOVEMBER 2017

EXACC HIGH IMPACT FEATURES Primary Database Data Guard Standby Database CANADA ALLIANCE 5 -7 NOVEMBER 2017

EXACC HIGH IMPACT FEATURES Data Guard and Active Data Guard • Real-time Data Protection/continuous synchronization and data validation and HA • RO components, Queries and Reports Offload • Off load RMAN Backups • Source of thin snaps/clones CANADA ALLIANCE 5 -7 NOVEMBER 2017

TRANSFORMATIVE IMPACT OF EXACC ANY QUESTIONS? CANADA ALLIANCE 4 - 6 NOVEMBER 2019

TRANSFORMATIVE IMPACT OF EXACC As a result of implementing EXACC Mc. Master has seen two types of benefits: Direct Benefits Indirect Benefits CANADA ALLIANCE 5 -7 NOVEMBER 2017

TRANSFORMA TIVE IMPACT OF EXACC Direct Benefits • Greatly Reduced Complexity of, and effort required to manage, Mc. Masters’s Oracle Environment. • Performance Improvements: • PSQuery and Data Warehousing components saw immediate performance impacts with little tuning required. • Database cloning/refresh times greatly reduced. • Partitioning allows for performance gains. CANADA ALLIANCE 5 -7 NOVEMBER 2017

TRANSFORMATIVE IMPACT OF EXACC Indirect • Allowed us to review database we support and remove those that were no longer needed • Catalyst for review and modification of our People. Soft Instance strategy and environment geometry • Allowed for us to pursue end to end refreshes of our People. Soft environments. CANADA ALLIANCE 5 -7 NOVEMBER 2017

QUESTIONS ? ? CANADA ALLIANCE 5 -7 NOVEMBER 2017

THANK YOU! CANADA ALLIANCE 4 - 6 NOVEMBER 2019