Dears,
Last week I was trying to setup hugepage on RHEL 9 with Oracle RDBMS 19.22.
I have been configuring hugepage for a long time, so I know how this happens.
I have configured hugepage in Rhel6 onwanrds until RHEL8.
No challenges ever.
Recently I was trying to repeat the same procedure...
1. sysctl.conf
vm.nr_hugepage=<cnt>
2. limits.conf
memlock=unlimited (soft & hard)
3. oracle
use_large_pages=ONLY
on top disable THP in grub.conf
All these were done.
After all these settings, the machine was rebooted to get the hugepages allocated.
I verifed the hugepage count, all looked OK.
When I tried starting the db I faced an error saying "SGA: Realm Creation Failed"
ORA-27125. turned out to be a generic oracle error.
So I spent sometime googling, I learnt this is probably due to something new in RHEL 9, may be I am not aware of.
So I reached out to Twitter to oracle Ace group.
I got response from Tanel Poder stating that the issue could be this missing setting (never heard of actually from my end).
vm.hugetlb_shm_group=<oracle owner's primary gid>
reference:
https://oracle-base.com/articles/linux/configuring-huge-pages-for-oracle-on-linux-64
It turned out to be the fix, after implementing that param in sysctl.conf and then running "sysctl -p", the param reflected fine and db started OK. A screenshot for reference...
