Infrastructure at your Service

Oracle Team

Bug on Oracle 11.2 “ORION FAILS WITH ORA-27061″: Patch available!

By | Application integration & Middleware | No Comments

In march 2011, my colleague Gregory Steulet published an article about Simulating and testing I/O performances with Orion. In this article, he wrote about a bug concerning Orion on Oracle 11.2, reported in Oracle bug number 9104898: “ORION FAILS WITH ORA-27061: WAITING FOR ASYNC I/OS FAILED”. Trying to compare performances of storage devices on a virtual machine between a classical and a paravirtual storage adapter, I experienced the same error when using large IOs. I…

Read More
Yann Neuhaus

Configuration des options en Oracle 11g EE avec ‘chopt’

By | Database management | One Comment

La configuration des options sous Entreprise Edition avant Oracle 11g pouvait être un véritable parcours du combattant. Donc, une attention particulière devait avoir lieu avant l’installation des binaires Oracle; à savoir quelles options devaient être installées! Depuis la version 11g, les choses ont bien changé, grâce à l’utilitaire “chopt” se trouvant sous $ORACLE_HOME/bin. Voici la syntaxe d’utilisation de “chopt”: chopt [enable |disable] db_option db_option: dm = Oracle Data Mining dv = Oracle Database Vault lbac…

Read More
Yann Neuhaus

Oracle Automatic Memory Management: real memory usage!

By | Database management | One Comment

When using Automatic Memory Management for Oracle, it is sometimes difficult to monitor the memory usage and in particular to find the right tools to get the right information about currently allocated structures. The instance which will be analyzed has been configured with AMM (Automatic Memory Management) on Oracle Enterprise Linux 6.1. The current memory_target is set to 1 GB: SQL> show parameter memory_target NAME                                 TYPE        VALUE ———————————— ———– ———— memory_target                        big integer 1G  …

Read More
Stéphane Haby

SQL Server 2012: First Hotfix for Service Pack 1 available

By | Database Administration & Monitoring | No Comments

This month, Microsoft has released the first hotfix for SQL Server Service Pack 1. Analysis This Hotfix concerns the installation of SQL Server components and Analysis Services. If you have installed the RTM version with Analysis Service and successfully installed Service Pack 1, you may experience problems in the next installation process for other component: The installation freezes and does not finish. Problem Windows Installer tries to repair the installation and then blocks the next…

Read More
Oracle Team

Resource FAILOVER dans Grid Infrastructure

By | Hardware & Storage | No Comments

Dans le cadre d’un cluster Oracle Grid Infrastructure 11g R2 utilisé pour gérer des bases de données en mode FAILOVER, j’ai été amené à me pencher sur l’algorithme de basculement d’une ressource et des paramètres le régissant. On trouve dans la documentation Oracle des informations sur les cinq paramètres intervenant dans la prise de décision, à savoir: CHECK_INTERVAL: L’Intervalle de temps entre deux exécutions d’une action de vérification. RESTART_ATTEMPTS: Le nombre de tentatives de redémarrage…

Read More
Oracle Team

Scripts to duplicate an Oracle database virtual machine: step one

By | Hardware & Storage | One Comment

In my last posting of November 9, 2012, Manage templates manually with Oracle Virtual Box, I have presented a solution to duplicate virtual machines using Oracle/ Virtual Box. I did not show the scripts in this first publication, but I promised to tell you more about it… Let me present the case. In September 2012, I was asked to create a training environment consisting of five identical virtual machines, with the following constraints: Virtual machines…

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