Infrastructure at your Service

David Hueber

Linux: easing the process and performance monitoring with htop

By | Operation systems | No Comments
 

I’m pretty sure that most of you already struggled with some low performance systems. In order to analyse such cases several tools and utilities, like top, nmon, fuse or lsof are available under Linux. However trying to dig in processes analysis and looking for files and processes relations may be quite painful.

To get started with performance checks and analysis, a interesting utility is available: htop

Read More
Stéphane Haby

Forefront Endpoint Protection (FEP) 2010 and database policies

By | Database management | No Comments
 

I have seen at a customer that the SQL Server’s policy doesn’t follow the Microsoft’s recommendations about antivirus and databases(kb 309422), such excluding *.mdf,*.ndf and *.ldf files. In addition the policy for Oracle doesn’t exist in case of Forefront Endpoint Protection 2010 known as FEP 2010.

I have decided to create databases policies for FEP optimized by dbi services to be generic and adapted to all SQL Server and Oracle environments.

Read More
Jérôme Witt

Oracle SQL Developer & SQL Data Modeler on Ubuntu

By | Application integration & Middleware | No Comments
 

Oracle SQL Developer and Data Modeler are becoming more and more popular as they are both cost-free and available on many Operating Systems (Linux/Unix,Windows and Mac) with different installation types: “This zip does not include JRE” or “This zip file includes the JRE”. On linux, the choice is limited because the only version available doesn’t include Java Runtime Environment. And it’s an RPM !! So what… In this post I will provide all information required to install and run these tools on an Ubuntu machine.

 

Read More
Stéphane Haby

SQL Server 2012 ‘Denali’: a new panel of DMVs

By | Database management | One Comment
 

Dynamic management views (DMVs) return server state information that can be used to monitor the health of a server instance, diagnose problems and tune performance.
Since few months, I test the future new version SQL Server 2012 codename Denali and I was very surprised form the news DMVs from this version.
I will just explain some DMVs very interesting for a DBA.
My article is based on msdn web site reference and you find in the end from each chapter a msdn reference for more details of the DMV.

Read More
Yann Neuhaus

Oracle RunInstaller crashes while installing Cloud Control 12c on OEL 5.7

By | Database management | 7 Comments
 

A few days ago I downloaded the Cloud Control 12c binaries for Linux x86_64 from the Oracle Technet.

My friend, Hervé Schweitzer, configured an OEL 5.7 VM for test purpose and I was quite eager to install this new software. I checked the O.S settings, the required parameters, aso …, everything was fine. My OMS repository database (11.2.0.3) was ready. Unfortunately, as soon as I started the installer, it directly crashed.

Read More