Out of ID
Recently a customer observed on one of their systems, that the number n of databases started quite nicely on a system. However when they tried to start database n+1 on it, it just yielded the following error message.
Your first reflex ist to check the amount of free shared memory, but the system had ample of it free. My first reflex after seeing an unlimited ZFS ARC was that we simply run out of memory and that the customer should limit that at first. However then i remembered there is a second resource that creates this errormessage as well. It’s the number of shared memory IDs. You have to check them as well. Per default they are limited to 128.
I suggested to increase this number significantly.
Let’s check the situation again.
After this, the database n+1 started without any problem.