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.

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
Pierre Sicot

EM13c Gold Agent Image

By | Database Administration & Monitoring | No Comments
 

 One of the most interseting new feature in Enterprise Manager 13c is the Gold Agent Image. This new feature will simplify the agent management. The first thing to do is to create a Gold Agent image, from the setup menu , select Gold Agent Image: Then select Manage All Images: Select Create Enter the image name, a description and the platform name, then submit: Your gold image is created: Before to subscribe an agent, we…

Read More
Pierre Sicot

EM13c and Management Pack Annotations

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

 Enterprise Manager 13c offers a new feature allowing displaying the management packs used by a feature. To enable the Management Pack Annotations, you select Enable Annotations from the Setup Menu –> Management Pack: From now on your menus are filled up with acronyms more or less comprehensive, from a performance page on a target database:   From now on your menus are filled up with acronyms more or less comprehensive, for example from a performance…

Read More