Agenda

Tudi prejšnje leto smo imeli virtualno konferenco, ki se je odvijala čez cel teden, zato smo jo poimenovali MakeIT Week. Letos smo se odločili za drugačen format. Namesto dveh dni z več vzporednimi predavanji, bomo imeli več enodnevnih ali dvodnevnih dogodkov. Vsi ti dogodki bodo v jeseni, zato ime MakeIT Autumn.

Starting with 12c Release 1, Oracle introduced a completely new architecture concept for its database - the Container Database.

With this new architecture, new challenges came up but with the same breath a wide branch of new opportunities.

The presentation will address the capabilities to create fast and easy new (test) databases or clones for a running production database. Five different ways will be discussed.

• Using Local and Remote Cloning

• Using an Unplugged PDB (predefined master)

• Using Refreshable PDBs as a master for new (test) databases

• Using Data Guard for a limited number of PDBs and its Snapshot Standby capabilities

• Snapshot Carousel

Another point of the agenda is the usage of the Snapshot features of ACFS and Direct NFS to speed up the creation process.

At the end of the presentation, a comparison of the advantages and disadvantages of each technique will be presented.

Author's biography

Christian Gohmann is currently working as Principal Consultant and Instructor at Trivadis Germany GmbH in Dusseldorf, Germany. His main focus lies in helping customers in the areas of architecture planning, implementation, and migration - with a specialization on high availability solutions, like Data Guard, Oracle RAC.

Since 2006, Christian Gohmann is working with Oracle and the Oracle Database and was part of a huge amount of different projects for customers in the German-speaking areas.

Besides his consultancy activities, he is the main developer and the responsible person for TVD-Backup - a product distributed by Trivadis, which is responsible for the intelligent backup and recovery of an Oracle database.

In his spare time, he shares his knowledge on his blog https://www.christian-gohmann.de and spends as much time as possible with his two dogs Susi and Taran and for his hobbies climbing/bouldering, hiking, and watching movies.

Have you every heard from Oracle Support “It will be fixed in 21c or 23c”? And wondered if you should upgrade now, and how you should upgrade when the release is not there yet?

In this talk we will give rare insights into how Oracle Database Development works.

We will explain why it takes more than a few minutes to complete a regression test suite, why you don’t get one-off patches on Windows - and why you need a backport to have “this” issue fixed on 19.11.0.

We are fully aware that you will need some beer to relax - and that everybody has a story to tell. Our focus will be to shed some light on the black box “Oracle Database Development” to get you a better understanding why things work as they work - and why miracles happen not every day but sometimes take longer.

Author's biography

Based in Bavaria, Germany. 30 years IT experience. Holding a degree as Graduate Engineer (Dipl. Ing. NT/DT) in

Data Systems and Information Technology of Georg-Simon-Ohm Technical University, Nürnberg, Germany.

Distinguished Product Manager for Oracle Database Upgrade and Migrations, patching specialist, working for Oracle for almost 25 years. Interlink between customers/partners and the Oracle Upgrade Development. Holding technical workshops between Arctic and Antarctica. Assisting customers in their reference projects onsite and remotely worldwide. Troubleshooting upgrade and migration issues. Eager to learn something new every day. Experienced conference speaker. Music lover. LP/vinyl enthusiast. Mountain hiker. Cyclist.

Find more information on Mike's blog: https://MIkeDietrichDE.com

NewSQL databases bring powerful SQL and ACID features to the same scalability as NoSQL datastores. Data is distributed to many active nodes, sharded and replicated, in sync, to the region's data centers for high availability, or geo-distributed to reduce latency for worldwide users. And with operations automated, it is finally possible to bring elasticity to the persistence layer: the database can run on Kubernetes pods, with auto-scaling. You can add or remove nodes and the distributed database manages the distribution of data.

