Tags

, ,

Mostly, you could observe the case of hang issues of sqlplus after shutting down the database. Although there might be many other reasons the shared memory case may be the one.

root@server:/…/>ipcs -a
IPC status from /dev/mem as of Tue Mar 25 09:40:02 MEST 2014
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 2097152 00000000 –rw-r—– oracle dba oracle dba 95 16777216 20316244 18808848 9:40:02 9:40:02 17:10:33
m 2097153 00000000 –rw-r—– oracle dba oracle dba 95 2130706432 20316244 18808848 9:40:02 9:40:02 17:10:33
m 2097154 0xce827e24 –rw-r—– oracle dba oracle dba 95 8192 20316244 18808848 9:40:02 9:40:02 17:10:33
m 23068872 0xffffffff D-rw——- root system root system 1 536870912 19398666 19398666 14:47:43 no-entry 14:47:43
T ID KEY MODE OWNER GROUP CREATOR CGROUP NSEMS OTIME CTIME
Semaphores:
s 3145728 0x0104e5c6 –ra-ra-r– root system root system 1 13:38:05 13:38:05
s 1 0x6203a30c –ra-r–r– root system root system 1 13:37:58 13:37:58
s 2 0x0103a575 –ra——- root system root system 1 13:41:38 13:41:38
s 2097160 0xa1001002 –ra-ra-ra- root system root system 2 9:21:43 14:32:24

Removing the procs..
ipcrm -m 2097152
ipcrm -m 2097153
ipcrm -m 2097154

ipcrm -s …

Advertisements