Infrastructure at your Service

 
Stéphane Savorgnano

Monitoring SQL Server with Oracle OEM Grid Control 11g

By | Database management | One Comment

Recently, I had the chance to install the SQL Server Plug-in for Oracle Entreprise Management Grid Control 11g to monitor a SQL Server instance based on a windows host. Our client, who monitors these Oracle databases via OEM Grid Control 11g, wanted to use the same tool to also monitor SQL Server databases. In this blog posting, I will describe how to install the 11g agent on a Windows host and how to import as…

Read More
Oracle Team

Oracle RAC 11.2.0.2: A disturbing loop in a “ohasd” startup script

By | Operation systems | No Comments

Last February, I performed an operating system rolling upgrade on a four-nodes RAC cluster (11.2.0.2). I then faced a strange problem when restarting the operating system… The first step of the procedure was to stop all Grid Infrastructure and Database services running on the first node as well as to disable Cluster and ASM autostart. The following command is supposed to prevent Oracle High Availability Service (OHAS) to be run at operating system startup: #…

Read More
Stephane Biehler

OpenERP release 7.0: Not just an update

By | Technology Survey | No Comments

OpenERP release 7.0, which just came out, shows some real advantages in terms of accessibility. By refining the website, OpenERP wants to prove that the new release is not merely an update but a new product with a new mind-set. The new features Indeed, the ERP’s web interface is now purified and simplified to match the fashions. Today’s user interfaces are intended to be as simple and as designed as possible. The new web interface…

Read More
Middleware Team

Boot sequence for all Linux-based operating systems

By | Operation systems | No Comments

In this bog posting, I will present a boot sequence that works for all Linux-based operating systems – from switching on the power to the login screen.   7 steps There are 7 steps for Linux startup: Power on Obviously, first of all, you have to switch on your computer, then: Each sub process will execute the following one It is the same process for all Linux distributions Close to BSD and Unix style from…

Read More
Yann Neuhaus

Frankfurter Datenbanktage: Andrea Held im Gespräch mit Yann Neuhaus, dbi services

By | Technology Survey | No Comments

Vor einigen Wochen hatte ich im Rahmen der Frankfurter Datenbanktage Gelegenheit zu einem Interview mit Andrea Held, der fachlichen Leiterin des Events und Geschäftsführerin der Firma Held Informatik. Das Ergebnis des Gesprächs ist dieses Video, in dem Sie mehr über dbi services, das schnelle Wachstum unserer jungen Firma und unser Dienstleistungsportfolio erfahren. Gucken Sie doch mal rein, falls Sie wissen wollen, wie dbi services “tickt” :roll:. Nochmals vielen Dank an Andrea Held für das interessante…

Read More
Oracle Team

Scripts to duplicate an Oracle database virtual machine: step two

By | Hardware & Storage | No Comments

In January, I promised to show you the next step of a procedure to manage templates with Virtual Box. Don’t worry, I have not forgotten but I was very busy! This step, the final one, consists on customizing of a virtual machine configuration at the start. VMware does it with Templates on ESX, using for example Sysprep for MS Windows guests. I am going to show you how to do it with one simple text file….

Read More
Stéphane Savorgnano

SQL Server 2012: Create & replay a trace with Distributed Replay

By | Database management | One Comment

My last blog was about installing and configuring Microsoft SQL Server 2012 Distributed Replay. This time, I will show you how you can create a trace and replay it with Distributed Replay Clients on a specific SQL Server target. This is my Distributed Replay configuration:   Creation of the trace I will use the two Distributed Replay clients to generate a workload against the target server with two PowerShell Windows which will execute diverse SQL…

Read More
Stéphane Savorgnano

SQL Server 2012 SP 1: Third Cumulative Update (CU3) available

By | Technology Survey | No Comments

Three weeks ago, Microsoft published the third Cumulative Update (CU3) for Microsoft SQL Server 2012 Service Pack one. As usual, if this Cumulative Update solves an issue you are facing, install it quickly – otherwise, do not install it. Which issues are covered by this CU3? It contains 38 Hotfixes: 27 for the Engine 8 for SSAS 3 for SSRS To have more details or information about these hotfixes, click here. Historic of SQL Server 2012…

Read More
Oracle Team

Oracle Database Appliance: new ODA X3-2 architecture

By | Operation systems | No Comments

A few weeks ago, I posted an article about Oracle Database Appliance, focusing on ODA version 2.5.0.0.0. However, a new update of ODA, version 2.5.5.0.0, was released by Oracle on 5 March. This posting will focus on the new ODA release, which leads to a new hardware architecture. So, what’s new with this new ODA version? According to the Release Notes, ODA now supports the new X3-2 architecture which allows additional hardware and storage capabilities. Physical…

Read More
Stéphane Savorgnano

SQL Server 2012: Installing and configuring Distributed Replay

By | Database management | No Comments

Distributed Replay is a new fonctionality of Microsoft SQL Server 2012. It helps you assess the impact of future upgrades (SQL Server, hardware, OS) or SQL Server tunings by replaying a trace captured from a productive SQL Server environment to a new SQL Server test environment. This new functionality is similar to SQL Server Profiler, but with more possibilities: e. g. replaying the trace from multiple clients (up to sixteen), use a stress or  synchronization…

Read More
Oracle Team

Oracle Database Appliance (ODA) – an overview

By | Operation systems | No Comments

Last february, I had the chance to attend an Oracle presentation about ODA: Oracle Database Appliance. I found it interessant to share what I have learned about this technology. Which, I confess, convinced me. Summary Before developing the software and hardware components, here is a small overview of ODA. ODA is an all in one solution providing Hardware, Operating System, and database components. It comes in a 4U rack server form, composed of two distinct…

Read More
Jérôme Witt

Frankfurter Datenbanktage: Bei dbi services hat Ostern schon begonnen…

By | Database management | No Comments

Ganz klar: Unser dbi services Goldhase war das inoffizielle Maskottchen der Frankfurter Datenbanktage! Der Nachfrage nach zu urteilen war es sowohl ein Augen- als auch ein Gaumenschmaus … wir haben auch schon eines “geschlachtet” und brüderlich geteilt. Wir waren in 3 Sessions aktiv und hatten die Freude, viele interessierte Teilnehmer an unserem Stand zu begrüssen! Stéphane Haby hat in seiner Session ein neues SQL Server Monitoring-Tool für Microsoft DBAs vorgestellt: “SQL Server Management Datawarehouse”. Die…

Read More