Infrastructure at your Service

Category

Database Administration & Monitoring

Alain Fuhrer

Auto Upgrade of non CDB to PDB with autoupgrade.jar in Oracle 21c

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

Since Oracle 21c it is possible to convert the non CDB database into a PDB directly during the upgrade using the Oracle Autoupgrade Tool. This is an important enhancement, because with Oracle 21c the non CDB architecture is desupported, which means that with an upgrade to 21c a conversion is mandatory. Let’s test if this new feature really works and what needs to be considered. Work done by autoupgrade utility Check and Prepare Source non…

Read More
Stéphane Haby

SQL Server: Using Client Statistics to validate a query regression after a change in the database compatibility level

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

Few days ago, I have very poor performance on a database that I migrate from SQL 2012 to SQL 2019. The developer Team asks me to upgrade the number of CPU and the Memory to have better performance. First, I ask the Team to give me some queries sample to test the performance between the old environment in SQL server 2012 and the new one in SQL server 2019. To do the test, I use…

Read More
JĂ©rĂ´me Dubar

ODA: Quickly solve ILOM and BIOS update errors

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

Introduction Patching an Oracle Database Appliance is sometimes quite tough and you often struggle to solve failures at different steps. Regarding ILOM and BIOS patching errors, a simple workaround is possible. Errors when patching ILOM and/or BIOS This is something I recently had on an ODA X7-2S when trying to apply patch 19.11. Patching of the test server was OK, but patching the production server on a week-end was not OK. I needed to find…

Read More
JĂ©rĂ´me Dubar

Deploying a KVM-based virtualized X8-2M ODA

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

Introduction Until now, High-Availability (HA) ODAs could have been deployed either in bare metal or in virtualized mode. Virtualized mode means that instead of installing a classic Linux system on the nodes, an OVM hypervisor (based on Xen) was deployed. This hypervisor had at least one VM, a special one called ODA BASE, holding all the databases and having direct path to ASM disks. Other VMs could be created, not for databases but for applications,…

Read More
Stéphane Haby

SQL Server: “Cannot resolve the collation conflict” in a Stored Procedure

By | Database Administration & Monitoring | No Comments

This week I have a new little challenge by a customer. By executing a “standard” stored procedure, I have the error: Msg 468, Level 16, State 9, Procedure Get_logsessions, Line 56 [Batch Start Line 119] Cannot resolve the collation conflict between “Latin1_General_CI_AS” and “Latin1_General_CI_AS_KS_WS” in the equal to operation. The Stored Procedure named Get_Logsessions is to log all sessions running on the server in a table. Looking with the query I develop and present you…

Read More
Stéphane Haby

SQL Server SCOM database: A lot of errors 777970008 in the errorlog file

By | Database Administration & Monitoring | No Comments

Few weeks ago, during a audit, I have a lot of error 777970008 in the errorlog file from the SCOM instance. All 5 minutes, we had 4 lines more in the ErrorLog and the file growth a lot. After using google to find a cause of this message and resolve it, I finally find a good blog from Kevin Holman. I downloaded the script here and executed the part for the error 777970008 only: DECLARE…

Read More
JĂ©rĂ´me Dubar

Manage ODA patching with Data Guard or Dbvisit Standby

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

Introduction Building an Oracle infrastructure today without thinking about a Disaster Recovery solution (DR) is quite rare. This became obvious that a backup or a dump will not help if you do not know where to restore or import once your production server is down. And restoring a backup is definitely not the fastest way to bring back your database to life. As a consequence, Data Guard or Dbvisit Standby, depending on which edition you’re…

Read More
Stéphane Savorgnano

Automate restore from Rubrik with PowerShell (part 2)

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

As promised during my last Rubrik blog post I’m writing a second one to explain how to: log your different steps in a file add an integrity check after the restore and also improve my first scripting I will start by the end and improve my first scripts by creating functions for each step of the process. With Rubrik you can have multiple appliances (servers), it means that each server/instance of you SQL Server environment…

Read More
Steven Naudet

SQL Server: table variables performance limitations

By | Database Administration & Monitoring | No Comments

Doing some performance troubleshooting for one of my customers I identified some issues with very large table variables inside Stored procedures. Table variables limitations are not well understood by developers although they are now well documented. Table variable rows estimation Let’s have a look at an example with my customer context which is SQL Server 2016, so compatibility level 130 at the database level. You can reproduce this demo with the Wide World Importers database….

Read More
Karsten Lenz

Setup pgpass for replication

By | Database Administration & Monitoring | No Comments

This script provides functionality to setup passwordless authentication in PostgreSQL for defined Server Names. This is very helpful by using replication via repmgr and is not Linux Distribution specific, it was used till now with SLES 12, SLES 15 and RHEL 8 Clones. As all of my scripts it provides help how the usage is with -h parameter: $ [[[email protected] ~]$ sh pgpass.sh -h $ [[[email protected] ~]$ Usage: $ [[[email protected] ~]$ pgpass.sh [OPTION] $ [[[email protected]

Read More