|
|
|
![]()
| [일반] 세마포어 8 G 셋팅 하기 - shmmax is set to 8589934592 |
|
| 호석 님께서 쓴 글입니다 - 220.♡.198.178 |
읽음:3378 |
|
|
Applies to:
Oracle Server - Enterprise Edition - Version: 10.1.0.2.0 to 10.2.0.3.0
Linux x86-64
Linux x86
Red Hat Advanced Server
Symptoms
When shmmax is set to 8589934592 (which is half the size of RAM ), Database startup fails with error ORA-27102. This is no matter what the init.ora settings are (whether sga_max_size, sga_target etc.. are set or not)
If shmmax is set to any other value (even 8000000000, or 4294967295, or 12000000000, or
16000000000, ...) the database starts OK.
SQL> startup nomount
ORA-27102: out of memory
Linux Error: 22: Invalid argument
Changes
SHMMAX set to 8589934592 (8GB) with 16GB RAM
Cause
Incorrect value set for kernal parameter SHMALL
Solution
SHMALL= 2097152 is default value.
shmall is a system wide limit, in pages, for the total amount of virtual memory that can be allocated to shared memory segments.
Set shmall equal to shmmax divided by the page size.
The page size can be seen using the following command:
$ getconf PAGE_SIZE
Keywords
|
|
|
|
|
|
