DOAG Anwenderkonferenz 2023 – Links der No-Slide-Tools-Session vom 22.11.2023

Hier die Links zu den vorgestellten Tools – viel Spass bei Ausprobieren, experimentieren und Know-How erweitern. Excalidrawhttps://excalidraw.com/ Visual Studio Codehttps://code.visualstudio.com/ Lightspeedhttps://developers.redhat.com/products/ansible/lightspeed GitHub Copilothttps://github.com/features/copilot DBeaver Communityhttps://dbeaver.io/download/ OpenAIhttps://openai.com/ Steampipehttps://steampipe.io/ ZoomIThttps://learn.microsoft.com/en-us/sysinternals/downloads/zoomit Docker Desktophttps://www.docker.com/products/docker-desktop/

Read More

The Grafana Plugins for Oracle Cloud Infrastructure Monitoring are back!

In September 2019 I wrote a blog post how to monitor an Oracle Cloud Infrastructure Autonomous database with Grafana plugin oci-datasource. But some weeks after publication, the plugin was not available on the Grafana page anymore. And only Oracle and Grafana had a clue why. Now everything will be fine now. Since the 6th of October, there are two new Grafana plugins available for download. They both don’t require a Grafana enterprise account. Oracle Cloud Infrastructure Metrics Data Source Oracle Cloud Infrastructure Logging Data Source The first one is a successor of the former oci-datasource plugin, the second allows to get logs from OCI resources like Compute or Storage. As an infrastructure guy, let’s install the Oracle Cloud Infrastructure Metrics…

Read More

Monitor your Oracle Cloud Free Tier with Grafana on Oracle Linux 8

In a previous blog post I wrote about monitoring Oracle Cloud Infrastructure components by Grafana. In the meantime, we got the Oracle Cloud Free Tier. Here is an updated version. This blog post shows you how to install and configure the Grafana plugin based on the Oracle blog entry https://blogs.oracle.com/cloudnative/data-source-grafana on an Oracle Enterprise Linux 8 server. Steps to monitor the Oracle Cloud Free Tier by the OCI Grafana Plugin Install and configure the Oracle Cloud Infrastructure CLI – by download or by YUM install Configure Group, User and Policy in Oracle Cloud Infrastructure Console Install Grafana and the OCI Plugin Configure the Grafana DataSource Create a new Dashboard with OCI Metrics Machine Requirements The server needs access to the internet.…

Read More

Oracle Database Backup Service – Encrypt your 12.2 Database Backups to the Cloud

The Oracle RMAN backup encryption is necessary if you want to backup your database into the Oracle cloud. In Oracle 12c, you have three methods available to encrypt an Oracle RMAN backup: with a passphrase with a master encryption key hybrid with a passphrase and an encryption key On docs.oracle.com, the basic setup is described here: https://docs.oracle.com/en/cloud/paas/db-backup-cloud/csdbb/configuring-encryption-backups.html#GUID-4A1F5CF5-7EAF-4D71-9B7F-B46412F552CE In this blog post, I show you how to configure your database environment with a master encryption key and a keystore. I use this solution to to backup and recovery to and into the Oracle cloud. And in the cloud, I don’t like to type in passwords manually for every action or write passwords in backup and restore scripts. There are also some…

Read More

Get your Oracle 18c Instance in the Oracle Infrastructure Cloud OCI Classic

Do you want to work with Oracle 18c in the Oracle Cloud but the database version is not selectable in the webinterface? You can create an 18c instance in the command-line interface with the PaaS Service Manager (psm). The installation is very well described here, for example you need Python and OpenSSL. My personal installation of the psm executable runs in the Windows 10 integrated Ubuntu system. Link to the PaaS Service Manager: https://docs.oracle.com/en/cloud/paas/java-cloud/pscli/abouit-paas-service-manager-command-line-interface.html After the successful psm setup, you can create an DBaaS instance with this command $ psm dbcs create-service –config-payload db18c-ee.json The file db18c-ee.json contains all the information you need to create an 18c instance. Here is my example – I have created a cloud storage container…

Read More