In the part 1 of this blog post series, we have installed the Management Agent. Now it’s time to add the database. For this case an agent plug-in has to be installed first before we can configure the database. More information about the management agent administration: https://docs.oracle.com/en-us/iaas/management-agents/doc/management-agents-administration-tasks.html This is a small blog post series Part 1 shows the installation of the Management Agent on an on-premises system Part 2 describes how to manage this Oracle database in OCI Part 3 watches behind the scenes for billing, job execution etc. – coming soon… My Setup An OCI Tenant in datacenter EU-FRANKFURT-1 An empty compartment called datacenter-kestenholz An on-premises database called CDB114, running on Oracle Linux 7 OCI Management Agent up and running The goal is to handle the on-premises database in…
Read MoreOracle Cloud Infrastructure – A small and secure Development Environment – Next Level: Terraform
In a previous blog post I wrote how to build a small and secure development environment in Oracle Cloud Infrastructure with an OpenVPN entry point and a compute instance in a private setup. Now there is the Terraform code available in GitHub to setup it on an easy and reusable way: terraform-examples/oci/openvpnas at main · Trivadis/terraform-examples (github.com) What you get After executing the code, you will get this setup here: an OpenVPN Access Server from OCI Marketplace a Compute Instance Prerequisites Oracle OCI CLI installed and configured Terraform up and running Git client installed SSH Key Access An example private and public SSH key to get access on the compute instance in the private subnet is provided in subdirectory SSH,…
Read MoreOCI Cloud Performance Management for On-Premises Databases – Part 1 – Management Agent Installation
The OCI Management Agent service collects data from services and sources for monitoring and management in Oracle Cloud Infrastructure. In this blog post series I will show you how you can monitor and manage an on-premises Oracle databases in OCI. The communication between an agent and OCI requires an Agent Install Key and is based on HTTPS. Service Plugins extend a Management Agent for example for Oracle database performance monitoring and management or log analytics. This is a small blog post series Part 1 shows the installation of the Management Agent on an on-premises system Part 2 describes how to manage this Oracle database in OCI Part 3 watches behind the scenes for billing, job execution etc. My Setup An…
Read MoreOracle Cloud Infrastructure – A short Blog Post about a secure and small Development Setup
For an internal project I had the pleasure to setup a new Oracle Cloud Infrastructure environment for an APEX development team. Here is a short overview about the setup. Requirements VPN Access from everywhere – 2 people are working maximal at same time on the environment Oracle Standard Edition 2 – no license available in project Small monitoring to verify server stats Instances can be started and stopped from the developers to save costs for example over night, weekend, holiday etc. Architecture Diagram Resource Network Usage Remarks Open VPN Access Server Public Subnet VPN client access and traffic routing OCI Cloud Marketplace Image – OpenVPN Access Server (2 FREE VPN Connections) – OpenVPN Inc. – Oracle Cloud Marketplace Management Server…
Read MoreOracle Cloud Infrastructure Data Safe – How to burn down 201.44 Swiss Francs in 30 Seconds…
Is Data Safe really for free? In the last autumn, the new Oracle Cloud Infrastructure feature called Data Safe was released. For sure, new features has to be tested. I have tested the Data Safe feature too and added a cloud database to Data Safe. But in my enthusiasm about this cool feature – or maybe it was just too late in the evening – I did a mistake by adding the database target. Four days later, I recognized that Data Safe is charged in my account. Mmm, but should it not be for free? First reaction: I raised an SR and described the case. The nice guy from My Oracle Support realized the situation quickly: Dear Mister Berger, you…
Read More