Infrastructure at your Service

Pierre Sicot

Migrating to Oracle OEM Cloud Control 12.1.0.2.0

By | Database management | One Comment

I recently upgraded from Enterprise Manager Cloud Control 12.1.0.1.0 to the most recent version 12.1.0.2.0. This document describes the migration procedure and the different problems encountered. The first point to know when you are about to upgrade an existing Enterprise Manager Cloud Control 12c is that Oracle Installer will create a new Middleware home. Thus, you will need to have enough free disk space (around 7 GB) on your system to be able to upgrade…

Read More
Arnaud Berbier

Oracle APEX 4.2 HTML 5 item types

By | Application integration & Middleware | No Comments

In this blog, I will explore the HTML 5 new item type features of Oracle APEX 4.2. The objective is to use the new number, e-mail, phone number and url html 5 item type and the native browser validation capability. I have created a new database application with the theme 25 which fatures responsive design principles (auto adjusts to the screen dimensions and works well on desktop, tablet and mobile devices). Nice Themes! To continue…

Read More
Open source Team

Barman: une solution pour vos backups PostgreSQL

By | Hardware & Storage | 3 Comments

L’objet de ce posting est de décrire la mise en place et l’utilisation d’un gestionnaire de sauvegarde pour un cluster de  base postgresql. Barman – acronyme de “backup recovery manager”- pour PostgreSQL est le logiciel sur lequel nous nous pencherons. C’est un outil permettant de centraliser la gestion des sauvegardes dans une situation avec plusieurs serveurs. La société 2ndQuadrant est à l’origine de ce projet qui a été financé par une aide de la CEE….

Read More
Nicolas Jardot

UKOUG 2012: Day 2 – Not only about Oracle Optimizer (CBO)

By | Technology Survey | No Comments

Yesterday was a very busy day at UKOUG 2012: many technical sessions about performances and also a time travel back in the evening. I really like sessions about performances (Oracle Optimizer) and Oracle behinds, but I will not focus on the technical side because it will take too much time (maybe in future blogs!). I will just summarize a little the main interesting topics. I had the opportunity to attend several sessions during this day…

Read More
Nicolas Jardot

UKOUG 2012: Day 1 – Oracle 12c features and database performance

By | Technology Survey | No Comments

Today was the official launch of UKOUG 2012. We started with keynotes including one from Tom Kytes giving information about Oracle 12c features. Then I had some very interesting sessions on database performance. Oracle 12c When we talk about performance issues on SQL statement, it’s really often due to bad/missing statistics and Oracle using the wrong execution plan. In next Oracle database two features may (or not) help us to deal with this topic: Enhanced statistics…

Read More
Stéphane Savorgnano

SQL Server 2012 SP1: First Cumulative Update (CU1) now available

By | Technology Survey | No Comments

A couple of days ago (20 November 2012), Microsoft rolled out the first cumulative update (CU1) for SQL Server 2012 Service Pack 1 (SP1). It’s just two weeks after the release of the first Service Pack (SP1) we are talking about here. What this first CU for SQL Server 2012 SP1 features: This CU1 contains 44 hotfixes: 33 for the Engine 3 for SSAS 4 for SSRS 4 for SSIS If you want to have…

Read More
Nicolas Jardot

OakTable at UKOUG 2012: Hybrid Columnar Compression (Exadata), SQL tuning, etc.

By | Technology Survey | No Comments

Yesterday, I went to a set of sessions organized by OakTable members just before the kick-off of the UKOUG conference 2012, one of the biggest events on Oracle Technology and E-Business in Europe. This post focuses on some of the covered topics, such as database development, Hybrid Columnar Compression (Exadata), optimizer statistics, and SQL tuning. There were 2 streams with very interesting topics. I attended to sessions covering the following topics: Application development: Keep it…

Read More
Gérard Wisson

DOAG 2012: News on WebLogic 12c, monitoring, licensing

By | Application integration & Middleware | No Comments

I spent three interesting days at the DOAG Konferenz 2012 – the German Oracle User Group’s conference. It was the 25th birthday and my first time as a DOAG Konferenz speaker. In this post, I will not talk about my presentation, but rather give you information from the sessions I went to. I will talk about three areas: Oracle WebLogic 12c, monitoring & diagnostics, and licensing. Regarding WebLogic, Mr. Munz from munz & more described…

Read More
Yann Neuhaus

DOAG Konferenz 2012 – mein Fazit: wärmstens zu empfehlen!

By | Technology Survey | No Comments

Die DOAG Konferenz 2012 ist vorbei. Wie immer war sie sehr bereichernd! Wir von dbi services hatten dieses Jahr über drei Präsentationen die Gelegenheit, unser Wissen in den Bereichen Cloud Control 12c – Thema: Datenbank-Backup und Handling des Java-Diagnostic-Tools JVMD (Gérard Wisson) – sowie Linux Container (David Hueber) an die Teilnehmer weiterzureichen. dbi services hat ebenfalls seinen Beitrag zum Treffen der Schweizer Oracle User Group (SOUG) geleistet, einem unter anderem durch das Engagement unseres Partners…

Read More
Stéphane Savorgnano

Risk and Health Assessment Program for Microsoft SQL Server

By | Database management | One Comment

I recently had the chance to go through a so called Risk and Health Assessment Program for Microsoft SQL Server (SQLRAP) at one of our clients. The SQLRAP assesses your SQL Server implementations to ensure proper productive use. It is an excellent opportunity to review the best practices and perform a validation of your client environment by a Microsoft SQL Server Engineer. The SQLRAP program will collect data from the SQL Servers, perform a very thorough analysis,…

Read More
Arnaud Berbier

Oracle Apex 4.2 now released

By | Application integration & Middleware | No Comments

Oracle Apex 4.2 is now available on the Oracle Website. It is available since 12 october 2012. This new release comes with new features briefly described in this blog posting. First of all, here are the new features delivered by the Apex 4.2 release. HTML 5 and CSS 3 improvements: Relooking of all the administration workspace Html 5 charts Html 5 item types (number, e-mail, telephone and URL) New Html 5 themes Mobile support with…

Read More
Oracle Team

Unable to resize tmpfs on Oracle Enterprise Linux 6 versions

By | Operation systems | 4 Comments

I recently helped to create a lab dedicated to a training about Oracle backup and recovery, with Oracle 11g databases. While creating several databases on an Oracle Enterprise Linux 6.1, I wanted to resize the tmpfs to allocate more memory to the databases for AMM (Automatic Memory Management). That was a small challenge … By default, the value of the tmpfs is the half of the installed memory. So, on my 3 GB memory sized…

Read More