DOAG Conference 2019

As every year, the DOAG conference in Nürnberg takes place in November. This year I am represented with a presentation about Oracle PDB protection and isolation as well a presentation about testing database features with Docker containers. Additionally I hold a workshop about Oracle databases in Docker containers on the training day.

Conference

Titel Testing database features with Docker containers

Scheduled Tuesday, 19. Nov., 16:00 – 16:45

Abstract As a DBA you are always faced with the situation of checking a feature or bug in a new database version. But this does not usually require a dedicated database environment. Many tests can be performed quickly and easily in Oracle databases in Docker Containers. In combination with Docker Compose and corresponding scripts, an appropriate environment can be set up within minutes. After a short introduction to Oracle databases in Docker Container, practical examples and demos will show how the DBA can simplify tests and troubleshooting with this method. This includes: verification of bugs in different DB versions, troubleshooting EUS, verification of PSU or RU and others.

Titel Oracle PDB protection and isolation

Scheduled Thursday, 21 Nov., 13:00 – 13:45

Abstract The same principles and measures of database security can be implemented in container databases as in normal single-tenant environments. However, if the container databases are to be used securely by various tenants with more or less high system privileges, additional security measures are required. Especially if access to the operating system is granted directly or indirectly with JVM, external tables, scheduler jobs or directories. The aim of this presentation is to evaluate database security in the focus of container databases and to discuss appropriate measures. This includes the use of lockdown profiles, PDB_OS_CREDENTIALS and various other measures and features. Where useful, the presentation is complemented by appropriate examples and demos. As far as possible, it is also shown how Oracle handles these problems in its cloud solutions (e.g. Autonomous Database).

Training day

Titel Workshop Oracle Databases in Docker Containers

Scheduled Friday, Nov 22nd, 09:00 – 17:00

Abstract Oracle has long supported the use of Docker to install its products, including the latest versions of the Oracle database. In theory, a simple “docker run” instantiates a container from a docker image. But why isn’t the database container ready in a few seconds? Where does my Oracle database image come from and what happens if the container is stopped again? The functional scope as well as the size of the Oracle database container presuppose that one or the other thoughts about the use and operation are made in advance. This includes topics such as data persistence, licensing and other operational aspects. Within the scope of this training we develop how Oracle databases can be installed in a Docker image, configured and then operated as corresponding containers.

See you at the DOAG in Nürnberg.