Not able to create new DB , Errors ORA-27154,ORA-27300,ORA-27301,ORA-27302 (Doc ID 1916074.1)

Last updated on DECEMBER 06, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.3 and later
Information in this document applies to any platform.
***Checked for relevance on 08-Jul-2016***

Goal

While creating a new DB , the  following error raised:

 

ORA-27154,ORA-27300,ORA-27301,ORA-27302.

 

 - - Kernel Values  show  the following :

 

kernel.sem = 250 32000 100 128 ----------->>>>  This indicates that 250 semaphores can be accomodated in an array and maximum of 128 arrays can be in the system.

So, in total, 32000 (250X128) semaphores can present in the system.


kernel.shmall = 4294967296
kernel.shmmax = 68719476736
kernel.shmmni = 4096
fs.file-max = 6815744
net.ipv4.ip_local_port_range = 1024 65500
net.core.rmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_default = 262144


 -- [oracle@localhost dbhome_1]$ ipcs

...
...
----- Semaphore Arrays --------
key semid owner perms nsems
0x21b9674c 196610 oracle 660 127
0x21b9674d 229379 oracle 660 127
0x21b9674e 262148 oracle 660 127
...
...

If  we assume this is the case here.

So, here, the actual semaphore accommodated per array is not 250, it is 127.
So, practically, only 16256 (128*127) can present in the server.

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms