Customer switched from STP to MTP and began to get the following error in there event_log...
[1] 10/26/04 09:30 Notice: shs_alloc_stat (1): Failed with error shs_ALLALLOCED: no more memory to allocate [sp_opst_mt(shs)/23476]
[1] 10/26/04 09:30 Notice: sql_thread - shared memory:shs_ALLALLOCED: no more memory to allocate [sp_opst_mt/23476]
[1] 10/26/04 09:30 Notice: shs_alloc_stat (1): Failed with error shs_ALLALLOCED: no more memory to allocate [sp_opst_mt(shs)/23476]
[1] 10/26/04 09:30 Notice: sql_thread - shared memory:shs_ALLALLOCED: no more memory to allocate [sp_opst_mt/23476]
[1] 10/26/04 09:30 Notice: shs_alloc_stat (1): Failed with error shs_ALLALLOCED: no more memory to allocate [sp_opst_mt(shs)/23476]
[1] 10/26/04 09:30 Notice: sql_thread - shared memory:shs_ALLALLOCED: no more memory to allocate [sp_opst_mt/23476]
This error can be caused by either of two things:
A) if the value of Max Shared Memory allowed for the box is already used this can be checked by issueing an ipcs -a and sysdef -i | grep -I shm - Customer would need to either increase the SHMMAX for the box or reduce the amount of shared memory used by applications running on the box.
IPC status from <running system> as of Tue Oct 19 15:30:59 EEST 2004
T ID KEY MODE OWNER GROUP CREATOR CGROUP CBYTES QNUM QBYTES LSPID LRPID STIME RTIME CTIME
Message Queues:
T ID KEY MODE OWNER GROUP CREATOR CGROUP NATTCH SEGSZ CPID LPID ATIME DTIME CTIME
Shared Memory:
m 0 0x5000076f --rw-r--r-- root root root root 1 4 830 830 21:46:13 21:46:13 21:46:13m 1 0x61a8 --rw-rw-rw- root root root root 0 8200 909 2653 21:52:18 21:52:18 21:46:35m 514 0x8e291eec --rw-r----- ora817 dba ora817 dba 3004 1430257664 1333 25775 15:30:59 15:30:59 21:47:52m 515 0xcf22b474 --rw-r----- ora817 dba ora817 dba 2899 3510632448 1454 25767 15:30:59 15:30:59 21:48:23m 2052 0xb0d2c --rw-r--r-- ora817 dba root dba 4 8388608 26625 25759 15:29:29 15:30:58 12:32:57m 2053 0x1b0d2c --rw-r--r-- ora817 dba root dba 4 98304 26625 25759 15:29:29 15:30:58 12:32:57m 2054 0x3b0d2c --rw-r--r-- ora817 dba root dba 3 268435456 26625 25759 15:30:21 15:30:58 12:32:57m 2055 0x4b0d2c --rw-r--r-- ora817 dba root dba 3 268435456 26625 25754 15:30:21 15:30:58 12:33:00T ID KEY MODE OWNER GROUP CREATOR CGROUP NSEMS OTIME CTIME
Semaphores:
*
* IPC Shared Memory
*
4294967295 max shared memory segment size (SHMMAX)
1 min shared memory segment size (SHMMIN)
512 shared memory identifiers (SHMMNI)
200 max attached shm segments per process (SHMSEG)
B) If the above is okay, i.e. there are still some free shared memory available on the box then we need to look into increasing the parameter SP_SHS_SHMSIZE, the default value for SP_SHS_SHMSIZE 4194304 and after setting it, it requires a restart of sp_cop.
So try values greater than 4194304, on a site we had to increase the size to 67108864.
