Database management

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(…)

PostgreSQL: Un aperçu des outils d’administration

Nous avons dans les articles précédents vu comment installer PostgreSQL et quels étaient les composants d'une base. Nous abordons maintenant le point de l'actionsur le moteur avec deux outils orientés administration de la base, généralement utilisés par les DBAs.

Oracle Enterprise Manager 12c: Administration Groups & Template Collections

This document describes the implementation of theadministration groups and template collections with Oracle EnterpriseManager Cloud Control 12c.   Administration Groups (improvement of Grid 11g Target(…)

“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)(…)

Protecting an Oracle database from block corruption

Data can be corrupted in different ways, for example an I/O issue when reading data from the storage or a memory issue when updating data. The db_block_checking parameter allows to change the behavior of an Oracle database concerning block checking.

PostgreSQL: L’installation

Dans mon précédent article concernant PostgreSQL, j'ai annoncé une serie d'article sur ce SGBDR, aprés une courte introduction et avant de plonger dans le fonctionnement interne, l'architecture etc... je vous propose d'aborder l'installation du produit.

SQL Server 2012: New Licensing

As we approach the release of version of SQL Server 2012, I think a little article about the Licencing is appropriate.

SQL Server 2012: How to create a Server Role?

Recently, during my many missions, a client asked me to give access rights to the SQL Server Logs from SSMS to his application managers.   As you know, you must give(…)

Configuration of tmpfs on SLES 11 for Oracle 11.2 and AMM

This post presents the configuration of the tmpfs filesystem size on SLES 11 in order to use the Oracle 11.2 Automatic Memory Management feature (AMM) through the Oracle instance parameter memory_target.

Martin Bach @ dbi services: workshop on Oracle RAC

Last week, from Wednesday to Friday we had the pleasure to welcome Martin Bach an OAK table member, also Oracle Certified Master and Oracle ACE, for an Oracle Grid Infrastructure training.