Infrastructure at your Service

Category Archives: Database Administration & Monitoring

Stéphane Haby

Migration to SQL Server 2016 with deprecated data types and Full-Text

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

A few weeks ago, I prepared a migration from SQL Server 2008 to SQL server 2016, I came across a case with deprecated data types and a Full-Text activated on these columns. To simulate this scenario, I downloaded and installed the Data Migration Assistant(DMA). Make sure that the .Net Framework 4.5 is installed on your machine before starting the installation of the DMA. After the installation, you start the application which is very simple to…

 
Read More
Stéphane Haby

SQL Server 2016: patching CU with R Services

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

As a good DBA, I begin to be up to date with all Cumulative Update (CU) by my customers. It is the first time that I run an update for SQL Server 2016 with the CU 3. I download the CU on Microsoft website and I begin my patching campaign on all SQL server 2016 instances. The first one is quick & successful. The second one, with R Services, is a little bit different. After,…

 
Read More
Mouhamadou Diaw

Grid Infrastructure 11.2.0.3 PSU: My Opatch version check is failing

By | Database Administration & Monitoring | No Comments

Last day I was configuring grid infrastructure 11.2.0.3 for a standlone server. After the installation, I decided to apply the Patch Set Update 11.2.0.3.7 (Includes Database PSU 11.2.0.3.7) – 16742216 In the documentation it is marked You must use the OPatch utility version 11.2.0.3.4 or later to apply this patch. Verifying my opatch version, I see that I have to update it [root@ ]# ./OPatch/opatch version Invoking OPatch 11.2.0.1.7 OPatch Version: 11.2.0.1.7 So I download…

 
Read More
Mouhamadou Diaw

Grid Infrastructure 12.2: Are all Redhat 7 kernels compatible?

By | Database Administration & Monitoring | No Comments

In this blog I am going to share an issue I had when installing grid infrastructure 12.2 on Redhat 7.3. I was configuring grid infrastructure 12.2 for a standlone server. Below the release and the version of my operating system root@dbserver /etc $ cat redhat-release Red Hat Enterprise Linux Server release 7.3 (Maipo) root@dbserver ~ $ uname -a Linux dbserver 3.10.0-514.21.2.el7.x86_64 #1 SMP Sun May 28 17:08:21 EDT 2017 x86_64 x86_64 x86_64 GNU/Linux root@dbserver ~…

 
Read More
Joël Cattin

PostgreSQL 10 Beta 1 : pg_hba_file_rules view

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

This small blog to share a helpful stuff with the pg_hba.conf file : The pg_hba.conf file is the central configuration file to control client authentication. It is located in the database cluster’s data directory : postgres@ppas01:/u02/pgdata/PG10BETA1/ [PG10BETA1] ll pg_hba.conf lrwxrwxrwx. 1 postgres postgres 59 Jun 30 10:19 pg_hba.conf postgres@ppas01:/u02/pgdata/PG10BETA1/ [PG10BETA1] When you add or modify an entry in this file, you have to reload the cluster to take the changes in account : postgres@ppas01:/u02/pgdata/PG10BETA1/ [PG10BETA1]…

 
Read More
Daniel Westermann

Summer, autumn and winter: a lot of conferences ahead

By | Database Administration & Monitoring | No Comments

It is hot in Europe, it is summer, enjoy, but technology moves fast so you have the chance to already prepare for the next conferences. The IT Tage 2017 will happen the 11th to 14th of December this year and we are happy to be there again. This event covers a wide range of topics and we will be there again covering and talking about: Stéphane Haby, SQL Server 2017: Überblick Stéphane Haby, SQL Server:…

 
Read More
William Sescu

OUD 11.1.2.3 – ODSM Session Timeout

By | Application integration & Middleware, Database Administration & Monitoring | No Comments

The ODSM is a quite powerful tool for managing the Oracle Unified Directory, and quite a lot of default settings are very reasonable. But there is one that disturbed me from the beginning. It is the ODSM Session Timeout. You might see a message like the following. Or maybe this one. It just says, that the page will expire unless a response is received within 2 minutes. Doing some complex searches or similar stuff often…

 
Read More
Olivier Toussaint

DBSAT un outil pour la sécurité de vos bases de données Oracle

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

Qu’est-ce que DBSAT ? C’est un outil gratuit d’Oracle que vous pouvez télécharger sur My Oracle Support avec comme référence : Doc Id 2138254.1. Il a pour but d’évaluer la sécurité de vos bases de données Oracle en analysant la configuration et les stratégies de sécurité mise en place afin de découvrir les risques liés à la sécurité. Comment cela fonctionne t-il ? Dans un premier temps il sera nécessaire de collecter les informations de…

 
Read More
William Sescu

OUD 11.1.2.3 – How to create an OUD Start/Stop/Status script on Oracle Linux 6

By | Database Administration & Monitoring | No Comments

One of the questions that pops up immediately, after you have installed your OUD successfully is how to integrate it into the automatic startup routines of the OS. My example here show how to do it on Oracle Linux 6. On Oracle Linux 7 it looks a little different. Fortunately, Oracle delivers a script called “create-rc-script”, which can be found in your asinst home directory. It lets you specify the user name under which the…

 
Read More
Daniel Westermann

A first look at EDB Postgres Enterprise Manager 7 beta – Connecting a PostgreSQL instance

By | Database Administration & Monitoring | No Comments

In the last post we did a click/click/click setup of the PEM server. What we want to do now is to attach a PostgreSQL instance to the PEM server for being able to monitor and administer it. For that we need to install the PEM agent on a host where we have a PostgreSQL instance running (192.168.22.249 in my case, which runs PostgreSQL 10 Beta1). Lets go …  

 
Read More