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

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.

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

kernel.shmall = kernel.shmmax / kernel.shmmni

dbtut
Author: dbtut

We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.

Leave a Reply

Your email address will not be published. Required fields are marked *