In the background, I managed to secure a test box for a couple hours that I could play with. While researching how to turn numa=off, I ran across this on Redhat's site:
The Red Hat Enterprise Linux 4 Update 1 kernel automatically disables NUMA optimizations (numa=off) by default on systems using the AMD64 dual core processor. This ensures stable operation across multiple systems where each has a different system BIOS implementation for reporting dual core processors.
Hmm, that's fishy. Why would they ask me to turn it off if the default value is off? So I did it anyway.
Same thing, good old ORA-27102: out of memory.
As long as I had the box booted with numa=off, I might as well try _enable_numa_optimization=false, right? No dice, same error.
Last, but not least, I tried their suggestion of setting vm.nr_hugepages=0 in the sysctl.conf. But I found out that's already my value:
sysctl -a | grep vm.nr_huge
vm.nr_hugepages = 0
OK, so now what?
Maybe 11g is an option...
Click the 10.2.0.4 label below to follow all threads on this issue and the eventual solution.