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 MoreCategory: Autonomous Database
Oracle Autonomous Transaction Processing – Move your Data with Oracle Data Pump – Part 3
In this blog post serie which has three parts, I want to describe how data will be uploaded from an on-premises environment into the Oracle Autonomous Transaction Processing database using Oracle Data Pump. Part 1: Creation of the ATP database and connection verification Part 2: Export of on-premises data with Oracle Data Pump and move into into the Oracle cloud Part 3: Import of data into the ATP database with Oracle Data Pump Oracle Import Prerequisites Credentials To get acccess to the dump file on the Oracle Object Storage, a credential has to be created in the Oracle Autonomous Transaction Processing database with the DBMS_CLOUD procedure. For more information about the package, see the blog post from Christian Antognini – DBMS_CLOUD Package – A…
Read MoreOracle Autonomous Transaction Processing – Move your Data with Oracle Data Pump – Part 2
In this blog post serie which has three parts, I want to describe how data will be uploaded from an on-premises environment into the Oracle Autonomous Transaction Processing database using Oracle Data Pump. Part 1: Creation of the ATP database and connection verification Part 2: Export of on-premises data with Oracle Data Pump and move into into the Oracle cloud Part 3: Import of data into the ATP database with Oracle Data Pump Oracle Data Pump Export on On-Premises Database Oracle recommends the following settings for the Oracle Data Pump export job. If you use already an 18c database, you have to set the version parameter to 12.2 to avoid this error during ATP import process: ORA-39358: Export dump file version 18.0.0…
Read MoreOracle Autonomous Transaction Processing – Move your Data with Oracle Data Pump – Part 1
In this blog post serie which has three parts, I want to describe how data will be uploaded from an on-premises environment into the Oracle Autonomous Transaction Processing database Oracle Data Pump. Part 1: Creation of the ATP database and connection verification Part 2: Export of on-premises data with Oracle Data Pump and move into into the Oracle cloud Part 3: Import of data into the ATP database with Oracle Data Pump Basics about ATP from the Using Oracle Autonomous Transaction Processing User Guide: Autonomous Transaction Processing is designed to support all standard business applications and deliver scalable query performance. Autonomous Transaction Processing provides all of the performance of the marketleading Oracle Database in an environment that is tuned and optimized for transaction processing workloads. As…
Read More