Infrastructure at your Service

 
Franck Pachot

Oracle write consistency bug and multi-thread de-queuing

By | Oracle | 3 Comments

By Franck Pachot . This was initially posted on CERN Database blog where it seems to be lost. Here is a copy thanks to web.archive.org Additional notes: – I’ve tested and got the same behaviour in Oracle 21c – you will probably enjoy reading Hatem Mahmoud going further on Write consistency and DML restart Posted by Franck Pachot on Thursday, 27 September 2018 Here is a quick test I did after encountering an abnormal behavior…

Read More
Mouhamadou Diaw

Oracle 21c Security : Mandatory Profile

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

With Oracle 21c, it is now possible to enforce a password policy (length, number of digits…) for all pluggable databases or for specific pluggable databases via profiles. This is done by creating a mandatory profile in the root CDB and this profile will be attached to corresponding PDBs. The mandatory profile is a generic profile that can only have a single parameter, the PASSWORD_VERIFY_FUNCTION. The password complexity verification function of the mandatory profile is checked…

Read More
Daniel Westermann

pg_auto_failover: Failover and switchover scenarios

By | Application integration & Middleware | No Comments

In the last post we had a look at the installation and setup of pg_auto_failover. We currently have one primary cluster and two replicas synchronizing from this primary cluster. But we potentially also have an issue in the setup: The monitor is running beside the primary instance on the same node and if that nodes goes down the monitor is gone. What happens in that case and how can we avoid that? We also did…

Read More
Franck Pachot

Recovery in the ☁ with Google Cloud SQL (PostgreSQL)

By | Cloud, Postgres | No Comments

By Franck Pachot . In a previous post I started this series of “Recovery in the ☁” with the Oracle Autonomous database. My goal is to explain the recovery procedures, especially the Point-In-Time recovery procedures because there is often confusion, which I tried to clarify in What is a database backup (back to the basics). And the terms used in managed cloud services or documentation is not very clear, not always the same, and sometimes…

Read More
Daniel Westermann

Easy failover and switchover with pg_auto_failover

By | Database Administration & Monitoring | No Comments

One the really cool things with PostgreSQL is, that you have plenty of choices when it comes to tooling. For high availability we usually go with Patroni, but there is also pg_auto_failover and this will be the topic of this post. Because of the recent announcement around CentOS we’ll go with Debian this time. What is already prepared is the PostgreSQL installation (version 13.1), but nothing else. We start from scratch to see, if “is…

Read More
Mouhamadou Diaw

Oracle 21c Security : Gradual Database Password Rollover

By | Database Administration & Monitoring, Database management, Oracle, Security | 2 Comments

Starting with Oracle 21c, a password of an application can be changed without having to schedule a downtime. This can be done by using the new profile parameter PASSWORD_ROLLOVER_TIME This will set a rollover period of time where the application can log in using either the old password or the new password. With this enhancement, an administrator does not need any more to take the application down when the application database password is being rotated….

Read More
Mouhamadou Diaw

Oracle 21c Security : ORA_STIG_PROFILE and ORA_CIS_PROFILE

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

In my previous blog I was testing the creation of a new Oracle 21c database. In this blog I am talking about two changes about the security. In each new release Oracle strengthens security. That’s why since Oracle 12.2, to meet Security Technical Implementation Guides (STIG) compliance, Oracle Database provided the profile ORA_STIG_PROFILE With Oracle 21c the profile ORA_STIG_PROFILE was updated and Oracle has provided a new profile to meet CIS standard : the profile…

Read More
Cesare Cervini

A Simple Repository Browser Utility

By | Entreprise content management | No Comments

A few weeks ago, as the final steps of a cloning procedure, I wanted to check if the cloned repository was OK. One of the tests was to peek and poke around in the repository and try to access its content. This is typically the kind of task for which you’d use a GUI-based program because it is much quicker and easier this way rather than by sending manually typed commands to the server from…

Read More
Mouhamadou Diaw

Oracle 21c : Create a New Database

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

Oracle 21c is now released on the cloud. And in this blog I am just testing my first database creation . As earlier release dbca is still present. Just launch it [[email protected] admin]$ dbca After The creation some query to verify SQL> select comp_name,version,status from dba_registry; COMP_NAME VERSION STATUS —————————————- ———- ———- Oracle Database Catalog Views 21.0.0.0.0 VALID Oracle Database Packages and Types 21.0.0.0.0 VALID Oracle Real Application Clusters 21.0.0.0.0 OPTION OFF JServer JAVA Virtual…

Read More
Nabil Saoual

JENKINS install Jenkins on Windows

By | DevOps | No Comments

Hi Team, Today let’s talk about Jenkins software What is Jenkins? Jenkins is an open source automation server that enables developers around the world to reliably build, test, and deploy their software.It is the leading open-source continuous integration server. Built with Java it can manage a huge amount of plugin which extend its capacity. We will see how to install it on a Windows machine step by step. Prerequisites All information can be checked regarding…

Read More
Jérôme Dubar

A typical ODA project (and why I love Oracle Database Appliance)

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

Introduction You can say everything about Oracle infrastructure possibilities but nothing compares to experience based on the realization of real projects. I did quite a lot of ODA projects during the past years (on other platforms too), and I would like to tell you why I trust this solution. And for that, I will tell you the story of one of my latest ODA project. Before choosing ODAs A serious audit of the current infrastructure…

Read More
Franck Pachot

Aurora Serverless v2 (preview) – CPU

By | AWS | No Comments

By Franck Pachot . This follows my previous post https://blog.dbi-services.com/aurora-serverless-v2-ram/ ‎which you should read before this one. I was looking at the auto-scaling of RAM and it is now time to look at the CPU Utilization. I have created an Aurora Serverless v2 database (please don’t forget it is the beta preview) with auto-scaling from 4 ACU to 32 ACU. I was looking at a table scan to show how the buffer pool is dynamically…

Read More