Infrastructure at your Service

Tag

DBA Archives - Page 3 of 6 - Blog dbi services

Sep 22 2016
Saïd Mendi

MySQL 8.0.0 DMR – First impression

By | Database management | One Comment

Last week (09/12/2016) was announced the new MySQL 8.0.0 DMR (Development Milestone Release) It is now available for download at dev.mysql.com I downloaded and installed it Following are my first impression on some new features First of all, when you remember the size of earlier versions, it is more & more gluttonous, see below mysql-5.0.96-linux-x86_64-glibc23.tar.gz    121.2M mysql-5.1.72-linux-x86_64-glibc23.tar.gz    127.8M mysql-5.5.52-linux2.6-x86_64.tar.gz            177.2M mysql-5.6.33-linux-glibc2.5-x86_64.tar.gz    299.7M mysql-5.7.15-linux-glibc2.5-x86_64.tar.gz   611.8M mysql-8.0.0-dmr-linux-glibc2.12-x86_64.tar.gz is around 1Gb and uncompressed 3.6Gb (Oups…) At…

Read More
Jul 29 2016

DBA essentials workshop with release Oracle 12c is Available

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

It’s with pleasure to announced dbi services have upgrade the infrastructure for Oracle DBA essentials workshop. We have migrate the release of Oracle 11g R2 to the latest version Oracle 12c features and install the last PSU (April 2016). During this course you understand different topics: Understand the Oracle database architecture Install and Manage Oracle database Administer Oracle databases with dbi expert certified OCM or ACE director 🙂 For more information about the workshop, please…

Read More
Feb 05 2016
Stéphane Haby

SQL Server Tips: Find sql logins when “windows authentication only” is enabled

By | Database Administration & Monitoring | No Comments

A customer asks me to find all sql logins enabled on servers where windows authentication only is enabled. The goal is to clean sql logins on all servers through the CMS (central management server). In some cases, sql logins are created even if the authentication is set to “Windows authentication only mode”. I think that this query is interesting and I will just share it with you. DECLARE @value INT USE [master] EXEC xp_instance_regread N’HKEY_LOCAL_MACHINE’,…

Read More
Dec 04 2015
Nicolas Jardot

How to read XML database alert log?

By | Database Administration & Monitoring | No Comments

Since Oracle 11g, Oracle maintains two copies of the database’s alertlog in ADR: a flat text file in the sub-directory trace and an XML like in the folder alert. I had a case recently at a customer where the log.xml was moved to another place and compressed for archiving reason. As the regular text file was not containing old data, the goal was to exploit the archived XML -like file. When the file is still located…

Read More
Nov 26 2015
Stéphane Savorgnano

SQL Server 2016 CTP3.0: Stretch Database enhancements

By | Database management, Technology Survey | No Comments

Some months ago, my colleague Nathan explained you the bases of the new Stretch Database functionality via two blogs here and here. With the new SQL Server 2016 CTP 3.0, Stretch Database now includes new features and enhancements that I will sow you in this blog.   In previous versions of SQL Server 2016 CTP 2.x, before to be allowed to Enable Stretch Database, you had to enable the “Remote Data Archive” option for the…

Read More
Nov 13 2015

Instance fails to start automatically

By | Database Administration & Monitoring | One Comment

Recently at a customer I was confronted with a problem of restarting the Oracle Database 12c automatically on a Windows Server 2008 R2 x64. I installed Oracle 12.1.0.1.0 with a user of service in a domain who has member of the Group ORA_DBA. The authentication service is correctly set with the NTS parameter in the sqlnet.ora file. This Installation has been successfully but after a reboot we can see the database are not OPEN. [email protected]********:C:\Users\oracle\…

Read More
Nov 10 2015

Oracle DBA Essentials Workshop – Patchset 11.2.0.4 Available

By | Database Administration & Monitoring | No Comments

We have Upgrade our Environment Oracle DBA Essentials Workshop of release 11.2.0.3 to 11.2.0.4. From now on, you can operates the various subjects on the new release. In this article, I present you the procedure to be followed for the upgrade of your database: Update DMK to the version 14-10 Upgrade database Install Oracle Patchset 11.2.0.4 and PSU Update DMK 14-10 The first step it’s update Data Management Kit, included dmk_sql. We need to Download,…

Read More
Jul 10 2015
Daniel Westermann

ACFS 12.1.0.2 on Oracle Linux 7.1

By | Database Administration & Monitoring | 2 Comments

Recently we wanted to create an ACFS filesystem on a brand new 12.1.0.2 GI installation on Oracle Linux 7.1. According to the documentation this should not be an issue as “Oracle Linux 7 with the Unbreakable Enterprise kernel: 3.8.13-33.el7uek.x86_64 or later” is supported. The “or later” is the important point. In our case: uname -a Linux racp1vm1 3.8.13-55.1.6.el7uek.x86_64 #2 SMP Wed Feb 11 14:18:22 PST 2015 x86_64 x86_64 x86_64 GNU/Linux   Should be fine as…

Read More