Troubleshooting

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

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

Linux: Disks diagnostic using smartctl

Facing disk issues such as corruption or block defect is thankfully not happening frequently. However when it does, the diagnose may look sometimes like a real struggle. This is forgetting that disks integrate since years the S.M.A.R.T technology. Good point,(…)

Oracle Enterprise Manager 12c – Database Target remains in Pending state (SLES x86_64 target)

Last month I was confronted to a very interesting and strange problem while deploying a Cloud Control 12c infrastructure. One of my monitored server was a SuSE Linux Enterprise Server (SLES) 64 bits on which a 11.2.0.3 Oracle database was(…)

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 SQL Developer & SQL Data Modeler on Ubuntu

Oracle SQL Developer and Data Modeler are becoming more and more popular as they are both cost-free and available on many Operating Systems (Linux/Unix,Windows and Mac) with different installation types: "This zip does(…)

Oracle RunInstaller crashes while installing Cloud Control 12c on OEL 5.7

A few days ago I downloaded the Cloud Control 12c binaries for Linux x86_64 from the Oracle Technet. My friend, Hervé Schweitzer, configured an OEL 5.7 VM for test purpose and I was quite eager to install this new software.

Compression advisor: excessive redo log file generation

Last week by a customer, we experienced an excessive redo log generation filling up rapidly the FRA (Flash/Fast Recovery Area) with archivelog files which caused the database to crash.

Oracle Cluster 11g R2 listener down – que faire ?

Dans un environnement cluster le listener ne peut pas démarrer avec une erreur sur la définition de nom "locahost" défini dans le fichier /etc/hosts.