Oracle Team

SQL FIREWALL

This blog comes to complete the excellent blog written by my colleague Gregory Steulet on the same topic. SQL FIREWALL is a new security layer integrated into Oracle Database 23c. First, we create a admin user for which we(…)

How to code better?

Sysadmins are traditionally more operators than developers, they code mainly scripts for automation reasons (shell scripts, Ansible, Terraform, aso). In addition, they can find themselves in situations where they need to analyse code or even decompile programs. Some sysadmins lack(…)

AWX log keeper.

The aim of this project is to use Ansible role to export AWX logs on disk, on daily basis, to have an easy access for debug and investigation.

Using WebHook’s from GitLab to execute external code and tools

by Alexandre Nestor Introduction WebHooks are HTTP callbacks that are triggered by events. In case of GitLab these can be events like pushing some code, or creating an issue, or pushing some comments. In this quick post I will(…)

Comparison of support cycles RHEL and Clones

This blog is a comparison about the support periods of RHEL and the RHEL clones like AlmaLinux, Enterprise Linux, Oracle Linux and Rocky Linux and a look back to CentOS. CentOS Stream is a pre release of RHEL, so(…)

plot-ds.py, A Simple Plotting Command-Line Tool (Technical Details)

An utility to generate graphs and statistics based on input data (csv), for performance analysis.

How to use AWX REST API to execute jobs

by Alexandre Nestor Introduction AWX provides a REST API which allows to do pretty all commands that can be executed through the web interface, using http requests. Sometimes is more easy to restart, or start jobs for instance through(…)

Oracle Database Backup Cloud Service

In a previous blog I demonstrated how to migrate an Oracle database from AWS to Oracle OCI using Data Guard. But what if you want to migrate to the Oracle Cloud, but don’t have a direct connection between the(…)

Unplug/Plug PDB in TDE Environment

By Mouhamadou Diaw In an oracle environment with Transparent Data Encryption (TDE) the transfer of PDB may require additional steps. In this blog we will see some steps which may be required when doing Unplug and Plug  of pluggable(…)

SHELL SCRIPTING: improve DBA scripts readability using J2 templates

Quering database's by using SQL in shell scripts can make the whole script unreadable. Very oftent the query is unredable too, due to the variable usage. This situation make the script debugging a pain. Templating simplify the script by taking(…)