Oracle ChatOps: How to Build a RESTful Service to Interact with Oracle Databases

April 21, 9:15 AM

ChatOps is an automation model connecting users and tools to processes through messaging applications. It leverages the simplicity and familiarity of chat to empower users to interact directly with applications and databases, retrieving information and performing work in real-time. Done right, ChatOps is a safe, agile way to minimize or eliminate tedious, repetitive operational tasks and reduce workloads. Virtually anything can be automated or called via ChatOps through simple commands—from self service password resets, to initiating reporting cycles, to running ad hoc refreshes of development environments—all without granting end users access to a database or application.

This session covers:
Connecting Oracle databases in the Cloud or on-premises to chat services via REST
Considerations for building database APIs to handle ChatOps interactions
Methods for securing communications between the database and application
Practical examples of ChatOps integrations

Advanced Docker Recipes: Building Complex Oracle Environments

April 21, 4 PM

Oracle provides a number of "vanilla" recipes in the Docker repository but these don't cover the needs of modern enterprises. This presentation discusses methods for creating images to support Data Guard, OEM, APEX, Sharding, rapid container deployments, Gold images, and transportable datasets. Participants will learn how to develop and customize Dockerfiles and orchestrations and apply them to their needs.

Improving Support Outcomes with Trace File Analyzer

April 22, 2:45 PM

Trace File Analyzer includes features and tools to help Oracle customers achieve improved outcomes when creating service requests and interacting with Oracle Support. Learn how to leverage these components to speed and automate creation of service requests, target collection for specific issues, and use the SQL Test Case Builder to assist Oracle Support investigations of database and performance issues. Participants will learn:

• How to use the advanced diagnostic features in TFA to create targeted collections based on specific conditions and events.

• Ways to connect TFA to MOS and upload files directly to Service Requests.

• How to use the SQL Test Case Builder to create and share performance incidents and reproduce problematic SQL on other databases.

• How to automate collections, create notifications, and view, package and manage RDA incidents from within TFA and Autonomous Health Framework.

Achieving Extreme Scalability, Availability, Tenancy, and Sovereignty with Sharding

April 23, 9 AM

Oracle Sharding is a technology for managing multiple, geographically dispersed databases in a shared-nothing architecture. Sharding is often associated with large, complex databases but that need not be the case. Based on Oracle Partitioning technology, sharding is a component of Oracle's Maximum Availability Architecture and boasts a rapidly growing user base. Its adoption is a result of the many database challenges it solves, including extreme availability, fault isolation, data tenancy, application response and latency, hybrid cloud deployment, migration, and data sovereignty. In this presentation, learn how Oracle's sharding technology works, its limits, implementation planning, use cases, and features and enhancements planned in Oracle 20c.

Initiation to Containers for Database Pros (or: How I Learned to Stop Worrying and Love Docker)

April 23, 11 AM

Containers have been embraced by the developer community, but acceptance and adoption by DBAs is more... tepid. That's understandable--why would anyone want a database that's stateless and immutable?! I started using Docker under duress and had no idea what I was doing. Since then, I've learned that Docker elegantly addresses many situations faced by DBAs, including:

• Rapidly provisioning test and development environments

• Interacting with Oracle Cloud Infrastructure databases (including ATP and ADW)

• Preparing environments for performance testing

• Building Gold images

• Exploring new technologies and features

• Discovering and confirming bugs

• Preparing for certification exams

This session is a crash course in Docker covering the terminology, concepts, skills, and practical examples needed to begin using containers to support databases.