Oracle Team

PostgreSQL 10 Beta 1: Logical replication

By Mouhamadou Diaw In a previous blog we talked about partition in postgreSQL 10 Beta 1. In this article we will talk about another new feature logical replication. Yes in postgreSQL 10, logical replication is(…)

History of Upgrading 9 Tb PostgreSQL database

Mouhamadou Diaw In this blog I am going share a history of PostgreSQL migration and upgrade from 9.2 to 9.6. Let me first explain the context We have a PostgreSQL environment with following characteristics. Note that real database name,(…)

Oracle Linux 7 – How to audit changes to a trusted file such as /etc/passwd or /etc/shadow

Linux auditing is quite powerful and a lot of different use cases might be handled via the auditing framework. However, in this blog I would like to show you, how to audit changes on trusted files, like /etc/passwd or /etc/shadow.

PostgreSQL 10 Beta 1: Native Table Partitioning

By Mouhamadou Diaw The Beta 1 version PostgreSQL 10 is now released with lot of new features. One of the most popular is the native support of table partitioning. In this blog we are going to see how we(…)

How to manually install the ODA Plug-in 13.1.1.1.0 on Cloud Control 13.2

[vc_row][vc_column][vc_column_text]Usually, installing the ODA Plug-in is quite easy. You just run a Self Update, then you deploy the ODA Plug-in on the Management Server, and afterwards on the Agents of your ODA Bases.[/vc_column_text][/vc_column][/vc_row][vc_row][vc_column width=”1/1″][image_with_animation image_url=”16673″ animation=”Fade In” img_link_target=”_self”][/vc_column][/vc_row][vc_row][vc_column width=”1/1″][vc_column_text]However, not(…)

random “ORA-01017: invalid username/password” in 12cR2

By Franck Pachot . Since 12cR2 is out, we give our 12c new feature workshop with hands-on exercises on 12.1 and 12.2 releases. When I gave it last month, I had a small problem when doing(…)

12cR2 Cross-container DML – insert into container()

By Franck Pachot . Multitenant has been introduced in 12.1.0.1 with the goal to share resources but isolate data. However, having all PDBs in the same root may be convenient to manipulate data in multiple PDBs. In the first patchset,(…)

Upgrade to Oracle 12.2 with dbupgrade utility

By Mouhamadou Diaw Oracle 12.2 is released and we will have to upgrade. And in this blog we are going to talk about upgrading to oracle 12.2 using the dbupgrade utility. Of course the dbua tool is still available and(…)

Grid Infrastructure Installation on SLES 12 SP1

This week I needed to install Oracle Grid Infrastructure 12c release 1 in a SLES 12 SP1 environment. Everything worked fine until I ran the root.sh at the end of the installation. Here’s a quick description of the problem and(…)

What is in a transportable tablespace dumpfile?

By Franck Pachot . On 31st of May in Düsseldorf, at DOAG Datenbank, I'll talk about transportable tablespaces and pluggable databases. Both methods are transporting data physically, the difference is in the transport of the metadata,(…)