Utilizing your IT environment with Oracle Database Appliance

By | July 21st, 2016|Categories: ODA|Tags: , , , , , , |

I admit, I’m a bit of a fan of the Oracle Database Appliance. And I also admit there are some characteristics of the X5-2 ODA’s which made it sometimes a bit hard to fit in the needs of the customer. I’ll come to that later in this post. With the introduction of the two entry-level ODA’s I wrote about in a former blogpost , the ODA X6-2S and the ODA X6-2M, Oracle has made an effort to reach out to the smaller business to fill in their needs. But will it be a succes? This blogpost is about the kind of customer-challenges the ODA (at least one of the series) could be a solution for.


Configuring a private DNS server on Openfiler for use with Oracle RAC 12C on Virtual Boxes

By | June 7th, 2014|Categories: Database, RAC|Tags: , , |


This post has already been published in the past on the AMIS-blog.

To build an Oracle 12C RAC database – on Virtual Boxes – there’s at least shared storage needed for ASM, and a DNS-server for the SCAN-addresses. Several methods can be used for this, but  for the storage in my private project I chose Openfiler, an open source management storage tool, on a separate Virtual Box. It’s like a SAN in real life (the complete system will be three Virtual Boxes: two RAC-nodes and 1 storage Virtual Box). Version Openfiler: 2.99.

O.k. storage is clear, but what about DNS? The quickest and dirtiest way to accomplish this is to use Dnsmasq on every RAC-node. A nice blogpost about this subject is here to be found.

But what I want is a separate DNS-server, just as in real life. The perfect candidate is to use the separate Openfiler Virtual Box


Multipath timeout issues with extended – cluster setup. Part II

By | January 3rd, 2012|Categories: Database, RAC|Tags: , , , |

The second and final post about an issue with a RAC-configuration with two SAN's. Problem was a i/o-freeze of minutes when crashing one of the two SAN's. The first post I ended with a 'cliffhanger' because we had a solution, but not tested it yet.

Param ‘_datafile_write_errors_crash_instance’ , TRUE or FALSE?

By | August 26th, 2011|Categories: Database, RAC|Tags: , , |

Since there's a new parameter, "_datafile_write_errors_crash_instance" to prevent the intance to crash when a write error on a datafile occurs. But.. should I use this or not.

Multipath timeout issues with extended – cluster setup

By | August 25th, 2011|Categories: Database, RAC|Tags: , , , |

With this setup we are facing the issue that if we loose a complete SAN, the IO’s to the ASM diskgroups will be blocked for approx 3 till 4 minutes. Oracle does not like this. After 70 seconds after a freeze, rdbms is starting to reboot (expected behaviour).

Restoring OCR on

By | May 15th, 2011|Categories: Database, RAC|Tags: , , |

As the documentation about restoring an OCR did not work as it should be, hereby a method to do this.

My RAC project with Openfiler, part II – grid infrastructure and database

By | January 24th, 2011|Categories: Database, RAC|Tags: , , |

This is the second post of my little project of building my own RAC on my Windows7-desktop (64-bits, 8GB RAM), using 3 VM’s (VM-workstation , 7.1.3 build-324285) : * 2 VM’s for two RAC-nodes, based on OEL 5.5, for infra, and database. * 1 VM as my own SAN, based on Openfiler 2.3 (free), for ASM.

My RAC project with Openfiler, part I – Openfiler

By | January 17th, 2011|Categories: Database, RAC|Tags: , , , |

My current job doesn’t offer me at the moment the opportunity to play with RAC or other stuff, so I decided to build my own RAC on my Windows7-desktop (64-bits, 8GB RAM), using 3 VM’s (VM-workstation , 7.1.3 build-324285) : * 2 VM’s for two RAC-nodes, based on OEL 5.5, for infra, and database. * 1 VM as my own SAN, based on Openfiler 2.3, for ASM.

Prerequisite-check fails on installing infrastructure: ORCL:VOL1 is not a valid path

By | January 12th, 2011|Categories: Database, RAC|Tags: , |

While installing a grid - infrastructure on my own RAC-cluster (VMware), using ASM with Openfiler as by own SAN, the prerequisite-check fails at step 15 with : PRVF-5150 : Path ORCL:VOL1 is not a valid path on all nodes

Unable to load module oracleasm with the ‘init’ command

By | January 6th, 2011|Categories: Database, RAC|Tags: , , , |

While building my own RAC on two VM's, using a third VM with Openfiler on it as my SAN, I had to dowload, install, configure and load ASMLIB. Loading didn't seem to go smoothly at my own project. First I analyzed what I did, steps I took