what’s*new*in*the*oracle*12c*release*2* - doag.org · pdf...
TRANSCRIPT
Copyright © 2016, Oracle and/or its affiliates. All rights reserved. |
What’s New in the Oracle 12c Release 2 Universal Installer & ConfiguraIon Tools?
Markus Michalewicz Senior Director of Product Management, Oracle RAC Development May 30th, 2017
[email protected] @OracleRACpm hWp://www.linkedin.com/in/markusmichalewicz hWp://www.slideshare.net/MarkusMichalewicz
Copyright © 2016, Oracle and/or its affiliates. All rights reserved. |
Safe Harbor Statement The following is intended to outline our general product direcIon. It is intended for informaIon purposes only, and may not be incorporated into any contract. It is not a commitment to deliver any material, code, or funcIonality, and should not be relied upon in making purchasing decisions. The development, release, and Iming of any features or funcIonality described for Oracle’s products remains at the sole discreIon of Oracle.
3
Copyright © 2016, Oracle and/or its affiliates. All rights reserved. |
Program Agenda
Overview and Gold Image Standard
gridSetup – The New Installer Swiss Army Knife
So^ware Deployment and Management ‘en masse’
Revamped Database ConfiguraIon Assistant (DBCA)
1
2
3
4
4
Copyright © 2016, Oracle and/or its affiliates. All rights reserved. |
Program Agenda
Overview and Gold Image Standard
gridSetup – The New Installer Swiss Army Knife
So^ware Deployment and Management ‘en masse’
Revamped Database ConfiguraIon Assistant (DBCA)
1
2
3
5
4
Copyright © 2016, Oracle and/or its affiliates. All rights reserved. | 6
Principally 2-‐step process Oracle Grid Infrastructure (GI) & Database (DB) Deployment
✔ So5ware installa7on (GI home / DB home)
1
DB Crea7on
GI Configura7on
2
Copyright © 2016, Oracle and/or its affiliates. All rights reserved. | 7
Simple Flow Oracle Grid Infrastructure (GI) & Database (DB) Deployment
So5ware installa7on
1 GI Configura7on
2
3 DB Crea7on 4
Copyright © 2016, Oracle and/or its affiliates. All rights reserved. | 8
Reality Oracle Grid Infrastructure (GI) Deployment
✔
4
t Base So5ware installa7on
e.g. 12.1.0.2
1
B
PSU applica7on e.g. 12.1.0.2.x
2
PSU
OneOff applica7on e.g. PatchXYZ
3
OneOff
Copyright © 2015, Oracle and/or its affiliates. All rights reserved. |
Oracle Grid Infrastructure Installer (12c Rel. 1 & Earlier) • Shiphome-‐based release – a proprietary format • Unzip and execute ‘runInstaller’ to get the so^ware • Configure Oracle Grid Infrastructure and Oracle ASM
– Trend is to use ‘config.sh’ a5er patching the so5ware • Supports interacIve and silent mode deployments • Other tools/scripts included in the Oracle GI Home:
– addNode.sh – to add more nodes to the exisIng cluster – config.sh – configures/upgrades the clusterware – clone.pl – registers a home in the inventory via a single-‐node opera7on
9
Copyright © 2016, Oracle and/or its affiliates. All rights reserved. | 10
Requirement: gold image support Oracle Grid Infrastructure (GI) Deployment
✔ Base
So5ware installa7on e.g. 12.1.0.2
1 4
t PSU applica7on e.g. 12.1.0.2.x
2
OneOff applica7on e.g. PatchXYZ
3
B PSU OneOff
Copyright © 2016, Oracle and/or its affiliates. All rights reserved. |
Oracle Grid Infrastructure Installer 12c Release 2
• StarIng with Oracle Grid Infrastructure 12c Rel. 2, the Grid Installer uses a gold image instead of the tradiIonal shiphome as installaIon media
• The zip-‐file available for download is therefore a 12.2.0.1 base gold image • The launch script is gridSetup.sh or gridSetup.bat • User-‐created (customized) gold images are supported
– Customiza7on can include PSUs and / or addi7onal patches
• The new deployment process has no impact on any post-‐install so^ware lifecycle management operaIons; e.g. adding nodes, cloning, patching
11
Gold image-‐based installa7on
Copyright © 2016, Oracle and/or its affiliates. All rights reserved. | 12
Not (even) considering PSU and OneOff applica7on Simple Gold Image-‐based Install
12c Rel. 1 & Earlier Install per cluster 12 Rel. 2 Gold Image-‐based Install per cluster Download shiphome zip files from OTN Download image zip files from OTN Unzip grid1/2.zip to some stage locaIon (stage_loc) No stage_loc Execute <stage_loc>/runInstaller.sh -‐ Bootstraps files to some temp area (1GB) No bootstrapping Copies files from <stage_loc> to OH No copy needed Zip up the OH and store it as image files -‐ Unzip image files to OH on all nodes of the cluster Unzip image files to OH on one of the nodes of cluster Execute clone.pl on all nodes of cluster Not needed Run config.sh from one of the nodes Run gridSetup.sh from one of the nodes
Copyright © 2016, Oracle and/or its affiliates. All rights reserved. |
Oracle Database Installer will Follow
13
Future 12c Rel. 2 enhancement
Copyright © 2016, Oracle and/or its affiliates. All rights reserved. |
Program Agenda
Overview and Gold Image Standard
gridSetup – The New Installer Swiss Army Knife
So^ware Deployment and Management ‘en masse’
Revamped Database ConfiguraIon Assistant (DBCA)
1
2
3
14 6/19/17
4
Copyright © 2016, Oracle and/or its affiliates. All rights reserved. |
gridSetup – The New Installer Swiss Army Knife Part 1
• New opIons supported with gridSetup: – PSU can be applied [-‐applyPSU] – OneOff patches can be applied [-‐applyOneOffs] – Run from network loca=on and deploy to local path [-‐des=na=onHome] – Execute post-‐install configuraIon tools [-‐executeConfigTools] – Execute root scripts automaIcally in silent install using sudo/root
– Installer can be patched [-‐applyInstallerUpdates] – Gold-‐image can be created from an exis7ng GI home [-‐createGoldImage]
15
Installa7on support
Copyright © 2016, Oracle and/or its affiliates. All rights reserved. |
Installer Patching
16
gridSetup … -‐applyInstallerUpdates
✔
n
t Patch applica7on as a prerequisite to running installer
P
Base So5ware installa7on
e.g. 12.2.0.1
1
…
N-‐1
Patch B
Copyright © 2016, Oracle and/or its affiliates. All rights reserved. | 17
gridSetup … -‐createGoldImage Gold-‐image CreaIon from ExisIng GI home
✔ Node1 Oracle GI | HUB
Exis7ng system
1 4
t Create gold image from exisIng home
2
Re-‐use image on addiIonal systems
3
B PSU Re-‐Use
Copyright © 2016, Oracle and/or its affiliates. All rights reserved. |
gridSetup – The New Installer Swiss Army Knife Part 2
• Improved cloning, addnode and post-‐install configuraIon • Supports mulI-‐node so^ware-‐only install of GI home
– Compare with cloning so^ware to mulIple nodes in one go
• Can be launched from a so^ware-‐only home – to configure the so^ware (config.sh replacement) – to add more nodes to the to-‐be-‐configured cluster
• Can be launched from a configured home to execute config tools
18
So5ware management support
Copyright © 2016, Oracle and/or its affiliates. All rights reserved. |
(Re-‐) Execute Post-‐Install ConfiguraIon Tools
• Works for gridSetup (GI) and runInstaller (DB, Client)
• Provides interacIve UI & works with the installer’s response file
• BeWer logging of configuraIon tools output for easier diagnosability – configToolAllCommands is deprecated
19
gridSetup … -‐executeConfigTools
Copyright © 2016, Oracle and/or its affiliates. All rights reserved. |
gridSetup Enhancements
20
Future 12c Rel. 2 enhancement
• Ability to re-‐run configtools of a failed/aborted installaIon • Ability to re-‐run root.sh • Ability to move GI to a new home
Copyright © 2016, Oracle and/or its affiliates. All rights reserved. |
Large Cluster Support Part 1
• With 12c Rel. 2, Oracle GI installer supports ‘Lenient’ mode installaIon
• Installer allows for eliminaIng nodes that are mis-‐configured & to proceed with the remaining nodes
• It is default behavior for all interacIve installaIons
• Supported for silent (non-‐interacIve) installaIons when “-‐lenientInstallMode” is specified on command line
21
‘Lenient’ installa7on mode
Node N Node N-1
Node2 Node1 Oracle GI | HUB Oracle GI | HUB
Oracle GI | HUB Oracle GI | Leaf ✔ ✔
Copyright © 2016, Oracle and/or its affiliates. All rights reserved. | 22
Support for specifying nodes using pa_erns/expressions Large Cluster Support Part 2
Copyright © 2016, Oracle and/or its affiliates. All rights reserved. |
Program Agenda
Overview and Gold Image Standard
gridSetup – The New Installer Swiss Army Knife
So^ware Deployment and Management ‘en masse’
Revamped Database ConfiguraIon Assistant (DBCA)
1
2
3
23
4
Copyright © 2015, Oracle and/or its affiliates. All rights reserved. | 24
So^ware Management in the Time of Cloud Things can get more and more difficult
Copyright © 2015, Oracle and/or its affiliates. All rights reserved. |
Gold Image as a Service (GlaaS)
25
Copyright © 2016, Oracle and/or its affiliates. All rights reserved. |
Gold Image Concept
26
Base So5ware installa7on
1
PSU applica7on
2
OneOff applica7on
3
B PSU OneOff
1
Gold image installa7on
Copyright © 2016, Oracle and/or its affiliates. All rights reserved. |
Introducing Gold Image as a Service (GIaaS)
• Oracle internal, centralized service to deliver ‘Gold Images’ • Simple & REST-‐enabled web portal offering ‘Gold Images’ of Oracle Homes • Users can choose a base release plus any PSU or OneOff required • Uniform and cost-‐effecIve way to deliver customized Oracle homes • GIaaS detects conflicts, builds, validates, and op7mizes the image • Output format -‐ tar, zip or Docker container • Images uploaded to Oracle Cloud Object storage
27
Currently Oracle internal only
Copyright © 2016, Oracle and/or its affiliates. All rights reserved. | 28
Get the patched so^ware as a docker container
Copyright © 2016, Oracle and/or its affiliates. All rights reserved. | 29
Allows input of exisIng inventory
Allows custom database template
Copyright © 2016, Oracle and/or its affiliates. All rights reserved. |
Rapid Home Provisioning (RHP) and Maintenance
30
Copyright © 2015, Oracle and/or its affiliates. All rights reserved. |
• Complex build process repeated for each node
• Error prone • Longest down-‐Ime and maintenance window
• Have to create backup (no built-‐in fallback plan)
• How do you enforce standardizaIon?
• Build gold image once, use everywhere
• Fewest steps, simplest process
• Shortest down-‐Ime and maintenance window
• Built-‐in Fallback • Built-‐in standardizaIon
• Complex build process repeated for each node
• Error prone • Shorter down-‐Ime and maintenance window
• Built-‐in Fallback • How do you enforce standardizaIon?
31
What is the best way to apply maintenance?
1 2 3 1 2 3 1 2
Update in Place Clone, Update and Switch Deploy Gold Image, Switch
Copyright © 2015, Oracle and/or its affiliates. All rights reserved. |
• Dri^ not seen unIl scan takes places
• Scanning unchanged targets is unnecessary work
• Does not prevent dri^
• No Ime lag between dri^ and alert
• No extra work • Does not prevent dri^
32
• Locked configs cannot dri^ • Can trigger alert if unauthorized changes aWempted
• Can trigger alert if authorized changes made
What is the best approach to handling so^ware dri^?
Scan
Trigger Alert
Prevent
Copyright © 2015, Oracle and/or its affiliates. All rights reserved. |
Streamline the DistribuIon Process
• Ship only once – To a customer, to a site, to a pool
• Ship to interested parIes only – Subscribers
• Ship only what is necessary – Updated Modules, Updated Files, Updated Blocks
• Deploy non-‐disrupIvely – Ship any Ime, choose when to use it
33
Customer
Copyright © 2015, Oracle and/or its affiliates. All rights reserved. | 34
• Simple • Prevent errors, enable easy correcIons • Use Gold Images for all scenarios • Enable mass operaIons on 1000s of nodes
Rapid Home Provisioning and Maintenance
Copyright © 2015, Oracle and/or its affiliates. All rights reserved. |
Build Inventory of Gold Images
35
Create once on RHP Server
Installed homes
11.2.0.4.1
DB
12.1.0.2 Custom
RHP Server • Uptake current estate by promo7ng exis7ng homes to gold images
• Create new homes and promote to gold images a5er valida7on
• Assign states to images for lifecycle management
GRID 11.2.0.4.3
WLS 12.2.1
• Oracle internal users: import image from GIaaS Grid
Copyright © 2015, Oracle and/or its affiliates. All rights reserved. | 36
Supported targets and environments Manage exis7ng and create new Pools, Homes, and Databases
• Patch and Upgrade exisIng deployments – No pre-‐requisites (config, agent, daemon…) for targets – Database and Grid Infrastructure 11.2.0.3, 11.2.0.4, 12.1.0.2, 12.2.0.1
• Provision, Scale, Patch and Upgrade new Clusters and Databases – 11.2.0.4, 12.1.0.2, 12.2.0.1
• Bare metal, VMs, CDBs, non-‐CDBs • SI (standalone, Restart, Grid Infr), RAC One, RAC • Linux, Solaris, AIX • Generic so^ware homes
Copyright © 2015, Oracle and/or its affiliates. All rights reserved. |
Easy to create Server, start managing current estate
• RHP Server fully self-‐contained – Commodity hardware or engineered systems, can be clustered for HA – Enable with single srvctl command – Lightweight -‐ can co-‐exist with other funcIons
• No new so^ware needed on targets • No run-‐Ime dependency between Server and targets
37
Copyright © 2015, Oracle and/or its affiliates. All rights reserved. |
Program Agenda
Overview and Gold Image Standard
gridSetup – The New Installer Swiss Army Knife
So^ware Deployment and Management ‘en masse’
Revamped Database ConfiguraIon Assistant (DBCA)
1
2
3
38
4
Copyright © 2015, Oracle and/or its affiliates. All rights reserved. |
Revamped DBCA
Revamp of UI Enhanced validaIon with unique error code New command line interface
39
Copyright © 2016, Oracle and/or its affiliates. All rights reserved. |
Duplicate Database CreaIon Support
• Supports creaIng Single Instance duplicate databases
• Can be used for creaIng standby databases for example
• Storage customizaIon during duplicaIon
40
Copyright © 2016, Oracle and/or its affiliates. All rights reserved. |
SelecIve Component ConfiguraIon for PDBs
• Allows for choosing whether a parIcular opIon is installed for a PDB
• Equivalent command line opIons are: – [-‐dbOpIons <A comma separated list of name:value pairs with database opIons to enable/disable. For example JSERVER:true,DV:false>]
– [-‐pdbOpIons <A comma separated list of name:value pairs with database opIons to enable/disable. For example JSERVER:true,DV:false>]
41
Copyright © 2016, Oracle and/or its affiliates. All rights reserved. |
Enhanced PDB Management FuncIonality
• Local UNDO tablespace per PDB • Modularized storage locaIons for PDBs
• Can create addiIonal PDBs when creaIng CDB from CDB template
• Rename PDB names during CDB creaIon from CDB template
42
Copyright © 2016, Oracle and/or its affiliates. All rights reserved. |
Clone Template CreaIon with Zero DownIme
• DBCA can take Hot backup of database • Database has to have archive log mode enabled.
43
Not every database is unique
Copyright © 2016, Oracle and/or its affiliates. All rights reserved. |
Summary
44
Gold image-‐based deployments are trending
Copyright © 2016, Oracle and/or its affiliates. All rights reserved. |
QuesIons & Answers
@OracleRACpm hWp://www.linkedin.com/in/markusmichalewicz hWp://www.slideshare.net/MarkusMichalewicz