Customer got the following internal error message : ORA-600 [kdsgrp1] SQL> analyze table OPS$DWHPOPR_TEST.DWH_EURTABLE validate structure online; ERROR at line 1: ORA-01498: block check failure - see trace file.
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 126.96.36.199 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, 188.8.131.52 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, 184.108.40.206 for infra, and database. * 1 VM as my own SAN, based on Openfiler 2.3, for ASM.