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.

Stephane Biehler

Documentum Administrator UCF Troubleshooting

By | Application integration & Middleware | No Comments
 

 Maybe you had some issues with UCF in DA as me. I had this for no reason since few days at a customer. The problem was that we use SSL with DA and the Unified Content Facilities (UCF) wasn’t happy about it. Thus, in this short blog I’ll speak about troubleshooting UCF. The error I got happened when trying to edit, view or create documents; I had a popup saying an error occured with UCF….

Read More
Stéphane Haby

Neue Datenbank Konsole Befehle (DBCC) CLONEDATABASE

By | Database Administration & Monitoring, Technology Survey | No Comments
 

 Sie haben es vielleicht noch nicht gesehen, aber mit den Service Pack 2 von SQL Server 2014 gibt es einen neuen DBCC Befehl: CLONEDATABASE. „DBCC CLONEDATABASE sollte Kopien eines Schemas und den Statistiken einer Produktionsdatenbank erstellen, um bei Leistungsproblemen Abfragen zu untersuchen.“ MSDN Quelle finden wir hier. Dieser Befehl kann nur Benutzedatenbanken klonen. Wie Sie sehen, für die Systemdatenbanken ist es nicht möglich, denn es treten Fehlermeldungen auf: Msg 12603, Level 16, State 1, Line…

Read More
Philippe Schweitzer

Java reflection: Get classes and packages names from a root package within a custom URLClassloader

By | Development & Performance | No Comments
 

  I have got a case for which I needed to use a custom Classloader, in order to find the list of classes and packages available across several software plugins materialized by a set of jar files. These jar files are intended to be located inside a particular place. After googling, some solutions invited us to deploy external libraries. But I was not interested to manage another lib in my soft just for that purpose….

Read More
Nathan Courtine

Generate Azure VM with Resource Manager deployment in PowerShell

By | Database Administration & Monitoring, Hardware & Storage, Operation systems | No Comments
 

 Recently, there is a new way to manage the Azure infrastructure with Resource Manager. It brings many advantages regarding the classic deployment. The differences between these two deployments will not be covered in this blog because it is not the initial goal, and it already exists a very good Microsoft topic on this subject. In this blog, we will generate a new Windows Azure Virtual Machine using Resource Manager deployment with PowerShell from On-Premise. Remember,…

Read More
Pierre Ochsenbein

Windows: Sauvegarde RMAN sur un disque partagé

By | Database Administration & Monitoring | No Comments
 

 Dans ce blog, je vais vous expliquer comment exporter les backups RMAN sur un « share disk » appartenant à un Domaine. Assurer la sécurité des données est l’une des tâches principales de l’administrateur : La mise en œuvre d’une protection des fichiers sensibles de la base : Fichier de contrôle Fichiers de journalisation La mise en place d’une stratégie de sauvegarde/récupération : Adaptée aux contraintes de l’entreprise Testée et documentée. Afin de vous documenter sur les différentes techniques de sauvegarde…

Read More

List usernames instead of uids with the ps command for long usernames

By | Database management, Operation systems | No Comments
 

 Have your ever faced such a situation. You have usernames in your /etc/passwd file with more than 8 characters. This is no problem for Linux at all, usernames may be up to 32 characters long, only your ps output might look a little scrambled. It shows you the uid instead of the username like in the following example: $ id uid=20001(longuser01) gid=10002(oinstall) groups=10002(oinstall) $ sleep 1000000 & $ ps -ef | grep sleep | grep…

Read More

How to do a Filesystem Resize (ext3/ext4) on Redhat running on VMware

By | Database Administration & Monitoring, Operation systems | No Comments
 

 A filesystem resize can be done in several ways, online, offline, with LVM2 or without LVM2.  However, this blog will describe how to do an online resize of ext3/ext4 filesystems where a virtual disk (vmdk) is online added to a VMware Redhat guest OS. So let’s start with the online filesystem resize of ext3/4 filesystems on the Redhat guest OS.  A new virutal disk (preferably an eagerd zero thick on VM running Oracle) was added…

Read More
David Barbarin

SQL Server AlwaysOn: troubleshooting improvements with new service packs

By | Database Administration & Monitoring | No Comments
 

 As promised in my latest blog, I will talk about improvements in the detection of the availability group replication latency. As a reminder, replication latency between high available replicas may be monitored in different manners so far. Firstly, in my experience I had the opportunity to use different performance counters as “Database Replica:Transaction Delay” and “Databas Replica:Mirrored Write Transactions/sec” in order to get a good picture of the latency over the time after implementing an…

Read More