ORA-27154: post/wait create failed
ORA-27300: OS system dependent operation:semget failed with status: 28
ORA-27301: OS failure message: No space left on device
ORA-27302: failure occurred at: sskgpcreates
— dla wersji Ora 12.2.0.1
— komunikat jest troche z czapki ale, zwiększamy parametry semaphore-a
— sprawdzamy jakie wartości są w pamięci
[oracle@dbnod1 ~]$ cat /proc/sys/kernel/sem
250 32000 100 128
[oracle@dbnod1 ~]$ ipcs -ls
—— Semaphore Limits ——–
max number of arrays = 128
max semaphores per array = 250
max semaphores system wide = 32000
max ops per semop call = 100
semaphore max value = 32767
sysctl -w kernel.sem=”250 50000 100 200″
— wrzucamy do pliku
cat /etc/sysctl.conf | grep kernel.sem
— po zmianach:
[root@dbnod1 ~]# ipcs -ls
—— Semaphore Limits ——–
max number of arrays = 200
max semaphores per array = 250
max semaphores system wide = 50000
max ops per semop call = 100
semaphore max value = 32767