Error
SQL> startup;
ORA-27102: out of memory
Linux-x86_64 Error: 28: No space left on device
Solution
$ vi /etc/sysctl.conf
edit kernel.shmall, kernel.shmmax, kernel.shmmni parameter
e.g.
$ getconf PAGE_SIZE
$ cat /proc/sys/kernel/shmall
(4096) * (524288) = 2147483648 (2 GB)
kernel.shmall = 2147483648
kernel.shmmax = 21474836480
kernel.shmmni = 4096
# sysctl -p
apply the settings
Alternative link: http://ozsoyler.blogspot.com/2014/10/how-to-set-shmmax-value-and-what-is-that.html
SQL> startup;
ORA-27102: out of memory
Linux-x86_64 Error: 28: No space left on device
Solution
$ vi /etc/sysctl.conf
edit kernel.shmall, kernel.shmmax, kernel.shmmni parameter
e.g.
$ getconf PAGE_SIZE
$ cat /proc/sys/kernel/shmall
(4096) * (524288) = 2147483648 (2 GB)
kernel.shmall = 2147483648
kernel.shmmax = 21474836480
kernel.shmmni = 4096
# sysctl -p
apply the settings
Alternative link: http://ozsoyler.blogspot.com/2014/10/how-to-set-shmmax-value-and-what-is-that.html
