Infrastructure at your Service

Nicolas Jardot

UKOUG Tech13 “Super Sunday”: dbi services is here!

By | Technology Survey | No Comments
 

  Today was the first day of UKOUG Tech13: 4 days about Oracle Technology. This year, 7 streams started today (3 last years). I also had a slot to give my presentation about the Optimizer behavior in 12c. The day started with a little delay in registration: My collagues Pierre and Philippe were not correctly registered and didn’t get their badge right away, but everything was solved before the start of the sessions. Speaker time…

Read More
Middleware Team

UKOUG Tech 2013: dbi services won the Weblogic Hackathon contest!

By | Technology Survey | No Comments
 

  Today, we participated in two WebLogic presentations – and won the WebLogic Hackathon contest! But first, let’s talk about the sessions. The first session was a summarized overview of the Weblogic installation process. There are two manners to proceed. On the one hand, you can use a GUI based interface, and on the other, you can use the silent mode. At the end of the presentation, we installed a new Weblogic domain in a…

Read More
Pierre Sicot

UKOUG Day 1: Oracle Optimizer 12c, Cost Based Optimizer, Exadata

By | Technology Survey | No Comments
 

  Today was the first day of the United Kingdom Oracle User Group (UKOUG) – usually called the Super Sunday! I already participated in today’s first session three weeks ago in Geneva, but my colleague Nicolas Jardot was talking about Solving Critical Issues with the 12c Optimizer, covering histogram collection, temporary table statistics and adaptive query optimization. There were around thirty people at his session, and a lot of UKOUG speakers were very interested and…

Read More
Morgan Patou

Developing an archive action for Alfresco Share (1 of 2)

By | Application integration & Middleware | 2 Comments
 

  A few weeks ago when I was working on setting up an Alfresco Community Edition v4.2.c, I came across a problem that took me quite some time. What I will talk about today is the customization of the actions provided by the interface of Alfresco Share. This action was tested on all sub-versions of Alfresco Community Edition 4.2 (a, b, c and d). Unfortunately, Alfresco Share does not provide function to archive content. To…

Read More
Open source Team

Migration d’Oracle vers PostgreSQL avec ora2pg

By | Database management | One Comment
 

  Le propos des trois posts PostgreSQL qui vont suivre, est de présenter: la mise en place d’un outil d’aide à la migration d’une base Oracle, au sens du schéma, vers une base PostgreSQL L’utilisation de cet outil, nommé ora2pg Les difficultés qu’un projet de migration doit affronter Le premier post porte sur l’installation d’ora2pg, un des outils disponibles sur internet. Je vais décrire ici l’installation d’une machine sous linux “OEL 6.3″ que l’on pourrait…

Read More
Arnaud Berbier

Oracle WebTier 12c release

By | Application integration & Middleware | No Comments
 

  I was surprised to see that Oracle WebTier 12c release has been available from OTN since June 2013. It comes with big changes. I guess that marketing Oracle Database 12c encouraged the outcome of newer versions of Oracle Middleware products such as Oracle WebLogic Server 12.1.2, Oracle Coherence 12.1.2, and Oracle WebTier 12.1.2. Oracle WebTier 12.1.2 includes the following features: Oracle HTTP Server (OHS) Oracle WebLogic Web Server Plug-In In this blog posting, will…

Read More
Stéphane Savorgnano

SQL Server 2014 CTP2: In-Memory Advisor for Tables and Stored Procedures

By | Technology Survey | No Comments
 

  One of the best new functionalities of Microsoft SQL Server 2014 is the In-Memory part, which gives you the possibility to load tables and also Stored Procedures in-memory for a very fast response time. The Community Technology Preview 2 from Microsoft SQL Server 2014 went out some days ago with two new Advisors. These Advisors will help you manage the transformation of your disk tables to Memory Optimized Tables as well as your Stored…

Read More
Grégory Steulet

Oracle Audit Vault and Database Firewall (AVDF) 12.1 – installation on VirtualBox

By | Database management | 19 Comments
 

 This blog explains how to install Oracle Audit Vault and Database Firewall (AVDF) 12.1.1.1.0 on VirtualBox step-by-step. The configuration will be covered in a second blog. Download AVDF Binaries First of all, download the binaries on support.oracle.com: https://support.oracle.com/epmos/faces/ui/patch/PatchDetail.jspx?_afrLoop=140865428570210&patchId=16965974&_afrWindowMode=0&_adf.ctrl-state=1a5l4hvifo_4 Patch 16965974: 12.1.1.1.0 FULL INSTALL IMAGES FOR ORACLE AUDIT VAULT AND DATABASE FIREWALL There are three files: 1. Audit Vault Server 2. Database Firewall 3. Documentation You can find the Audit Vault and Database Firewall documentation online…

Read More
Microsoft Team

Collation changes in Microsoft SQL Server are not that simple

By | Database management | 4 Comments
 

 Lots of DBAs are changing the collation of their SQL Server databases without knowing exactly what they do and the consequences of this change. And as they don’t know what they do, they often only perform the small and easiest part of it, changing only the collation on the database. In this blog I will explain the methodology that allows to change the collation of all objects (not only the database) and the consequences of…

Read More
Oracle Team

Oracle Grid Infrastructure 12c: Binaries installation

By | Operation systems | One Comment
 

  In a previous article, I have shown how to configure two servers in order to deploy a two-nodes 12c cluster. This time, I am going to describe the Grid Infrastructure 12c installation process using Oracle Universal Installer (OUI). We assume that cluvfy tool has returned no errors (see previous blog). Install Grid Infrastructure Connect as grid and launch the Oracle Universal Installer (OUI) from /software/grid: $ /software/grid/runInstaller.sh Starting Oracle Universal Installer… Checking Temp space:…

Read More
Open source Team

Pgbarman : gestion de sauvegarde et récupération PostgreSQL

By | Hardware & Storage | No Comments
 

  Fin 2012, j’ai présenté « pgbarman », une solution de sauvegarde et récupération pour PostgreSQL et décrit son installation. Pgbarman fournit un ensemble de commandes vous permettant la mise en œuvre de sauvegardes vers un serveur dédié. Le principal intérêt est à mon sens la gestion d’un catalogue de vos sauvegardes et la génération de commandes destinées à une reconstruction locale ou sur un serveur tiers. Je vais maintenant parler de la gestion des sauvegardes et décrire…

Read More
Oracle Team

Oracle Database 12c: ACFS – un système de fichier pour vos bases

By | Technology Survey | One Comment
 

  La version 12c d’Oracle Grid Infrastructure introduit de nombreuses nouveautés dans le support d’ACFS, le système de fichiers clusterisés d’Oracle. Nous abordons dans ce posting la capacité d’ACFS d’être le système de fichier de votre base de données ainsi que sa capacité de mise en œuvre des snapshots. Rappel sur ACFS Ce système de fichier est apparu avec la version 11.2 du cluster Oracle. Il s’appuie sur ASM ainsi qu’ADVM pour ASM Dynamic Volume Manager. Il…

Read More