Oracle Technology Monthly Dezember 2016
Sebastian Solbach Beginn um 14:00
BU Core & Cloud Technologies Oracle Deutschland B.V. & Co KG
Audioübertragung über Ihre PC-Lautsprecher Audio => Integrate Voice Conference => Join Conference
Oracle Technology Monthly | BU Core & Cloud Technologies
Copyright © 2016, Oracle and/or its affiliates. All rights reserved.
1
Agenda 1
Neuigkeiten: Announcements, Referenzen etc.
2
Termine
3
Release Stand, Patchsets
4
Feature des Monats
5
Web 2.0
Oracle Technology Monthly | BU Core & Cloud Technologies
Copyright © 2016, Oracle and/or its affiliates. All rights reserved.
2
Database Cloud Service • Oracle Datenbank 12.2 • Generell: July PSU • Update Cloud Tooling
• OCPU für RAC verringert • Dokumentation 12.2: http://docs.oracle.com/database/122/index.htm
• Lizenzguide: Oracle Cloud Services for Oracle DB http://docs.oracle.com/database/122/DBLIC/Licensing-Information.htm#DBLIC-GUID-F796455DC7EF-4836-9F69-2BCCDA49B7BD
Oracle Technology Monthly | BU Core & Cloud Technologies
Copyright © 2016, Oracle and/or its affiliates. All rights reserved.
3
Cloud Platform für Anwendungsentwicklung Übersicht • Java Cloud Service – Ablauf von WebLogic Applikationen in der Cloud • Application Container Cloud Service – Ablauf von Cloud Native Anwendungen mit vorkonfektionierten Containern
• Container Cloud Service – von Oracle bereitgestelltes Container Orchestration Tooling • Compute Cloud Service – Eigene Docker Orchestrierung
Node.js
Any Container
DIY
PHP
Java EE
App. Container CS
Java CS
Java
Container CS
WebLogic
Compute Cloud Service
Oracle Technology Monthly | BU Core & Cloud Technologies
Copyright © 2016, Oracle and/or its affiliates. All rights reserved.
4
Oracle Cloud Update November • Java Cloud Service – Auto-Scaling – SSH Key Erzeugung während der Provisionierung – AppToCloud aus WebLogic transferiert/ändert JMS und Java Mail Resources automatisch mit in die Java Cloud
• Container Cloud Service
Oracle Technology Monthly | BU Core & Cloud Technologies
Copyright © 2016, Oracle and/or its affiliates. All rights reserved.
5
Application Container Cloud Service Polyglotte Applikations-Entwicklungs Plattform • vorkonfigurierte Umgebung für Java SE, Node.js & PHP Anwendungen • Enthält Java SE Advanced Features (Java Flight Recorder, Java Mission Control, Advanced Memory Management) + Sicherheitsupdates • Offene Plattform für alle Java Frameworks & Container, wie Spring, Play, Tomcat, Jersey • Unterstützung für Java Virtual Machine (JVM) basierte Spachen, wie JRuby • Alle Sprachen, die eine JVM nutzen, können auf diesem Service laufen • Support von Oracle • Zugang über Webbasierte Benutzeroberfläche sowie REST APIs https://cloud.oracle.com/en_US/application-container-cloud
Oracle Technology Monthly | BU Core & Cloud Technologies
Copyright © 2016, Oracle and/or its affiliates. All rights reserved.
6
Application Deployment
Java Image
Node Image
Language Runtimes Docker Image Repository
Application Image Private Tenant Docker Image Repository
Developer
Image Builder Application Archive
Load Balancer
Java SE Docker
Oracle Technology Monthly | BU Core & Cloud Technologies
Node
Ruby
Docker
Docker
Copyright © 2016, Oracle and/or its affiliates. All rights reserved.
7
Management Cloud: Infrastructure Monitoring • Überwachung aller Systeme – In der Cloud und On-Premise – SLA Überwachung – Korrelation von Performance Metriken – Topology Übersichten – Metriken (vorgegeben, benuzterdefiniert)
https://cloud.oracle.com/opc/paas/datasheets/OMC_InfraMon_Datasheet.pdf
Oracle Technology Monthly | BU Core & Cloud Technologies
Copyright © 2016, Oracle and/or its affiliates. All rights reserved.
8
Oracle Cloud: Compute IaaS Bare Metal
Elastic Compute
Container Service
Ravello
Dedicated Compute
Engineered Systems
Hypervisor
Hardware – Physical Servers & Storage Core Data Center & Access Network Data Center Regions & Availability Domains
Oracle Technology Monthly | BU Core & Cloud Technologies
Copyright © 2016, Oracle and/or its affiliates. All rights reserved.
9
Kundenbeispiel: Macy‘s (PaaS & IaaS) • Große Kaufhauskette in den USA (800 Geschäfte) • Optimierung & Analytische Plattform für Merchandising • PaaS -Oracle Exadata Cloud Service
• PaaS- Oracle Database Backup Cloud Service • Paas-Oracle VPN Cloud Service • IaaS-Oracle Cloud Compute Service http://medianetwork.oracle.com/video/player/5186557373001
Oracle Technology Monthly | BU Core & Cloud Technologies
Copyright © 2016, Oracle and/or its affiliates. All rights reserved.
10
Program Agenda 1
Neuigkeiten: Announcements, Referenzen etc.
2
Termine
3
Release Stand, Patchsets
4
Feature des Monats
5
Web 2.0
Oracle Technology Monthly | BU Core & Cloud Technologies
Copyright © 2016, Oracle and/or its affiliates. All rights reserved.
11
DOAG Jahreskonferenz 2016 Rückblende
• DOAG 2016 http://www.doag.org/home/aktuelle-news/article/doag-jahreskonferenz-informiert-ueber-cloud-security-und-support.html
– 2500 Teilnehmer – 470 Vorträge, 20 parallele Slots – 60 Aussteller – Vortragsunterlagen: https://2016.doag.org/index.php?id=664
• Vormerken: DOAG 2017: 21-24 November Oracle Technology Monthly | BU Core & Cloud Technologies
Copyright © 2016, Oracle and/or its affiliates. All rights reserved.
12
Termine DOAG, Oracle Events in Ihrer Nähe, Internationale Events
• 9. Dezember DOAG Webinar: Segregation of Duties • 12.-15. Dezember: IT-Tage in Frankfurt – Konferenz mit Themen wie: Datenbanken, Cloud Computing, Big Data, DevOps, … https://www.ittage.informatik-aktuell.de/
• 30.-31. Mai 2017: DOAG Datenbank – Vortrag einreichen:
http://datenbank.doag.org/de/referenten/
• 20. Juni 2017: DOAG Exaday – Call for Papers startet 16. Januar http://exaday.doag.org
Oracle Technology Monthly | BU Core & Cloud Technologies
Copyright © 2016, Oracle and/or its affiliates. All rights reserved.
13
Program Agenda 1
Neuigkeiten: Announcements, Referenzen etc.
2
Termine
3
Release Stand, Patchsets
4
Feature des Monats
5
Web 2.0
Oracle Technology Monthly | BU Core & Cloud Technologies
Copyright © 2016, Oracle and/or its affiliates. All rights reserved.
14
Aktuelle Software Release und Patchstände Komponente Datenbank
Eng. Systems
Enterprise Manager
Patch (PSU)
Patch (DBPro)
12.2.0.1*
MOS Note ID * nur Cloud
12.1.0.2
.161018
.161018
161818.1 / 1454618.1
11.2.0.4
.161018
Exadata Storage/OEDA
12.1.2.3.3
ODA
12.1.2.8.0/1
888888.1 / 2144642.1
MiniCluster
1.1.18.2
2153282.1
161818.1 / 1454618.1 v16.292
888828.1 / 2133207.1
13.2.0.0 13.1.0.0 / Agent
.161018
.161115
2124038.1
12.1.0.5 / Agent
.161018
.161130
2038446.1
Oracle Technology Monthly | BU Core & Cloud Technologies
Copyright © 2016, Oracle and/or its affiliates. All rights reserved.
15
Aktuelle Software Release und Patchstände Tools
Linux
Komponente
Version
Link / MOS Note ID
SQL Developer
4.1.5.21.78
http://www.oracle.com/technetwork/developertools/sql-developer/downloads
SQLcl
3. November
ORACHK / EXACHK
12.2.0.1.1
1268927.1
TFA
12.1.2.8.4
1513912.1
Oracle Linux (OL)
6.8 7.3 UEK 4
http://www.oracle.com/technetwork/serverstorage/linux/overview/index.html
Oracle VM (OVM)
3.4.2
http://www.oracle.com/us/technologies/virtua lization/oraclevm/specifications/index.html
Oracle Technology Monthly | BU Core & Cloud Technologies
Copyright © 2016, Oracle and/or its affiliates. All rights reserved.
16
Program Agenda 1
Neuigkeiten: Announcements, Referenzen etc.
2
Termine
3
Release Stand, Patchsets
4
Thema des Monats
5
Web 2.0
Oracle Technology Monthly | BU Core & Cloud Technologies
Copyright © 2016, Oracle and/or its affiliates. All rights reserved.
17
Oracle Aware Korruptionsschutz Eingebaute Datenvalidierung • Oracle Databenbank erkennt und repariert korrupte Blöcke – Physikalische Validierung zur Ermittlung Daten-,Redo-Block Korruption – Logische Intra-Block Validierung
– Validierung erkennt Lost Writes – In-Memory Korruption kann automatisch repariert werden
• Weitere Technologien zur Validierung – RMAN validiert während Backup und Recovery – ASM validiert gespiegelte Kopie – Data Guard macht kontinuierliche Lost-Write Validierung – Active Data Guard macht automatische Block Reparatur – Exadata hat HARD checks und weitere Background Checks auf den Storage Zellen
Oracle Technology Monthly | BU Core & Cloud Technologies
Copyright © 2016, Oracle and/or its affiliates. All rights reserved.
18
Schlüsselparameter Auf Active Data Guard Primary und Standby Datenbank • DB_BLOCK_CHECKSUM – Verhindert und korrigiert Physikalische Korruptionen
• DB_BLOCK_CHECKING – Verhindert und korrigiert Intra-Block Korruptionen
• DB_LOST_WRITE_PROTECT – Standby Datenbank erkennt “Stille” Korruption
• Overhead für den Check kann die Standby übernehmen • MOS Note 1302539.1
• DBA Community:
https://apex.oracle.com/pls/apex/germancommunities/dbacommunity/tipp/2121/index.html
Oracle Technology Monthly | BU Core & Cloud Technologies
Copyright © 2016, Oracle and/or its affiliates. All rights reserved.
19
Was wird geprüft DB_BLOCK_CHECKSUM DB_BLOCK_CHECKING DB_LOST_WRITE_PROTECT
FULL
TYPICAL/MEDIUM
OFF
Redolog + Datendateien
Datendateien
System Tablespace
~ 5% Overhead
~ 2% Overhead
Alle Objekte
Alle außer Indices
~ 1% - 10%
~ 1% - 10%
R/O und R/W Tablespaces
R/W Tablespaces
Oracle Technology Monthly | BU Core & Cloud Technologies
Nur System Tablespace Aus
Copyright © 2016, Oracle and/or its affiliates. All rights reserved.
20
Korruptionsschutz & Engineered System • Auf ODAs sind die Parameter per Default an! SQL> show parameter block_ch NAME -----------------------------------db_block_checking db_block_checksum
TYPE ----------string string
VALUE ---------------------FULL FULL
• Bei Exadata übernehmen die Storage Zellen erweiterte Prüfungen ohne Overhead auf dem Datenbank Server, daher FALSE und TYPICAL: – – – –
Redo & Block Checksummen Richtige Log Sequenz Block Type Validierung Disk Scrubbing
Oracle Technology Monthly | BU Core & Cloud Technologies
Copyright © 2016, Oracle and/or its affiliates. All rights reserved.
21
12.1.0.2 / 11.2.0.4: PrimaryLostWriteAction Was tun, wenn auf der Primärdatenbank ein Lost Write festgestellt wird
• CONTINUE (Default) • SHUTDOWN (kein Failover!) 12.1.0.2: • FAILOVER (FastStartFailoverLagLimit) • FORCEFAILOVER
Oracle Technology Monthly | BU Core & Cloud Technologies
Copyright © 2016, Oracle and/or its affiliates. All rights reserved.
22
Program Agenda 1
Neuigkeiten: Announcements, Referenzen etc.
2
Termine
3
Release Stand, Patchsets
4
Feature des Monats
5
Web 2.0
Oracle Technology Monthly | BU Core & Cloud Technologies
Copyright © 2016, Oracle and/or its affiliates. All rights reserved.
23
Web 2.0 Blogs, Whitepaper, YouTube, Twitter, … • Whitepaper Oracle Database In-Memory with Oracle Database 12c Release 2 https://t.co/ozAUVzcoAy
• Whitepaper : Oracle Multitenant: New Features In Oracle Database 12c Release 2 (12.2) https://t.co/3ZOsvkzwM5
• Übersicht der DOAG Vorträge „BU Core & Cloud Technologies“:
https://blogs.oracle.com/dbacommunity_deutsch/entry/doag_2016_vortr%C3%A4ge_der _oracle
Schulung: 12R2 Kurse:
http://education.oracle.com/pls/web_prod-plqdad/db_pages.getpage?page_id=641#database12c
Oracle Technology Monthly | BU Core & Cloud Technologies
Copyright © 2016, Oracle and/or its affiliates. All rights reserved.
24
Nächste Ausgabe: 11. Januar 2017 – 14:00 Uhr tinyurl.com/oratech-monthly
Fragen und Diskussionen auf Twitter
#oratechmonthly
[email protected]
Blog: http://blogs.oracle.com/dbacommunity_deutsch Twitter: @oraclebudb Oracle Technology Monthly | BU Core & Cloud Technologies
Redaktion: Sebastian Solbach (@s2solbach) Manuel Hoßfeld Ulrike Schwinn (@uschwinn) Copyright © 2016, Oracle and/or its affiliates. All rights reserved.
25
