Grégory Steulet

ORA-03113 caused by Database Vault Rule Sets

Database Vault solution allows to create rules that manage access to database. Among these rules there is what is called in Database Vault “Rule Sets”. These logic components are written as PL/SQL(…)

Red Hat 6.1: unable to read group information from repositories

During one of my recent missions I had the opportunity to install Red Hat 6.1 on a ESX Virtual Machine. During the installation process I got a strange message: "unable to read group information from repositories". If you also encounter(…)

“MySQL server has gone away” ?!

Few days ago, I was at a customer that encountered some problems trying to restore his MySQL database. Indeed he got the following error message trying to restore his xwiki database: mysql@dba-ecm-srv11:/ [mysqld1] mq < /MyBackupFile.sqlERROR 2006 (HY000)(…)

Oracle Application Express (APEX) 4.1: a migration guide

  Oracle Application Express - APEX 4.1 Introduces many new features such as : Improved error handling and user-defined exception processing Application Express now supports the use of ROWID for updates, inserts(…)

MySQL Data High Availability with semi-synchronous replication

Starting with MySQL 5.5 it is possible to configure semi-synchronous replication. As you probably know, by default, MySQL replication is asynchronous.  Asynchronous replication means that events/transactions applied on one server are not immediately applied on the other one. In the(…)

Stop looking for Oracle Fusion and Oracle Grid Control documentation: use the dbi services firefox add-ons!

After my last post title "Stop looking for Oracle and MySQL documentation: use the dbi services firefox add-ons!" Some of you asked me for firefox search add-ons for Oracle Fusion(…)

Saving time and increasing service availability with MySQL Enterprise Monitor 2.3

Nowadays MySQL Databases are encapsulated into many mission critical software solutions. Lots of companies host one or many MySQL databases in their data center, sometimes even without knowing it except when the MySQL service is no more available. In order(…)

Stop looking for Oracle and MySQL documentation: use the dbi services firefox add-ons!

Are you often trying to find some functionalities into ORACLE 10gR2, ORACLE 11gR2 or MySQL documentation ? Of course each time you are looking for this documentation you find unofficial documentation which is never corresponding to the version you are(…)

Simulating and testing I/O performances with ORION

Since Oracle 11.2, Oracle provides ORION in the RDBMS binaries (in ${ORACLE_HOME}/bin). ORION is an I/O calibration tool allowing to simulating and testing I/O performances an Oracle database would be confronted with.   ORION basically supports four kinds of database(…)

MySQL Workbench 5.2: changing the life of MySQL developers and DBAs

MySQL Workbench provides several necessary tools in order to manage a MySQL environment. MySQL Workbench 5.2 is available for Windows, Mac and Linux platforms, it encapsulates three main functionalities: 1.    SQL Development: Allows connecting to existing databases and run SQL(…)