Not many things are free when we talk about Oracle, quite the opposite, but things are steadily but surely changing with the shift to Cloud. I can attest to this personally as I work with Oracle Cloud Services on a daily matter and I can see things changing on a weekly matter.

One of the services that Oracle has added to the list that is completely FREE is called Data Safe, this is and I quote: “ a unified control center for your Oracle Databases which helps you understand the sensitivity of your data, evaluate risks to data, mask sensitive…


Please read my previous post of how to install APEX on Oracle Database 11g if you want to use a non-multitenant architecture.

The current generation of Oracle Cloud databases do not have APEX installed as you can find them on the highly talked about Autonomous Database (ATP and ADW), so some of you might find it useful to follow this post on how I did my installation of APEX on Oracle Cloud Infrastructure DB System running a Standard Edition (SE) of Oracle Database 19c.

The main benefit of taking this approach is cost. For use cases were you don’t need…


Connecting a Windows server application hosted in Oracle Cloud to a DBCS cloud database (DB System) is pretty straight forward and can be achieved using the following setup. For my example I am using an Oracle Instant Client to connect to the database to issue some SQL queries or import a Data Pump file, but you could use any other type of client or application to do the same, so SQL Developer, Toad, SQL*Plus and apps.

First I downloaded these three packages Oracle Instant Client Base, Tools Package(impdp) and SQL*Plus Package from https://www.oracle.com/technetwork/topics/winx64soft-089540.html


Let me show you how you can manage Oracle Cloud Databases using Enterprise Manager running on the same cloud network.

Installing an OEM Agent on a cloud database is generally the same as you would normally do in premise. First step would be to have the OEM and target Linux database machines know of each other’s IP and host name using their fully qualified domain names.

I will show you how to add a Stadard Edition 12c database in the first part of this post and in the second I’ll do it for RAC cloud instances.

1.First I will connect…


Just recently a new image was posted on the OCI Marketplace called Oracle Enterprise Manager 13.3 that would make life a lot easier for many of us trying to manage their cloud (and on premise) databases using OEM.

The cool thing about this image is that it offers you a prepackaged installation of OEM so you don’t have to spend days installing and configuring it on Oracle Cloud.

Getting it up an running is quite easy but you will have to follow some guidelines to configure the environment correctly.

First we need to create some policies and dynamic groups before…


The current generation of Oracle Cloud databases do not have APEX installed on them as the first generation of Database Classic had, so some of you might find it useful to follow this post on how I did my installation of APEX on Oracle Cloud Infrastructure.

First off, the dependencies we need to install are:

  1. APEX 18
  2. Oracle Rest Data Services -ORDS
  3. Apache Tomcat

On this post I will be using a 11g Oracle Database Standard Edition as the back end, so in case you don’t have the database created already please follow my post HERE.

I will cover the…


Oracle Cloud offers an easy to use tool that you can use to manage all cloud services via REST APIs without needing you to learn how to code or become an expert in other programming languages. If I managed to do it, trust me, you will too :)

First off, why would you need to use API calls when you can manage a autonomous database using the web console? Well, for most of Oracle customers, they want to be able to schedule the automatic start/stop of a database or data warehouse instance at specific times to reduce cost. …


Oracle Cloud offers an easy to use tool that you can use to manage all cloud services via REST APIs without needing you to learn how to code or become an expert in other programming languages. If I managed to do it, trust me, you will too :)

First off, why would you need to use API calls when you can manage a database using the web console? Well, for most of Oracle customers, they want to be able to schedule the automatic start/stop of a database or compute instance at specific times to reduce cost. …


Trying to connect to a cloud database (DB System) on Oracle Cloud is a pretty straight forward thing to do.

First you need to know the IP address of your database. You will find this IP when you are on the overview page of all the databases from Menu → Bare Metal, VM, and Exadata.

The second step is that you will need to put together the Service Name of your database from the details page of your Db System. You need to retain these 2 settings: Database Unique Name and Host Domain Name :


One of the easiest ways to upload database exports and any kind of large files to the Oracle Cloud Object Storage is to use a free tool called CloudBerry Explorer for Amazon S3. By default uploading file through the web browser won’t work fopr files bigger then 2GB. At the moment I’m writing this article ( December 2018) there isn’t a CloudBerry connector to Oracle’s new Gen2 Cloud (OCI), there is only one for the older OCI-Classic services. …

Fathi Riadh

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store