Oracle on RHEL 6 , using ASM with or without ASMLIB
Oracle will not provide ASMLib packages for kernels distributed by Red Hat as part of RHEL 6.
Multipath timeout issues with extended 11.2.0.2 – cluster setup. Part II
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.
Processes and startup-sequences in 11.2
Remember the old days. You had just a few processes to watch. Something has changed along the way. A lot of processes should be running on your database system (with infrastructure), but how are they connected to eachother and what is the startup sequence ? Or.. what processes I can kill without any other proces starting it up... :-)
Param ‘_datafile_write_errors_crash_instance’ , TRUE or FALSE?
Since 11.2.0.2 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 11.2.0.2 – cluster setup part I
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).
Metric ‘swap utilisation(%)’ on Grid Control node too high.
The metric 'swap utilisation (%)' on the node where Grid Control resides, shows permanently a very hig value. Red Hat Linux, 64-bits, 32GB RAM, 4GB swap. Adding 4GB to the swap-file solved the problem.
Restoring OCR on 11.2.0.2-cluster
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
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, 11.2.0.2 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
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, 11.2.0.2 for infra, and database. * 1 VM as my own SAN, based on Openfiler 2.3, for ASM.
Unable to load module oracleasm with the ‘init’ command
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
