Oracle Team

Reimaging an ODA to 19.8 Part II

By Mouhamadou Diaw In my previous blog, I described the steps to deploy an ODA 19.8 by reimaging. The ODA was reimaged with the latest available version 19.8 but some components were not up-to-dated. 1(…)

Reimaging an ODA to 19.8 Part I

By Mouhamadou Diaw Recently I was deploying some ODA X8-2M. To install the 19.8 software, I decide to reimage the server with the 19.8 image. In this blog I describe the main steps I did. First, we will need to(…)

SQL Server on Oracle Cloud

By Franck Pachot . You can create a VM with SQL Server running in the Oracle Cloud. This is easy with a few clicks on the marketplace: Here are the steps I did above: Oracle(…)

Oracle Data Pump Integration for Table instantiation with Oracle Golden Gate

From Oracle GoldenGate (OGG) version 12.2 and above, there is a transparent integration of OGG with Oracle Data Pump as explained in the Document ID 1276058.1. The CSN for each table is captured on an Oracle Data Pump export. The(…)

Oracle ADB: rename the service_name connect_data

By Franck Pachot . Since Aug. 4, 2020 we have the possibility to rename an Autonomous Database (ATP, ADW or AJD – the latest JSON database) on shared Exadata infrastructure (what was called ‘serverless’ last year which is a(…)

A lesson from NoSQL (vs. RDBMS): listen to your users

By Franck Pachot . I have written a few blog posts about some NoSQL (vs. RDBMS) myths (“joins dont scale”, “agility: adding attributes” and “simpler API to(…)

Git collaboration: quick start

Git collaboration: quick start If you want to keep the git repository of your project clean and predictive (which is highly recommendable), here is a simple workflow to follow. For the sake of this article, we are going to(…)

The myth of NoSQL (vs. RDBMS) “a simpler API to bound resources”

By Franck Pachot . NoSQL provides an API that is much simpler than SQL. And one advantage of it is that users cannot exceed a defined amount of resources in one call. You can read this in(…)

A Serverless Standby Database called Oracle Autonomous Data Guard

By Franck Pachot . Announced by Larry Ellison last week, here it is: the Autonomous Data Guard. You can try it, unfortunately not on the Free Tier. First you create an Autonomous Database (ATP or ADW) and then(…)

Create and configure an Oracle linked server in SQL Server Instance

What is Linked server ? Now a days in each company we have different applications and each one of them have different needs in term of databases support. When data exists on multiple databases the management become a little bit(…)