alert log에 나타난 Warning메시지
Starting ORACLE instance (normal)
Sun Aug 17 02:07:49 2008
WARNING: EINVAL creating segment of size 0x0000000033720000
fix shm parameters in /etc/system or equivalent
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
LICENSE_MAX_USERS = 0
Starting up ORACLE RDBMS Version: 8.1.7.4.0.
System parameters with non-default values:
세마포어 관련 문제인듯하다.
SQL> show sga
Total System Global Area 862421152 bytes
Fixed Size 73888 bytes
Variable Size 336994304 bytes
Database Buffers 524288000 bytes
Redo Buffers 1064960 bytes
sysdef
*
* IPC Semaphores
*
250 semaphore identifiers (SEMMNI)
2000 semaphores in system (SEMMNS)
30 undo structures in system (SEMMNU)
300 max semaphores per id (SEMMSL)
10 max operations per semop call (SEMOPM)
10 max undo entries per process (SEMUME)
32767 semaphore maximum value (SEMVMX)
16384 adjust on exit max value (SEMAEM)
*
* IPC Shared Memory
*
524288000 max shared memory segment size (SHMMAX)
1 min shared memory segment size (SHMMIN)
400 shared memory identifiers (SHMMNI)
40 max attached shm segments per process (SHMSEG)
SGA 사이즈가 약 800Mb 정도 필요한데 SHMMAX 값이 500Mb라 Warning를 뿌리고 Shared Memory를 2개를 사용하넹..
SEMMSL 값도 늘려주어야 겠다(process개수와 관련 Semaphores s)
Shared Memory:
m 0 0x5000dc0d --rw-r--r-- root root root root 1 4 292 292 15:39:24 15:39:24 15:39:24
m 12401 0 --rw-r----- ora817 dba ora817 dba 54 81920 1733 8416 11:57:40 11:58:03 2:07:49
m 3602 0 --rw-r----- ora817 dba ora817 dba 54 524288000 1733 8416 11:57:40 11:58:03 2:07:49
m 3603 0xe5185ecc --rw-r----- ora817 dba ora817 dba 54 338739200 1733 8416 11:57:40 11:58:03 2:07:49
m 3604 0 --rw-r----- ora817 dba ora817 dba 9 324091904 1847 7913 11:55:05 11:55:09 2:08:18
m 263605 0x22c09190 --rw-r----- ora817 dba ora817 dba 9 320905216 1847 7913 11:55:05 11:55:09 2:08:19
T ID KEY MODE OWNER GROUP CREATOR CGROUP NSEMS OTIME CTIME
Semaphores:
s 2555904 0x693fd138 --ra-r----- ora817 dba ora817 dba 252 11:57:57 2:07:50
s 786433 0x693fd139 --ra-r----- ora817 dba ora817 dba 252 no-entry 2:07:50
s 589826 0x693fd13a --ra-r----- ora817 dba ora817 dba 252 2:07:50 2:07:50
s 2359299 0x714ab394 --ra-r----- ora817 dba ora817 dba 154 11:55:05 2:08:19