Database Administration & Monitoring MongoDB Installation 12.02.2016 by DevOps In this blog posting we will see how to install MongoDB on a Linux distribution. MongoDB is supported for Linux, Mac, Windows and Solaris. Linux distribution First, determine your Linux distribution in order to download the appropriate MongoDB binaries. cat(…)
Database Administration & Monitoring The dbi services PostgreSQL reference architecture (2) – The community approach 09.02.2016 by Daniel Westermann In the last post I looked at how dbi services designs a PostgreSQL architecture based on the products of EnterpriseDB. In this post I’ll look at the same questions but using pure community tools. If you(…)
Database Administration & Monitoring The dbi services PostgreSQL reference architecture (1) – The commercial approach 07.02.2016 by Daniel Westermann When it comes to designing a PostgreSQL architecture that fits your requirements there are a couple of things to think about: Do you need a HA setup? How shall backups and restores being done and how shall all of these(…)
Database Administration & Monitoring, Database management SQL Server AlwaysOn : the registry is also important for availability groups 06.02.2016 by Microsoft Team A couple of months ago, we experienced with my colleague Nathan Courtine a weird issue at one of our customers. This issue concerned an AlwaysOn availability group and more precisely to the WSFC cluster layout. I(…)
Database Administration & Monitoring, Development & Performance, Oracle Enable 10046 Tracing for a specific SQL 05.02.2016 by Clemens Bleile Available methods to enable 10046 trace are described in My Oracle Support Note 376442.1. You can enable 10046-tracing – on session level (alter session) – for other sessions (e.g. with oradebug, the package DBMS_MONITOR or DBMS_SYSTEM) What is not(…)
Database Administration & Monitoring SQL Server Tips: Find sql logins when “windows authentication only” is enabled 05.02.2016 by Stéphane Haby 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(…)
Database Administration & Monitoring SQL Plan Directives strikes again 04.02.2016 by Oracle Team By Franck Pachot . 12c SQL Plan Directives, a side effect, a bad application design, a bug... and the occasion to show how to quickly troubleshoot. An application has long response time since 12c migration. No blind guesses, no reason(…)
Database Administration & Monitoring About OCR backup 04.02.2016 by Oracle Team By Mouhamadou Diaw Last day Franck and me were discussing about OCR backup Let’s take a 2 nodes RAC. We can see that OCR backup is automatically done by oracle in only one node on local (with a certain frequency(…)
Database Administration & Monitoring EDB Postgres Advanced Server 9.5 new features – Profiles 03.02.2016 by Daniel Westermann The just released version of EDB Postgres Advanced Server 9.5 introduces profiles very much the same as in Oracle. Lets have a look at it. As in Oracle there is a default profile: (enterprisedb@[local]:5445) [postgres] > x Expanded display(…)
Database Administration & Monitoring DBI Tail v1.2 now released ! 01.02.2016 by Middleware Team Dear IT colleagues, We regularly have to read log file contents either to understand software functioning or for debugging purpose. Most of the time we access same log files located in same servers. It is very painful to login every(…)