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 MoreCategory: Oracle Cloud
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 MoreOracle 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 MoreGet 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 MoreOracle Cloud Infrastructure Storage Software Appliance – Installation and Configuration
The Oracle Cloud Infrastructure Storage Software Appliance – also known as Oracle Storage Cloud Software Appliance OSCSA – acts as a gateway between classic storage and the Oracle Cloud Infrastructure Object Storage Service. The appliance can be installed on an on-premises Linux system or in an Oracle Compute Cloud machine and runs in a Docker container. It offers a local cache where clients can place their files before the OSCSA moves them into the Storage Service. The communication between a client with a filesystem to the OSCSA works with NFSv4, from the OSCSA to the Object Storage Service, Oracle is using their REST interface. Traffic from the OSCSA to and from the Oracle cloud can be encrypted and compressed. In this blog post…
Read More