Infrastructure at your Service

All Posts By

David Hueber

David Hueber

ODA 12.1.X.X.X – add a multiplexed control file under ACFS

By | Database management | 5 Comments

Since version 12, ODA stores databases on ACFS volumes instead of ASM directly. This slightly changed the way the files are managed and administer. This articles presents how to multiplex your control files on ACFS. At first database creation, ODA set up 3 ACFS volumes to store all non-CDB databases (CDB are managed on dedicated volumes): /dev/asm/datastore-386 62G 5.2G 57G 9% /u01/app/oracle/oradata/datastore /dev/asm/datastore-286 1.7T 871G 836G 52% /u02/app/oracle/oradata/datastore /dev/asm/datastore-360 2.2T 5.6G 2.2T 1% /u01/app/oracle/fast_recovery_area/datastore These…

Read More
David Hueber

Oracle 12c Backup & Recovery: What’s new?

By | Database management | One Comment

After months of waiting, Oracle Database 12c is finally available. In this posting, I am going to provide a summary of the new features of Oracle 12c in terms Backup and Recovery. Pluggable, what else? For sure, the most remarkable change in this brand new version is the Pluggable Database or so called Multitenant Database concept, which is a huge change in the whole RDBMS architecture. So what does it offers in terms of Backup…

Read More
David Hueber

Oracle 12c: Pluggable databases not that isolated

By | Database management | 13 Comments

As you probably know, the multitenant databases is the new feature of Oracle 12c to solve the dilema of applications segregation. Thanks to a multitenant container database, it allows to manage many databases as one taking advantage of resources consolidation. A perfect way to manage several applications in a single container. However are these plugglable databases that isolated as expected? Not exactly: As I will show in this posting, a single PDB can, under certain…

Read More
David Hueber

Linux: Disks diagnostic using smartctl

By | Operation systems | No Comments

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, it can easily be adressed in Linux command line through smartctl What is S.M.A.R.T. exactly? S.M.A.R.T., which stands for Self-Monitoring, Analysis and Reporting Technology (also called SMART), is a monitoring system for and integrated in…

Read More
David Hueber

hpacucli: Storage management on HP servers through command line

By | Hardware & Storage | No Comments

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 HP server.

However did you know that these features are also available in command line? This is what hpacucli does…

Read More
David Hueber

Using IOzone for Linux disk performance analysis

By | Operation systems | 7 Comments

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 may take a look on the I/O performances.
This blog aims to provide to introduction to a pretty interesting tool, iozone…

Read More
David Hueber

Linux: easing the process and performance monitoring with htop

By | Operation systems | No Comments

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 analysis and looking for files and processes relations may be quite painful.

To get started with performance checks and analysis, a interesting utility is available: htop

Read More
David Hueber

OpenWorld 2011 is over … Having a last glance on ASM & disk failures

By | Technology Survey | No Comments

So we are now arrived at the end of the largest Oracle OpenWorld ever. Around 45’000 people had joined San Francisco to exchange around IT and especially Oracle technologies.
It has been a great conference with much of interesting sessions and as each year several announcements: Enterprise Manager 12c, Exalytics and Oracle Public Cloud.

For my last post about OOW11, I want to talk about the last session I attended. Who said that the late sessions are usually having less interest? I personally was lucky enough to attend a great presentation held by Oak Table member, Alex Gorbachev. Alex used ASM to demonstrate how hardware and software fault tolerance mechanisms, especially mirroring, are affected by different parameters such MTBF.

Read More
David Hueber

OOW Day 3: Oracle Database Appliance and Cloud Computing with OEM

By | Technology Survey | 2 Comments

In my second blog about OpenWorld, I gave an overview of the Engineered Solutions portfolio, which just got enhanced with Exalytics. Today I’m going to focus a bit more on the Database Appliance product and how this box works. I had the chance to go a session called “New! Database Appliance: Secrets revealed”, which provided more information on its architecture and functionalities.

After that I want to highly a interesting use case made by DELL and pointing out the usage of the brand new Oracle Enterprise Manager 12c for Cloud computing.

But before that let’s have a look on the Database Appliance secrets…

Read More