Infrastructure at your Service

 
Daniel Westermann

Helvetia used AWS SCT & DMS to migrate to AWS RDS for PostgreSQL

By | Database Administration & Monitoring | No Comments

One of our long term-time customers, Helvetia, successfully migrated on-prem Oracle databases to AWS, not only because of the licenses, but more importantly: to deploy faster, innovate faster, and use the state-of-the-art open source database system. When you plan such a project, you need to know which tools you want to use and what the target architecture shall look like. There are several options to choose from but finally Helvetia decided to use the AWS…

Read More
Karsten Lenz

How to setup a Consul Cluster on RHEL 8, Rocky Linux 8, AlmaLinux 8 part 2

By | Database Administration & Monitoring, Postgres | 2 Comments

Within the first part I have described the setup of Consul as replacement for ETCD. Here now the setup ob keepalived, haproxy and patroni. The needed packages I have installed within the first part, so let’s start with the configuration of keepalived. At first we need to open firewalld for the VRRP Protocol: $ [[email protected] ~]# firewall-cmd –add-rich-rule=’rule protocol value=”vrrp” accept’ –permanent $ success $ [[email protected] ~]# firewall-cmd –reload $ success $ [[email protected] ~]# Next…

Read More
Mouhamadou Diaw

Configure Data Guard between 2 DB Systems with Oracle 21c

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

In this previous blog, I have configured 2 DB systems with Oracle 21c in an ODA 19.14. Now let’s continue and show how we can configure a Data Guard between these 2 servers. One option is to manually create the Data Guard as we do in a non-ODA environment. The second option that I am showing is to use the odacli command to configure the Data Guard. All steps are described in Oracle documentation The…

Read More
Mouhamadou Diaw

Configure DB System Oracle 21c in a ODA 19.14

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

One question we may ask is that if it is possible to deploy an Oracle 21c database in an ODA as the latest version for ODA is actually 19.x The answer is Yes. Since ODA release 19.12, we can install a DB system with Oracle 21c while the bare metal system runs Oracle Grid Infrastructure 19.x. To see the supported versions on the DB system just run the command describe-dbsystem-image [[email protected] ~]# odacli describe-dbsystem-image DB…

Read More
Pascal Brand

How to allow users having monitoring role to view and manage messages in WebLogic JMS queues.

By | Application integration & Middleware | No Comments

Recently I got the request to provide JMS Queues monitoring access to a group of users with the privileges to view and manage de messages in the queues. This can be done through the WebLogic console but for this customer, all is done via ansible scripts. Thus I had to find a scripting solution. I followed the Oracle documentation to create the policy. Extract of the WLST code: try:    print “applying JMS access policy for…

Read More
Lazhar Felahi

How to create an Oracle GoldenGate EXTRACT in Multitenant

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

Create an EXTRACT process into container database has some specificity : From the CDB$ROOT, create a common user and configure the database to be ready to extract data via GoldenGate: SQL> create user c##gg_admin identified by “*****” default tablespace goldengate temporary tablespace temp; User created. SQL> SQL> alter user c##gg_admin quota unlimited on goldengate; User altered. SQL> SQL> grant create session, connect,resource,alter system, select any dictionary, flashback any table to c##gg_admin container=all; Grant succeeded. SQL>…

Read More
Lazhar Felahi

Near Zero Downtime Migration and failback with GoldenGate

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

Oracle GoldenGate allows to migrate Oracle database with Near Zero Downtime and with failback capability. Near Zero Downtime migration means very minimal application switchover downtime. The failback consists to rollback the migration from 19c to 12c. The goal of this blog is to describe how to migrate an oracle database from 12c to 19c via Oracle GoldenGate with Near Zero Downtime and with failback capability.   STEP 1 – CHECK GOLDENGATE SYNCHRONIZATION The Oracle GoldenGate…

Read More
Steven Naudet

SQL Server: Find who forced a plan in Query Store with this new XEvent

By | Database Administration & Monitoring, SQL Server | No Comments

The latest Cumulative Update for SQL Server 2019 has been released this week on Monday. It brings many bug fixes and some small improvements. One of these improvements is the addition of an extended event to identify the users forcing or unforcing an execution plan via the Query Store. In this blog post, I will test this new XEvent. For details about the latest CU see: KB5011644 – Cumulative Update 16 for SQL Server 2019…

Read More
Steven Naudet

SQL Server: Automatic Soft-NUMA and uneven CPU load

By | Database Administration & Monitoring, SQL Server | No Comments

SQL Server has CPU limitations depending on the Edition. If your VM is not configured properly you can reach these limits very easily. In a previous post, I described the effect VM misconfigurations can have on performance because not all available cores are used as expected. See: SQL Server CPU limitation for Express and Standard Edition In this article I will share a similar case but this time in a context where the Automatic soft-NUMA…

Read More
Mouhamadou Diaw

Oracle Data Guard : Where to Host The Master Observer

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

An observer is an OCI client that connects to the primary and target standby databases using the same SYS credentials you used when you connected to the Oracle Data Guard configuration with DGMGRL. The observer is highly recommended in a Data Guard environment. But it is mandatory if a Fast-Start Failover is configured. Since Oracle 12.2 we can have up to 3 observers and the maximum number of observers is increased to 4 since Oracle…

Read More