ORA-27125 in RHEL 9 with Oracle RDBMS 19.22

 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...

Thanks