Infrastructure at your Service

dbi services BLOG

Welcome to the dbi services Blog! This IT blog focuses on database, middleware, and OS technologies such as Oracle, Microsoft SQL Server & SharePoint, EMC Documentum, MySQL, PostgreSQL, Sybase, Unix/Linux, etc. The dbi services blog represents the view of our consultants, not necessarily that of dbi services. Feel free to comment on our blog postings.

Philippe Schweitzer

PKI – SSL certificates management with Java keytool and OpenSSL

By | Application integration & Middleware, Development & Performance | No Comments
 

  In this blog, we will cover all steps to enable SSL encryption for a particular server. The procedure described here applies mostly for Java based servers and applications, with usage of a keystore. In the case the organization into which the certificate has to be deployed has its own PKI, usage of OpenSSL is not necessary. In this case Java keytool usage will be enough. In the case you have to sign by yourself,…

Read More
Morgan Patou

Alfresco – Protect your installation with Apache httpd

By | Application integration & Middleware | No Comments
 

 In this blog, I will talk about the setup of an Apache httpd server with/without SSL configuration on top of your Alfresco installation. This way of configuring Apache httpd in front of your Web Application can be reused very easily for all other applications like your intranet, competency center, resource planning, aso… It is NOT specific to Alfresco and this is what makes this blog very useful! When you install Alfresco using the installer provided,…

Read More
Franck Pachot

SYS password on Oracle Cloud Service managed database

By | Database Administration & Monitoring | No Comments
 

 When you create a DBaaS on the Oracle Cloud services you have to provide an administration password in the database configuration form. You do not need a password to connect to the VM. You use SSH key for it: on creation you provide the public key that will allow you to connect as the oracle user or the opc user (which can ‘sudo su’). But for the database you need to provide a password which…

Read More
Stéphane Haby

SQL Server 2005 decommissioning failed!

By | Database management | No Comments
 

 The support for SQL Server 2005 is no more available, so we are migrating all the latest databases running under SQL Server 2005 to SQL server 2012 or higher! Last time, I had to uninstall an old SQL Server 2005 clustered instance in a 64 bits architecture on Windows Server 2008R2. In fact, this clustered environment contains many other instances (either SQL Server 2005 or 2008 R2). But during the uninstallation, an error happened…. First,…

Read More
Daniel Westermann

A near zero downtime, near zero impact major release upgrade using Oracle GoldenGate

By | Database Administration & Monitoring | No Comments
 

 In this post I’d like to share what we did for a customer who had the following requirements: Use Oracle GoldenGate Upgrade an Oracle 10.2.0.4 database running on Solaris 10 SPARC to Oracle 12.1.0.2 running on Exadata Keep the downtime as small as possible Minimize the impact on the production database as much as possible I will not describe why GoldenGate was the product of choice nor will I describe how we verified that Golgengate…

Read More
Stéphane Haby

SQL Server 2016: new tools management strategy

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

 A lot of customer’s feedbacks are about difficulties to find easily SQL Server tools. Now, it is easier… A unified web page for SQL Server Tools The first good news is that Microsoft unified and gathered these tools for SQL Server on a single web page: https://msdn.microsoft.com/en-us/library/mt238365.aspx As DBA, this page is absolutely to be marked in your browser. The two major tools, SQL Server Management Studio (SSMS) and SQL Server Data Tool (SSDT), are…

Read More
Daniel Westermann

A look at PostgreSQL 9.6 – psql gexec

By | Database Administration & Monitoring | No Comments
 

 This little, but powerful, enhancement that it made it in PostgreSQL 9.6 is probably nothing a application can benefit of. But it can be huge saving for people doing maintenance operations on a PostgreSQL instance. It is the addition of the “gexec” meta command to psql. If you want to read where this comes from and how it evolved you can read the mail thread on hackers.

Read More
Daniel Westermann

A look at PostgreSQL 9.6 – Killing idle transactions automatically

By | Database Administration & Monitoring | No Comments
 

 A common issue with databases: The guy at floor 2 did some work on the database and then rashly left for lunch because the lady on floor 1 is already waiting for him. Unfortunately he did not close his transaction and now his session is blocking others. In PostgreSQL this might be even worse as all tuples modified by this transaction are not available for vacuum until the transaction is either committed or aborted. In…

Read More
Daniel Westermann

A look at PostgreSQL 9.6 – progress reporting for VACUUM operations

By | Database Administration & Monitoring | No Comments
 

 Vacuum in PostgreSQL is one of the most important points to consider when managing a PostgreSQL instance. Usually vacuum is running in the background and just gets the job done. But, as always, there are situations when you need to get a closer look at what is going on. PostgreSQL 9.6 (currently in Beta1) introduced a new view which allows to see the progress of the vacuum worker processes. Lets have a short look at…

Read More