Infrastructure at your Service

Category Archives: Database Administration & Monitoring

Daniel Westermann

udev rules for ASM devices on RHEL 7

By | Database Administration & Monitoring | 2 Comments

Preparing the storage devices for use with ASM is one of the first tasks you should do. When you do not want to use ASMLib then udev is what you should use for this. As the order/naming of the devices in the device tree is not guaranteed (e.g. dm-1 is not guaranteed to be the same device after a reboot of the system) you need a way to fix this and that is what udev…

 
Read More
Daniel Westermann

Going from SLES12 SP2 to SLES12 SP3, online

By | Database Administration & Monitoring | 3 Comments

SLES 12 SP3 was released some time ago and as we have customers running on that I thought it might be a good idea to test the upgrade from SP2 to SP3. Actually it turned out this is quite easy and can be done online. The supported methods for doing this is either by using YaST or Zypper directly. As I wanted to stay on the command line I’ll use Zypper for the scope of…

 
Read More
Stéphane Haby

SQL Server 2017 RTM is available: time to try!

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

Now SQL Server 2017 RTM  is available. The first step is to go to the Evaluation Center here After completing the registration with your contact information, you download the file “SQL Server 2017-SSEI-Eval.exe” Run SQL Server 2017-SSEI-Eval.exe and now it begins! A first screen gives me 3 choices to install SQL Server Basic: easy and fast to download and install SQL Server 2017 Custom: Download the setup package and launch the SQL Installation Center Download…

 
Read More
Stéphane Savorgnano

SQL Server 2017 on RHEL first installation

By | Database Administration & Monitoring | No Comments

Beginning of last week Microsoft announced the general availability of SQL Server 2017 for today, the second of October. In the same time, but in a more marketing side, Microsoft announced a SQL Server on Red Hat Enterprise Linux offer, more information here. It looked for me like the good time to do my first installation of SQL Server 2017 on Linux. My first concern was to download an ISO of the Red Hat Enterprise…

 
Read More
Stéphane Haby

SQL Server 2016: New Dynamic Management Views (DMVs)

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

In SQL Server 2016, you will discover a lot of new Dynamic Management Views(DMVs). In this article, I will just give you a little overview of these useful views for us as DBA. SQL Server 2012 has 145 DMVs and SQL Server 2014 has 166 DMVs. Now, SQL Server 2016 has 185 DMVs. How to see it? It is very easy to have a look using the sys.all_objects view: SELECT * FROM sys.all_objects WHERE TYPE=’V’…

 
Read More
Daniel Westermann

Announcing the dbi OpenDB Appliance

By | Database Administration & Monitoring | No Comments

As already announced on Twitter and LinkedIn here is the blog post to describe our OpenDB appliance in more detail. I am sure you wonder what this is about so let me explain why we are doing this. What we do see day by day at our customers is that more and more databases get consolidated on to a VMWare deployment. This is not only true for the smaller ones of those but also for…

 
Read More
Daniel Westermann

Be careful when putting the Oracle ADR on xfs, or better 4K sector format drives

By | Database Administration & Monitoring | No Comments

Today, after we did a fresh setup of a Grid Infrastructure cluster (12.1.0.2.170814) we faced two issues reported in the alert.log of the ASM instances (in fact you would see the same for the alert logs of any instance in that configuration but we did not had any other instance up and running at that time): This: ORA-00700: soft internal error, arguments: [dbgrfrbf_1], [/disk00/app/grid/diag/asm/+asm/+ASM2/metadata/INC_METER_SUMMARY.ams], [0], [4], [], [], [], [], [], [], [], [] ORA-27072:…

 
Read More
Franck Pachot

Bequeath connect to PDB: set container in logon trigger?

By | Database Administration & Monitoring, Oracle | No Comments

There are little changes when you go to multitenant architecture and one of them is that you must connect with a service name. You cannot connect directly to a PDB with a beaqueath (aka local) connection. This post is about a workaround you may have in mind: create a common user and set a logon trigger to ‘set container’. I do not recommend it and you should really connect with a service. Here is an…

 
Read More
Franck Pachot

Get trace file from server to client

By | Database Administration & Monitoring | No Comments

The old way to get a user dump trace file, for sql_trace (10046), Optimizer compilation trace (10053), lock trace (10704), Optimizer execution trace (10507),… is to go to the server trace directory. But if you don’t have access to the server (as in the ☁) the modern (12cR2) way is to select from V$DIAG_TRACE_FILE_CONTENTS. Before everybody is on 12.2 I’m sharing here a sqlplus script that I use for a long time to get the…

 
Read More