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.
Oracle will not provide ASMLib packages for kernels distributed by Red Hat as part of RHEL 6.
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.
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... :-)
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.
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).
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.
As the documentation about restoring an OCR did not work as it should be, hereby a method to do this.
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 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.
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