Infrastructure at your Service

All posts by Mouhamadou Diaw

Mouhamadou Diaw
Consultant

Mouhamadou Diaw has more than ten years of experience in IT domains. He is specialized in Oracle technologies (engineered system, architecture, backup and recovery, high availability, security, audit etc.). Mouhamadou Diaw is Oracle professional Certified (8i, 10g, 11g, 12c), Oracle RAC 11gR2 Certified Expert , Oracle Database 11g Security Certified and CISA (Isaca). He received a Doctorate in Heat and Humidity Transfer of INSA Toulouse, France. His branch-related experience covers Insurance, Retail, International Organizations, Transport & Logistics, etc.
Mouhamadou Diaw

Replicating specific tables in PostgreSQL 10 Beta with mimeo

By | Database Administration & Monitoring | No Comments

In this blog I am going to test the extension mimeo with PostgreSQL 10 beta. Mimeo is a replication extension for copying specific tables in one of several specialized ways from any number of source databases to a destination database where mimeo is installed. In our configuration we are going to replicate data on a same server but between 2 clusters running on different ports. But it’s same for different servers. The pg_hba.conf should be…

 
Read More
Mouhamadou Diaw

Grid Infrastructure 11.2.0.3 PSU: My Opatch version check is failing

By | Database Administration & Monitoring | No Comments

Last day I was configuring grid infrastructure 11.2.0.3 for a standlone server. After the installation, I decided to apply the Patch Set Update 11.2.0.3.7 (Includes Database PSU 11.2.0.3.7) – 16742216 In the documentation it is marked You must use the OPatch utility version 11.2.0.3.4 or later to apply this patch. Verifying my opatch version, I see that I have to update it [root@ ]# ./OPatch/opatch version Invoking OPatch 11.2.0.1.7 OPatch Version: 11.2.0.1.7 So I download…

 
Read More
Mouhamadou Diaw

Grid Infrastructure 12.2: Are all Redhat 7 kernels compatible?

By | Database Administration & Monitoring | No Comments

In this blog I am going to share an issue I had when installing grid infrastructure 12.2 on Redhat 7.3. I was configuring grid infrastructure 12.2 for a standlone server. Below the release and the version of my operating system root@dbserver /etc $ cat redhat-release Red Hat Enterprise Linux Server release 7.3 (Maipo) root@dbserver ~ $ uname -a Linux dbserver 3.10.0-514.21.2.el7.x86_64 #1 SMP Sun May 28 17:08:21 EDT 2017 x86_64 x86_64 x86_64 GNU/Linux root@dbserver ~…

 
Read More
Mouhamadou Diaw

PostgreSQL 10 Beta 1: Logical replication

By | Database Administration & Monitoring | No Comments

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 now impelemented. We can replicate one table or many tables. In our example we are replicating between two clusters in the same server. The primary cluster is running on port 5432 and the second on port 5433. But of course we an use…

 
Read More
Mouhamadou Diaw

History of Upgrading 9 Tb PostgreSQL database

By | Database Administration & Monitoring | No Comments

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, server name are changed for security reason Host: CentOS release 6.4 PostgreSQL version: 9.2 Database size : 9Tb postgres=# select version(); version ————————————————————————————————— ———— PostgreSQL 9.2.4 on x86_64-unknown-linux-gnu, compiled by gcc (GCC) 4.1.2 20080704 (Red Hat 4.1.2- 52),…

 
Read More
Mouhamadou Diaw

PostgreSQL 10 Beta 1: Native Table Partitioning

By | Database Administration & Monitoring | No Comments

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 can implement partitioned table in PostgreSQL 10. Note that RANGE and LIST partition are the supported methods. In following example RANGE partition is used. The first step is to create the table to be partitioned, let’s say for example…

 
Read More
Mouhamadou Diaw

Upgrade to Oracle 12.2 with dbupgrade utility

By | Database Administration & Monitoring | No Comments

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 can be also used. Oracle Database 12.1 introduced the Parallel Upgrade Utility, catctl.pl. This utility reduces the total amount of time it takes to perform an upgrade by loading the database dictionary in parallel, and by using multiple…

 
Read More
Mouhamadou Diaw

Migrating from oracle to postgresql with ora2pg

By | Database Administration & Monitoring | One Comment

PostgreSQL is one of the most used Rdbms. In this blog we are going to talk about migrating from oracle to postgresql using ora2pg. A previous blog about this topic can be found here. After installing ora2pg tool, we will see how to configure and to run it to migrate our data. We are using an oracle 12.1 database and a postgresql 9.6.2. The server is runing on OEL 7.2 The oracle database and the…

 
Read More
Mouhamadou Diaw

Sharding with Oracle 12c R2 Part II : Scalability and Connections

By | Database Administration & Monitoring | No Comments

In previous blog, we talked about system-managed sharding. We saw how it is possible to create shard databases with Oracle 12c R2. Below we remind the configuration we used. VM sharddemo1: catalog VM sharddemo2: shard VM sharddemo3: shard One of the characteristics of sharding is the scalability, and in this blog we are going to add a new shard on a new server. The new configuration will be like below VM sharddemo1: catalog VM sharddemo2:…

 
Read More
Mouhamadou Diaw

Is your DBA_FEATURE_USAGE_STATISTICS up-to-date?

By | Database Administration & Monitoring | One Comment

Last day we were doing a licensing review for a client. As many dbas may already know, this require to execute some oracle scripts at OS level and database level. Among these scripts we have the script options_packs_usage_statistics.sql (docId 1317265.1) which is an official oracle script to check the usage of separately licensed Oracle Database Options/Management Packs This script is using the DBA_FEATURE_USAGE_STATISTICS table to retrieve info. And sometimes it may happen that data of…

 
Read More