ORA-27104: system-defined limits for shared memory was misconfigured

dbtut

5 years ago

In the Oracle 12c version, during database creation with dbca, this error is received because the shmall kernel parameter is not set correctly. The problem will be corrected after the correction of the relevant parameters.

The possible error will be as follows.

The values of the parameters for a server that has 64 gb of memory should be set as follows.

[root@oracledb ~]# cat /etc/sysctl.conf | grep kernel | grep shm | grep -v "#"
kernel.shmall = 16039424
kernel.shmmax = 65697480704
kernel.shmmni = 4096

[root@oracledb ~]# cat /etc/sysctl.conf | grep kernel | grep shm | grep -v "#"

kernel.shmall = 16039424

kernel.shmmax = 65697480704

kernel.shmmni = 4096

You can calculate what the kernel.shmall value should be with a formula as follows.

kernel.shmall = kernel.shmmax / kernel.shmmni