Oracle Team

PostgreSQL : barman rsync method vs streaming method

By Mouhamadou Diaw Barman is a tool to perform backup and recovery for PostgreSQL databases. It can do backup using two methods: -rsync/ssh -streaming In this blog I am going to explain how to use these two(…)

New search function for Oracle database features

Oracle released a new way to search for database features, and it is ...

Italian Oracle User Group Tech Days 2019

The Italian Oracle User Group (ITOUG) is an independent group of Oracle enthusiasts and experts which work together as volunteers to promote technical knowledge sharing in Italy.

Recover a corrupted datafile in your DataGuard environment 11G/12C.

On a DG environment, a datafile needs to be recovered on the STANDBY site, in two situations : when is deleted or corrupted. Below, I will explain  how to recover a corrupted datafile, in order to be able to(…)

PostgreSQL: When wal_level to logical

By Mouhamadou Diaw wal_level determines the quantity of information written to the WAL. With PostgreSQL 11 the parameter wal_level can have 3 values: -minimal : only information needed to recover from a crash or an immediate shutdown -replica(…)

Looping sssd_nss

Often Linux systems are connected to LDAP via sssd. A high CPU consuming sssd can be seen in top, like below ( e.g. 89.4 % CPU usage): 9020 root 20 0 1296344 466780 333364 R 89.4 0.8 41:20.17(…)

Compile additional packages for Oracle VM Server

I needed a special package on my OVM Server 3.4.6. The package is called fio and is needed to do some I/O performance tests. Unfortunately, OVM Server does not provide any package for compiling software and installing additional software(…)

How to build a dummy resource plan

Often switching off resource plan feature of Oracle database is desired. Unfortunately setting parameter RESOURCE_MANAGER_PLAN to empty string does not help, because it does not disable switching to another resource plan, e.g. with dbms_scheduler. Following procedure prevents this switching.

ODA: The Patch version must be 12.2.1.4.0

When trying to patch your virtualized ODA with patch 12.1.2.12.0 and immediately after that with 12.2.1.4.0, you might consider to load the patches like this: [root@XX1 Oracle_Soft_Repo]# oakcli unpack -package /cloudfs/Oracle_Soft_Repo/p26433712_1212120_Linux-x86-64_1of2.zip Unpacking will take some time, Please(…)

EDB Failover Manager 3.3 With Virtual Ip Address

By Mouhamadou Diaw In a previous blog , I talked about installing and configuring Edb Failover Manager with PostgreSQL. The configuration of a Virtual Ip Address was not discussed in this previous article.In this blog(…)