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.
During ConTech2021 Christian Gohmann will present REST in Peace – Administration of an Oracle Cluster/Database using REST
For huge Oracle environments; automation is one of the key aspects to handle maintenance tasks; monitoring etc. in an effective manner. With the introduction of ORDS and its REST APIs these tasks can be handled by calling simple URLs. See how you can control your Oracle database using REST calls.
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.
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.
Besides this API; REST enabled functionalities of orachk and other Oracle tools will also be discussed.