Infrastructure at your Service

All posts by Joël Cattin

Joël Cattin
Consultant

Joël Cattin has more than three years of experience in databases management. He is specialized in Oracle solutions such as Data Guard and RMAN and has a good background knowledge of Oracle Database Appliance (ODA), Real Application Cluster (RAC) and applications development on APEX.   Joël Cattin’s experience includes other RDBMS, such as PostgreSQL and MySQL.   He is Oracle Database 12c Administrator Certified Professional, EDB Postgres Advanced Server 9.5 Certified Professional, RedHat Certified System Administrator and ITILv3 Foundation for Service Management Certified.   Joël Cattin holds a degree from the École Supérieure d’Informatique de Gestion (ESIG) in Delémont and a Federal Certificate of Proficiency in Computer Science (Certificat fédéral de Capacité – CFC).
Joël Cattin

OEM Cloud Control 13c – Agent Gold Image

By | Database Administration & Monitoring, Database management, Oracle | No Comments

Introduction I am currently setting up a new “Base Image” virtual machine (Red Hat Enterprise Linux 7.6) which will be used to create 6 brand new Oracle database servers requested by a customer. Besides installing and configuring the OS, I also have to install 3 Oracle Homes and one Cloud Control Agent 13c. An OMS13c server already exists including an Agent patched with the EM-AGENT Bundle Patch 13.2.0.0.181031 (28680866) : oracle@oms13c:/home/oracle/ [agent13c] opatch lsinventory |…

Read More
Joël Cattin

From Oracle to Postgres with the EDB Postgres Migration Portal

By | Database Administration & Monitoring, Database management, Postgres | No Comments

EnterpriseDB is a valuable actor in PostgreSQL’s world. In addition to provide support, they also deliver very useful tools to manage easily your Postgres environments. Among these we can mention EDB Enterprise Manager, EDB Backup & Recovery Tool, EDB Failover Manager, aso… With this post I will present one of the last in the family, EDB Postgres Migration Portal, a helpful tool to migrate from Oracle to Postgres. To acces to the Portal, use your…

Read More
Joël Cattin

PostgreSQL – logical replication with pglogical

By | Database Administration & Monitoring, Database management, Postgres | No Comments

Although PostgreSQL 10 integrate native logical replication (have a look here or here), it is always interesting to be aware of alternative solutions to the available in-core features. One of those is called pglogical. It’s a Postgres extension developed by 2ndQuadrant, major contributor to PostgreSQL development. The goal of this blog post is to discover how to install pglogical and configure it in order to generate simple logical replication cases. Installation To get the extension…

Read More
Joël Cattin

PostgreSQL 10 Beta 1 : pg_hba_file_rules view

By | Database Administration & Monitoring, Database management | No Comments

This short blog to share a helpful stuff with the pg_hba.conf file : The pg_hba.conf file is the central configuration file to control client authentication. It is located in the database cluster’s data directory : postgres@ppas01:/u02/pgdata/PG10BETA1/ [PG10BETA1] ll pg_hba.conf lrwxrwxrwx. 1 postgres postgres 59 Jun 30 10:19 pg_hba.conf postgres@ppas01:/u02/pgdata/PG10BETA1/ [PG10BETA1] When you add or modify an entry in this file, you have to reload the cluster to take the changes in account : postgres@ppas01:/u02/pgdata/PG10BETA1/ [PG10BETA1]…

Read More
Joël Cattin

Oracle 12cR2 : Optimizer Statistics Advisor

By | Database Administration & Monitoring, Database management, Development & Performance | No Comments

The Optimizer Statistics Advisor is a new Advisor in Oracle 12.2. The goal of this Advisor is to check the way you gather the statistics on your database, and depending on what is found, it will makes some recommendations on how you can improve the statistics gathering strategy in order to provide more efficient statistics to the CBO. This Advisor is also able to generate remediation scripts to apply the statistics gathering “best practices”. The…

Read More
Joël Cattin

Oracle 12cR2 : Partitioning improvements – online conversion of a non-partitioned table to a partitioned table

By | Database Administration & Monitoring | No Comments

It’s time to a new blog about partitioning improvement in 12cR2. After auto-list partitioning and multi-column list partitioning & read-only partitions, I’ll demonstrate how we can easily convert a non-partitioned table to a partitioned table…online ! As a reminder, the way to convert a table to a partitioned table were to use the DBMS_REDEFINITION package (since 9i to 12cR1) which require few steps : Verify that the table is a candidate for redefinition : DBMS_REDEFINITION.CAN_REDEF_TABLE…

Read More
Joël Cattin

Oracle 12cR2 : Partitioning improvements – multi-column list partitioning & read-only partitions

By | Database Administration & Monitoring, Development & Performance | No Comments

In my last blog post I presented auto-list partitioning, a new partitioning functionality coming with 12cR2. In this one I will introduce two others : multi-column list partitioning and read-only partitions. Multi-column list partitioning Image : “Oracle Partitioning in Oracle Database 12c Release 2″ – Hermann Bär With the first release of 12c it wasn’t possible to create list partitioned tables based on multi-column partition key : ORA-14304: List partitioning method expects a single partitioning…

Read More
Joël Cattin

Oracle 12cR2 : Partitioning improvements – auto-list partitioning

By | Database Administration & Monitoring, Development & Performance | One Comment

The second release of Oracle Database 12c (12cR2) comes with new improvements regarding partitioning. In this blog post I’ll show one of them : auto-list partitioning. Auto-list partitioning is an extension of list partitioning. It enable the automatic creation of partitions for new values inserted into the partitioned table. Image : “Oracle Partitioning in Oracle Database 12c Release 2″ – Hermann Bär Let’s have a look at the syntax. As you can see below, you…

Read More
Joël Cattin

OTN Appreciation Day : OSWatcher Black Box Analyzer (OSWBBA)

By | Operation systems | 3 Comments

Following my last blog post about OSWatcher, I will present in this one OSWatcher Black Box Analyzer (OSWBBA), which is the tool that you can use to display graphically the data collected by OSWBB. This tool is a Java utility and exists since OSWatcher version 4.0.0. It permits to create graphs and complete HTML reports containing collected OS statistics.   OSWBBA require no installation. It is embedded in the OSWatcher home directory. To start the…

Read More
Joël Cattin

OTN Appreciation Day : OSWatcher Black Box (OSWBB)

By | Operation systems | No Comments

In this post, I will present a usefull and easy-to-use Oracle tool : OSWatcher. What is it ? OSWatcher Black Box (OSWBB), for its full name, is a free Oracle Tool which will help you to diagnose performance issues on the OS side. Of course, it will not solve the issue for you, but it gives a system health state at a given moment. OSWBB is multi-platforms supported (AIX, Solaris, HP-UX, Linux and Windows) and…

Read More