This session explains one of them: YugabyteDB which is fully compatible with PostgreSQL, with the same wire protocol, mostly all SQL and pl/pgSQL features, and the same Open Source license. With a live demo and a whiteboard, we will explain how it was built, re-using the PostgreSQL code on top of a distributed document database. And show which use-cases it addresses: modern applications in microservices where the database must accept multiple APIs, and high availability must be easy. Cloud, Hybrid, or on-premises clusters.

Author's biography

Franck is passionate about all databases. After 20 years of consulting on traditional databases (Oracle Certified Master / ACE Director as well as AWS Data Hero and certified educator) he is now a developer advocate for Yugabyte, a NewSQL open-source distributed database full PostgreSQL-compatible. Franck loves to learn and share in technical communities, very active on Twitter (@FranckPachot) and multiple blogs (http://blog.pachot.net/)

As database professionals we are the custodians of our organisations data and the event of any data related issue are usually one of the first Data Heroes on the scene.

As Guardians of the Data we need to constantly review and reduce our exposure to malware and other threats, by adopting a multi-level approach to data protection we can give ourselves the best possible protection.

In this presentation I will discuss the need for a multi-layered approach and share some of the steps we can take to protect our backups from ransomware attacks and malicious intent.

I will share code and examples of the steps need to avoid becoming headline news across the globe.

Author's biography

Ron is an Oracle ACE Director and certified Cloud and Enterprise Architect with over 30 years Oracle experience in development, database administration and the architecture and delivery of large IS solutions. Ron is an active member of the Oracle community, and regular presenter at technology conferences across the globe

Heard about the AWS BabelFish project? Can we do the same with Oracle: an Oracle wire-protocol endpoint, an engine to run the SQL and PL/SQL, without the cost of an Oracle database, and without the Oracle XE limitations? Let’s try to run Swingbench, without any code change or even re-compilation, on a free alternative to Oracle database. With only free components (Oracle XE as a scalable stateless front-end to the Oracle wire-protocol and PL/SQL engine, ODBC Gateway to PostgreSQL for the shared persistent data). This presentation and demo is also an open discussion on the components involved: Oracle XE, SQL Translation Framework, Triggers, DB Links, Heterogenous Services, ODBC Gateway, PostgreSQL Foreign Data Wrapper…

Author's biography

Franck is passionate about all databases. After 20 years of consulting on traditional databases (Oracle Certified Master / ACE Director as well as AWS Data Hero and certified educator) he is now a developer advocate for Yugabyte, a NewSQL open-source distributed database full PostgreSQL-compatible. Franck loves to learn and share in technical communities, very active on Twitter (@FranckPachot) and multiple blogs (http://blog.pachot.net/)

In this session, I will talk about the latest and most common techniques used by hackers to gain access, escalate privileges, degrade the performance and/or deploy malware staying silently inside an Oracle Database (Cloud or On-Premises), and how can we protect against those attacks.

I will explain Oracle Rootkits, how do they work and how to eliminate them. The presentation includes Oracle Man-In-the-Middle attacks, best practices and methodologies for protecting your database and also what are the new security features being developed by Oracle.

Author's biography

Rodrigo Jorge is a Product Manager in Database Migrations, Upgrades, Patching & Utilities team. He is also a security-enthusiastic DBA, OCM certified, ex Enkitec and ex Oracle ACE Director with more than 15 years of industrial experience in Oracle high end technologies.

Have you done some database upgrades already? But on the command line or with DBUA? Or just plain export/Import?

Today we'll make you an AutoUpgrade expert in 45 minutes. You'll get to see and hear everything you need to know to complete successful databases upgrades. You don't have to become an expert as upgrades can be very simple. AutoUpgrade will be your vehicle - and you can do dozens and hundreds of upgrades fully unattended.

We will guide you. And this won't be the usual "all is great" marketing presentation. We will show a demo and equip you with the perfect best practices to make your database upgrade a total success.

Author's biography

Based in Bavaria, Germany. 30 years IT experience. Holding a degree as Graduate Engineer (Dipl. Ing. NT/DT) in

Data Systems and Information Technology of Georg-Simon-Ohm Technical University, Nürnberg, Germany.

Distinguished Product Manager for Oracle Database Upgrade and Migrations, patching specialist, working for Oracle for almost 25 years. Interlink between customers/partners and the Oracle Upgrade Development. Holding technical workshops between Arctic and Antarctica. Assisting customers in their reference projects onsite and remotely worldwide. Troubleshooting upgrade and migration issues. Eager to learn something new every day. Experienced conference speaker. Music lover. LP/vinyl enthusiast. Mountain hiker. Cyclist.

Find more information on Mike's blog: https://MIkeDietrichDE.com

Autonomous Database Shared, Dedicated, Exadata Cloud Services, Database Cloud Services VM and Bare Metal... A full portfolio of cloud database services! But how do all these services implement high availability? Where are the backups stored? Is it possible to configure Data Guard? Are they protected by Oracle RAC? And what are the limitations?

The Oracle Cloud Infrastructure is introducing new features every day in this regard, but keeping track of the current status is not easy. In this session, I will explain what the current status is and how customers can further improve the protection of their data in the cloud.

Author's biography

Member of the Oracle Database High Availability (HA), Scalability & Maximum Availability Architecture (MAA) Product Management team in Oracle, Ludovico takes care of Fleet Patching and Provisioning, Cloud MAA, and Online Reorganization solutions.

Before joining Oracle, Ludovico has been DBA, consultant, and trainer for Oracle customers and partners for over twenty years, with a special focus on Oracle Database and high availability architectures. Awarded with the Oracle ACE Director status between 2016 and 2020, Ludovico is a respected figure in the Oracle Users Community.

The current trends to work in Agile and DevOps modes are bringing some challenges for database developers. Source control and build automation is almost a standard for non-database development but it’s still a challenge for database related development – like schema definition or packages code. In addition to that, databases have one more variable – data itself.

Source control and automation can address code and schema problems but the missing point is data control and the possibility to quickly rollback data to a point in time to repeat a test or just revert an unexpected damage caused by bug in the code.

The first part of this talk will be focused on presentation of tools helping developers and DBAs to understand and use a git as a source control for database development. It will show how DBA’s can use Liquibase, Flyway, DDLFS in the reactive and proactive mode to track changes on databases and detected code changes.

The second part will try to address the problem of data control in the individual developer or tester environments and how it can be resolved by using different tools or techniques provided by Oracle (like PDB snapshot) or by external software or hardware.

Author's biography

I'm working with Oracle technology stack since 2001. I'm interested in three areas - automation, DevOps, high availability (DataGuard, RAC, etc) and performance monitoring and troubleshooting. For last 10 years I'm involved in OUG community and blogger community. I'm a proud member of OakTable.

Kakšna je prihodnost Oracle baze podatkov na najboljši način predstavlja Oracle Autonomous Database. Oracle Autonomous je v osnovi relacijska baza, transakcijska ali kompresirana kolumnar In-Memory oblika, z dodatno podporo za nove oblike razvoja aplikacij. Nove oblike razvoja aplikacij so poleg relacijskega modela, še dokumentne, na JSON strukturi bazirane baze podatkov, ki olajšajo razvoj in spremembo modela podatkov ter Graph baze, ki prinašajo popolnoma svoj način analize povezav med podatki.

Oracle Autonomus je vse to - relacijska, JSON, Graph, Spatial, In-Memory, kolumnar baza z vgrajeno podporo za avtomatsko strojno učenje (AutoML ) in REST dostopom do tabel in PL-SQL procedur ter paketov.

Na predavanju si bomo ogledali delovanje Oracle Autonomous baze podatkov in primere uporabe JSON, Graph, AutoML, REST, kolumnar podsistemov.

Author's biography

Robert Korošec je od leta 1999 je zaposlen v podjetju Oracle Software, kjer je delal kot svetovalec za Oracle baze podatkov in Oracle Exadata sisteme.

V zadnjem času se osredotoča na Oracle Cloud platformo, primarno na področju Oracle Autonomous Database, prediktivne analitike ter BigData analizo podatkov.

… iz uporabniške, kernelove in libc perspektive.

Pogledali si bomo Linux I/O arhitekturo, pri čemer bomo poudarili nekaj specifičnih konceptov, kot sta “page cache” in “read ahead”. Pogledali si bomo tudi “direct i/o” ter uporabo asinhronega i/o z uporabo knjižnic “aio” in “uring”. Predavanje bo opremljeno tudi s primeri C izvorne kode. Programerji bodo dobili namige, kako izkoristiti, kar ponuja Linux; DBA in sistemci pa morda idejo, kako se lotiti raziskovanja naslednje I/O težave, ki jo bodo srečali.

Author's biography

Urh Srečnik je DBA v Abakus Plus d.o.o. (http://www.abakus.si/), kjer skrbi za Oracle infrastrukturo in razvija Abakusovo rešitev za hitro kreiranje živih klonov produkcijskih podatkovnih zbirk: Deja Vu (https://www.abakus.si/sl/produkti/programska_oprema/dejavu)

Oracle Fleet Patching and Provisioning is a robust, reliable, automated, and fleet-capable solution that orchestrates the install, patching, and upgrade of Oracle Grid Infrastructure and Oracle Databases. How does it work? What are the building blocks? How does the communication between client and server happen? How are the software homes transferred and stored? How are databases patched?

In this session, I will answer all these questions and give you a clear understanding of Fleet Patching and Provisioning architecture.

Author's biography

Member of the Oracle Database High Availability (HA), Scalability & Maximum Availability Architecture (MAA) Product Management team in Oracle, Ludovico takes care of Fleet Patching and Provisioning, Cloud MAA, and Online Reorganization solutions.

Before joining Oracle, Ludovico has been DBA, consultant, and trainer for Oracle customers and partners for over twenty years, with a special focus on Oracle Database and high availability architectures. Awarded with the Oracle ACE Director status between 2016 and 2020, Ludovico is a respected figure in the Oracle Users Community.

Discussion of design patterns and best practices for NoSQL Data Modeling used by Amazon to migrate 10K production workloads from RDBMS and deprecate 3K Oracle server instances. Delivered by the former head of the NoSQL Blackbelt team at AWS which was responsible for defining these patterns and educating over 25K global Amazon developers, this lecture dispels common myths and misconceptions and describes how to efficiently model relational data and properly leverage denormalization in a NoSQL database.

Author's biography

I run the NoSQL Blackbelt team at AWS and for the last 5 years have been responsible for consulting with and on boarding the largest and most strategic customers our business supports. My role spans technology sectors and as part of my engagements I routinely provide guidance on industry best practices, distributed systems implementation, cloud migration, and more. I led the architecture and design effort at Amazon for migrating thousands of relational workloads from Oracle to NoSQL and built the center of excellence team responsible for defining the best practices and design patterns used today by thousands of Amazon internal service teams and AWS customers. I currently work on the DynamoDB service team as a Principal Technologist focused on building the market for our NoSQL services through design consultations, content creation, evangelism, and training.

30+ years of software and IT expertise.

9 patents in Cloud Virtualization, Complex Event Processing, Root Cause Analysis, Microprocessor Architecture, and NoSQL Database technology.

Any piece of code is susceptible to malicious modifications, and PL/SQL code is not immune to it. In this session you will learn how to detect and clean unwanted changes in your Oracle Database core objects, highlighting security tools that can be used to track and detect such changes. Get a comprehensive understanding of how attackers explore Oracle's products and how you can use Oracle provided security tools to create an effective defense.

Author's biography

Rodrigo Jorge is a Product Manager in Database Migrations, Upgrades, Patching & Utilities team. He is also a security-enthusiastic DBA, OCM certified, ex Enkitec and ex Oracle ACE Director with more than 15 years of industrial experience in Oracle high end technologies.