Oracle Apex on ATP with custom domain

If you have an Apex app on top of your Oracle Autonomous database you have the application URL like https://m5c5hpup7eqqydh-glebatp01.adb.us-ashburn-1.oraclecloudapps.com/ords/r/covid/covid-ontario/covid_ontario. This is already better than it used to be before and have a friendly path in the URL but what if you want to use your own domain address and custom URL? This blog is about how to set it up using reverse proxy. The way with a custom ORDS is a subject for another post.

So, you have your own domain registered in DNS, for example apex.gleb.ca and an application like I’ve listed above. What you want to do is to make the application URL as https://www.apex.gleb.ca/covid/ . What we are going to use is a virtual machine with a Nginx web server serving as a reverse proxy to your Apex application created on the Oracle Autonomous database.

Continue reading “Oracle Apex on ATP with custom domain”

AlloyDB backups management

The post is about backup management for AlloyDB. It might be useful for the time when it is written but, probably, will be obsolete very soon when tools and API for the service will mature.
A couple of words about AlloyDB backups and how they are created. The backups are quite different from the default backups for Cloud SQL for example. As we know in Cloud SQL all the backups are bound to the instance. What it means is when the instance is deleted then all the backups disappear along with the instance. It makes sense if the backups behind the scenes are storage snapshots from the databases. But in AlloyDB all the backups are decoupled from the cluster and exist by themselves. If you delete a cluster the backups stay. I think it is a way better approach because it provides a better way to protect from some mistakes when an instance is deleted before making a clone or exporting the data. As for now you can see all the backups for existing and deleted instances using the “backups” tab in the console, gcloud utility or listing using GCP REST API.

Continue reading “AlloyDB backups management”

Cloud and how it might help at difficult times.

The recent changes caused by the virus and economic meltdown affected almost everybody in the world. We are all now going through a difficult period of our history, and when many companies are struggling to survive, the other thrive and boost production. In such volatile environment, it becomes more and more important to be able to adapt the IT environment to immediate business needs quickly.

Continue reading “Cloud and how it might help at difficult times.”

Exadata Cloud at Customer – number of active CPUs and adding a new database.

Let’s imagine a typical working day, and you are getting a request to add a new database to your Exadata Cloud at Customer (ExaCC). If you are not familiar with the product, you can read about it in detail here. In short, it is an Exadata machine with a cloud interface, something like Oracle Exadata Cloud Service, but with the hardware installed in your datacenter. 

Continue reading “Exadata Cloud at Customer – number of active CPUs and adding a new database.”

Is Oracle cloud only for Oracle?

Several days ago, discussing public cloud solutions and competition between different providers, one of the people mentioned that Oracle Cloud is just for Oracle products. At the same time, AWS and Azure are more vendor agnostic. I was a bit surprised by that statement but it appeared that several other people shared the same view. I decided to write the blog and show what options Oracle Cloud Infrastructure (OCI) has for different workloads.

Continue reading “Is Oracle cloud only for Oracle?”

Copy files to Oracle OCI cloud object storage from command line.

This blog post is bit longer than usual but I wanted to cover at least three options to upload files to the Oracle OCI object storage. If you need to just upload one file you can stop reading after the first option since it covers probably most of needs to upload a single file. But if you want a bit more it makes sense to check other options too. Continue reading “Copy files to Oracle OCI cloud object storage from command line.”