ODTUG Kscope20 Color_JPG.jpg

View Printable Version

REST in Peace - Administration of an Database using REST

Session Number: 9556
Track: Database
Sub-Categorization: DB Tools
Session Type: Tips, Techniques, and Tuning
Primary Presenter: Christian Gohmann [Oracle Senior Consultant - Trivadis GmbH]
Time: Jul 01, 2020 (03:30 PM - 04:30 PM)
Room: 210, Level 2

Speaker Bio: Christian Gohmann is currently working as Senior Consultant and Instructor at Trivadis GmbH in Düsseldorf, Germany. His main focus lies on helping customers in the areas of architecture planing, 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.

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

In his spare time, he shares his knowledge on his blog http://www.christian-gohmann.de.
Technologies or Products Used: Oracle REST Data Services, Oracle Database, oraCHK

Session Summary for Attendees:  Nowadays REST APIs are provided by more and more tools to allow self-written applications to integrate additional functionalities, like gathering performance statistics or creating new objects in a database.

Oracle does the same and provides access to the database using the Oracle REST Data Services (ORDS) infrastructure. With version 19.1 ORDS was enhanced with a new so called Database Management API. This API allows the administration of a database using simple REST calls.

Some examples:
- Start a Data Pump Export or Import
- Get performance statistics or objects details
- Create a new Pluggable Database
- ...

The presentation will demonstrate in a live demo how to configure ORDS and its Database Management API. Simple administration tasks are shown by calling the particular REST endpoint.

Beside this API, REST enabled functionalities of orachk and other Oracle tools will also been discussed.

Be sure to keep your user profile up to date! Click here to update now.