oracle technology monthly
TRANSCRIPT
Copyright © 2017, Oracle and/or its affiliates. All rights reserved. Oracle Technology Monthly | BU Core & Cloud Technologies 1
Oracle Technology Monthly April 2017
Sebastian Solbach BU Core & Cloud Technologies Oracle Deutschland B.V. & Co KG
Beginn um 14:00
Audioübertragung über Ihre PC-Lautsprecher
Audio => Integrate Voice Conference
=> Join Conference
Copyright © 2017, Oracle and/or its affiliates. All rights reserved. Oracle Technology Monthly | BU Core & Cloud Technologies 2
Agenda
Cloud & Tech Neuigkeiten: Announcements, Referenzen etc.
Termine
Release Stand, Patchsets
Feature des Monats
Web 2.0
1
2
3
4
5
Copyright © 2017, Oracle and/or its affiliates. All rights reserved. Oracle Technology Monthly | BU Core & Cloud Technologies 3
IaaS Cloud News*
• Unterstützung CentOS/Ubuntu
• RHEL 6/7 lift and shift
• Unterstützung Terraform
• Windows Bring-Your-Own License
• Storage Cloud: Neues WebInterface
• NVMe SSDs
• SOC Compliance
• RAC & ExaCS auf Bare Metal
*gilt nicht für alle Services/Regionen
Copyright © 2017, Oracle and/or its affiliates. All rights reserved. Oracle Technology Monthly | BU Core & Cloud Technologies 4
Compute Cloud*
• Orchestration 2.0: Verwaltung mehrerer Instanzen über ein einzelnes JSON (Create/Restore/Backup/Recovery)
• Instance Lifecycle Management
• Delayed Instance Snapshot (Windows SYSPREP)
• Cloud IPs
• Restore Snapshot über Regionsgrenzen hinweg
• Bessere Netzwerkkonfiguration (mehrere IPs)
*gilt nicht für alle Services/Regionen
Copyright © 2017, Oracle and/or its affiliates. All rights reserved. Oracle Technology Monthly | BU Core & Cloud Technologies 5
Windows: Oracle Database 12c Release 2
• Release am 16. März für Windows
• Download für Linux x86-64, Solaris Sparc, Solaris x86-64 und Windows
• VM Templates für Linux
• Offizielle Informationen Release Schedule (MOS Doc ID 742060.1)
Copyright © 2017, Oracle and/or its affiliates. All rights reserved. Oracle Technology Monthly | BU Core & Cloud Technologies 6
Oracle Database 12c Release 2 - Informationen
• Handbücher – docs.oracle.com/database/122/nav/portal_booklist.htm
– Database Upgrade Guide
– New Features Guide
– Licensing Information User Manual mit Permitted Features, Options und Management Packs
Copyright © 2017, Oracle and/or its affiliates. All rights reserved. Oracle Technology Monthly | BU Core & Cloud Technologies 7
ORACHK 12.2.0.1.3
• ORACHK Standalone & Identity Management Plugin
• Oracle Health Check Katalog
• Prechecks für 12.2 Upgrade
– Betriebssystem, GI/DB Patches, DB Konfiguration, Cluster Konfiguration
• Performance Best Practices (12c Optimizer, SQL Plan Management)
– High Memory, CPU Usage, Cursor Usage
• Collection Manager Email Benachrichtigung
• Dokumentation:
docs.oracle.com/cd/E68491_01/OEXUG/toc.htm
Copyright © 2017, Oracle and/or its affiliates. All rights reserved. Oracle Technology Monthly | BU Core & Cloud Technologies 8
Oracle Data Provider for .NET Support
• Statement of Direction
– Unterstützung Ende 2017
– > .NET Core 2.0
www.oracle.com/technetwork/topics/dotnet/tech-info/odpnet-dotnet-core-
sod-3628981.pdf
Microsoft .NET Core
Copyright © 2017, Oracle and/or its affiliates. All rights reserved. Oracle Technology Monthly | BU Core & Cloud Technologies 9
Agenda
Cloud & Tech Neuigkeiten: Announcements, Referenzen etc.
Termine
Release Stand, Patchsets
Feature des Monats
Web 2.0
1
2
3
4
5
Copyright © 2017, Oracle and/or its affiliates. All rights reserved. Oracle Technology Monthly | BU Core & Cloud Technologies 10
Oracle 12.2 Webcast
• 24. März Oracle 12.2 OnPremise WebCast
– Replay auf unserer Youtube 12.2 Playliste Replay: youtu.be/cgI5yYTtmLw
Folien: apex.oracle.com/folien Stichwort: ora122
• Weitere Termine: Immer Freitags um 11:00 oraclemeetings.webex.com
– 07.04. Security (Meeting number 591 909 494)
– 21.04. Hochverfügbarkeit (Meeting number 591 909 494)
– 05.05. Multitenant (Meeting number 591 909 494)
– 19.05. Database Development (Meeting number 591 909 494)
Copyright © 2017, Oracle and/or its affiliates. All rights reserved. Oracle Technology Monthly | BU Core & Cloud Technologies 11
Oracle Code
• 24. April 2017
• Estrel Congress Center in Berlin
– Spannende Vorträge
– Hands-on Labs zum Mitmachen Docker Containers und Oracle Bare Metal Cloud
– IoT Workshops
– Code Cast
developer.oracle.com/code/berlin
Agenda Online
Copyright © 2017, Oracle and/or its affiliates. All rights reserved. Oracle Technology Monthly | BU Core & Cloud Technologies 12
Termine
• 8. - 12. Mai: JAX (Java, Architektur & Softwareinnovation) in Mainz https://jax.de/
• 9. - 11. Mai: APEX Connect in Berlin https://apex.doag.org/de/home/
• 17. Mai: DOAG Regio: ASM und RAC in München https://www.doag.org/de/event/eventdetails/530960
• 30. - 31. Mai 2017: DOAG Datenbank in Düsseldorf http://datenbank.doag.org
• 20. Juni: DOAG 2017: Exaday in Frankfurt-Mörfelden https://www.doag.org/de/event/eventdetails/531456
DOAG, Oracle Events in Ihrer Nähe, Internationale Events
Copyright © 2017, Oracle and/or its affiliates. All rights reserved. Oracle Technology Monthly | BU Core & Cloud Technologies 13
Termine
• bis 23. April: Call for Paper Oracle Open World 01. – 05. Oktober https://reg.rainfocus.com/flow/oracle/oow17/cfp/cfpHome
• Bis 1. Juni: DOAG Konferenz 2017 Call for Papers: https://2017.doag.org
Call for Papers
Copyright © 2017, Oracle and/or its affiliates. All rights reserved. Oracle Technology Monthly | BU Core & Cloud Technologies 14
Agenda
Cloud & Tech Neuigkeiten: Announcements, Referenzen etc.
Termine
Release Stand, Patchsets
Feature des Monats
Web 2.0
1
2
3
4
5
Copyright © 2017, Oracle and/or its affiliates. All rights reserved. Oracle Technology Monthly | BU Core & Cloud Technologies 15
Aktuelle Software Release und Patchstände
Komponente Patch (PSU) Patch (DBPro) MOS Note ID
Datenbank 12.2.0.1 12.1.0.2 11.2.0.4
.170117 .161018
.170117 .161018
161818.1 / 1454618.1
Eng. Systems Exadata Storage/OEDA
12.2.1.1.0 12.1.2.3.4
v17.044 888828.1
ODA 12.1.2.10.0 888888.1 / 2144642.1
MiniCluster 1.1.25.4 2153282.1
Enterprise Manager
13.2.0.0 / Agent 13.1.0.0 / Agent 12.1.0.5 / Agent
.170117 .170117
.170228
.170117
.170331
2219797.1 2124038.1 2038446.1
Copyright © 2017, Oracle and/or its affiliates. All rights reserved. Oracle Technology Monthly | BU Core & Cloud Technologies 16
Aktuelle Software Release und Patchstände
Komponente Version Link / MOS Note ID
Dev Resources SQL Developer 4.1.5.21.78 http://www.oracle.com/technetwork/developer-
tools/sql-developer/downloads
SQLcl 4.2.0.17
ORDS 3.0.9 http://www.oracle.com/technetwork/developer-
tools/rest-data-services/downloads/index.html
Node.js 1.13 https://github.com/oracle/node-oracledb
Oracle NoSQL 4.3.11 http://www.oracle.com/technetwork/database/database
-technologies/nosqldb/downloads/index.html
Checks ORACHK / EXACHK 12.2.0.1.3 1268927.1
TraceFileAnalyzer 12.1.2.8.4 1513912.1
Linux Oracle Linux (OL) 6.9, 7.3, UEK 4 http://www.oracle.com/technetwork/server-
storage/linux/overview/index.html
Oracle VM (OVM) 3.4.7 http://www.oracle.com/us/technologies/virtualizatio
n/oraclevm/specifications/index.html
Copyright © 2017, Oracle and/or its affiliates. All rights reserved. Oracle Technology Monthly | BU Core & Cloud Technologies 17
Agenda
Cloud & Tech Neuigkeiten: Announcements, Referenzen etc.
Termine
Release Stand, Patchsets
Feature / Thema des Monats
Web 2.0
1
2
3
4
5
Copyright © 2017, Oracle and/or its affiliates. All rights reserved. Oracle Technology Monthly | BU Core & Cloud Technologies 18
Stretch Cluster in 12.2
Copyright © 2017, Oracle and/or its affiliates. All rights reserved. Oracle Technology Monthly | BU Core & Cloud Technologies 19
• Kein C++ Kompiler mehr notwendig
• Separation of Duty: SYSRAC
• Vereinfachte Cluster Installation
– Unzip + ./gridSetup.sh
– ASM Filter Driver Integration
– separate ASM Diskgroup für GI Management Repository
– Stretch Cluster Setup und Definition
12.2 RAC Installation
Copyright © 2017, Oracle and/or its affiliates. All rights reserved. Oracle Technology Monthly | BU Core & Cloud Technologies 20
Stretch Cluster
• Installation ist Stretch Cluster Aware
– Cluster Setup im Extended Modus
– Knoten, Failgroups werden „Site“ Aware
• Neues „Extended“ Attribut für Flex Disk Gruppen – Diskgruppen mit “Extended Redundancy” sind Site-Aware
– Extended Disk Groups unterstützen mehrere Voting Disks Failgroups
Copyright © 2017, Oracle and/or its affiliates. All rights reserved. Oracle Technology Monthly | BU Core & Cloud Technologies 21
Stretch Cluster Setup bis 12.1
Copyright © 2017, Oracle and/or its affiliates. All rights reserved. Oracle Technology Monthly | BU Core & Cloud Technologies 22
Voting Disk Konfiguration
Stretch Cluster Setup bis 12.1
Quorum VD3
VD1 VD2
Copyright © 2017, Oracle and/or its affiliates. All rights reserved. Oracle Technology Monthly | BU Core & Cloud Technologies 23
Voting Disk Konfiguration
Stretch Cluster Setup bis 12.1
Quorum VD3
VD1 VD2 ?
?
Copyright © 2017, Oracle and/or its affiliates. All rights reserved. Oracle Technology Monthly | BU Core & Cloud Technologies 24
Voting Disk Konfiguration
Stretch Cluster Setup 12.2
Quorum VD7
VD1 VD2 VD3 VD4 VD5 VD6
Copyright © 2017, Oracle and/or its affiliates. All rights reserved. Oracle Technology Monthly | BU Core & Cloud Technologies 25
Flex Diskgruppe & Extended Redundancy
• COMPATIBLE.ASM und COMPATIBLE.RDBMS 12.2
• Datei „Redundancy“ multipliziert bei Anzahl Sites
• Gleiche Anzahl Failure Gruppen pro Site
• Allocation Unit 4M
• 3 Sites notwendig
• Toleriert Ausfall einer Site + 2 FG
• Keine Konvertierung in Extended möglich
• REQUIRED_MIRROR_FREE_MB keine Aussagekraft
Flex Disk Group
DB1 File 1 File 2 File 3
DB2 File 1 File 2 File 3 File 4
DB3 File 1 File 2 File 3
File Group Database-oriented
storage management
Copyright © 2017, Oracle and/or its affiliates. All rights reserved. Oracle Technology Monthly | BU Core & Cloud Technologies 26
Konvertierung eines Cluster
• FLEX Diskgruppe muss neu angelegt werden
• Datendateien können bei 12.2 Online migriert werden
• Zuweisen der einzelnen Knoten zu Sites
http://docs.oracle.com/database/122/CWLIN/extending-a-cluster-after-
upgrading-grid-infrastructure.htm
rootcrs.pl -converttoextended -first -sites list_of_sites
-site node_site
Copyright © 2017, Oracle and/or its affiliates. All rights reserved. Oracle Technology Monthly | BU Core & Cloud Technologies 27
Agenda
Cloud & Tech Neuigkeiten: Announcements, Referenzen etc.
Termine
Release Stand, Patchsets
Feature des Monats
Web 2.0
1
2
3
4
5
Copyright © 2017, Oracle and/or its affiliates. All rights reserved. Oracle Technology Monthly | BU Core & Cloud Technologies 28
#OraCloudNow Videos
tinyurl.com/OraCloudNow
• Oracle Cloud Now (#OraCloudNow) Videos online
– Data Management - Betreiben von Oracle Datenbanken in der Cloud
– Infrastructure as a Service - Baremetal, mit Volldampf in die Cloud
– Cloud Native - Development in der und für die Cloud
– Cloud Integration - Mehr Nutzen aus SaaS Applikationen ziehen
– SSO, Berechtigungen, Benutzermanagement - Security aus der Cloud?
– 10. April: IT in der Cloud - Verwaltung in der Cloud
– 17. April: Cloud@Customer - die Cloud für zu Hause
– Youtube Channel: www.youtube.com/channel/UCqQ-xAY8EC-MjryFITpjPzw
Copyright © 2017, Oracle and/or its affiliates. All rights reserved. Oracle Technology Monthly | BU Core & Cloud Technologies 29
Web 2.0
• Oracle Database 12c Release 2 (12.2) Installation On Oracle Linux 6 (OL6) and 7 (OL7) https://oracle-base.com/articles/12c/oracle-db-12cr2-installation-on-oracle-linux-6-and-7
• Community Beiträge zu Oracle 12c Release 2 https://blogs.oracle.com/dbacommunity_deutsch/entry/oracle_database_12c_release_21
• Neue Oracle Database Appliance Videos Step-by-Step Anleitungen https://community.oracle.com/docs/DOC-888971?et=watches.email.document_comment#comment-1003391
• ODA Referenz Video: Afibel boosts database performance 80% with ODA https://www.youtube.com/watch?v=M5Ju80k4xtk
• Vorsicht: Update des Oracle Blogs
Blogs, Whitepaper, YouTube, Twitter, …
Copyright © 2017, Oracle and/or its affiliates. All rights reserved. Oracle Technology Monthly | BU Core & Cloud Technologies 30
Nächste Ausgabe: 03.Mai 2017 – 14:00 Uhr tinyurl.com/oratech-monthly
Fragen und Diskussionen auf Twitter
#oratechmonthly
[email protected] Twitter: @s2solbach Blog: http://blogs.oracle.com/dbacommunity_deutsch Twitter: @oraclebudb
Redaktion: Sebastian Solbach (@s2solbach) Manuel Hoßfeld Ulrike Schwinn (@uschwinn)