Linux/UNIX

Oracle Automatic Memory Management: real memory usage!

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

Unable to resize tmpfs on Oracle Enterprise Linux 6 versions

I recently helped to create a lab dedicated to a training about Oracle backup and recovery, with Oracle 11g databases. While creating several databases on an Oracle Enterprise Linux 6.1, I wanted to resize the tmpfs to allocate more memory(…)

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

hpacucli: Storage management on HP servers through command line

For sure you already used, or at least heard about, the HP Smartstart Kit. This especially includes the storage management part ACU: Array Configuration Utility. This tool is pretty straightforward to configure the storage and RAID volumes before installing an(…)

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

Using IOzone for Linux disk performance analysis

Who never had to measure the disk performances on a system? Speaking about Linux performance monitoring includes a significant part on disk performances. If you are facing applications or databases running slower than expected or than on other environments, you(…)

Why Perl is my choice for scripting

I have been advising to use Perl for a long time in order to automate Oracle processes and operations. This week however, I tried for once to write a small procedure on a simple Linux shell (ksh and bash). This(…)

Linux: easing the process and performance monitoring with htop

I'm pretty sure that most of you already struggled with some low performance systems. In order to analyse such cases several tools and utilities, like top, nmon, fuse or lsof are available under Linux. However trying to dig in processes(…)

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