Infrastructure at your Service

 
Yann Neuhaus

Oracle Enterprise Manager 12c: creation and management of administrators through emcli

By | Database management | No Comments

Cloud Control 12c (and the former Grid Control 11g) offers the possibility to create administrators and manage their privileges through the “emcli” command line utility. The main advantage of this method (based on scripts) is to be able to reproduce the creation of the users as soon as a new Cloud Control infrastructure must be built up (for instance in order to migrate Grid Control 11g on Windows to Cloud Control 12c on Linux). Indeed,…

Read More
Stéphane Haby

SQL Server 2012: new permissions

By | Technology Survey | No Comments

For this end of the year, I decided to present you the new permissions on SQL Server 2012. How to have a list of all permissions ? It’s very simple with this query: SELECT * FROM sys.fn_builtin_permissions(”) SQL 2008 R2 SQL 2012 With this comparison, you can see that there are 19 new permissions in SQL Server 2012. To have a great overview, I prefer use this query ordering by the class description: SELECT class_desc,count(*) as Permission_Number…

Read More
Arnaud Berbier

UKOUG 2012: Middleware

By | Application integration & Middleware | 2 Comments

I had the opportunity to spend two days in England (Birmingham) to participate in the UKOUG 2012. My first day was the Middleware sunday. This event is related to technical content and feedback for WebLogic administrators. It was an interesting day with useful feedback related to Oracle WebLogic. This Sunday middleware agenda event was as follows: WebLogic Sctripting Tool – Taking WLST to the Next Level (Simon Haslam, Veriton Limited) Node Manager under the Covers…

Read More
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