昨天数据库被人搞垮了
. ]7 p$ p' {6 M' m( U7 L用sqlplus 连上去 总显示 idle instance
& m4 S' _/ h/ g3 h( V% S/ ?2 x没办法只能 shutdown abort
' X I1 `/ p8 G2 W0 s* G然后再 startup
' D4 C8 h+ y1 V8 N% o在startup时提示报错 说的是内存不足
# L& h4 u. |! ^1 P1 x8 C4 d2 v, oipcs -a 一看果然 共享内存还在
7 H5 b( ^3 D5 j, m* e1 V, V网上搜了一下$ F/ | F# A$ Y# w
[root@uf201003033 ~]# ipcs -sa0 w# K+ X' M4 Y3 H5 f, y: Z1 L
------ Shared Memory Segments --------6 }' K' W. k% T- w l/ l- t
key shmid owner perms bytes nattch status
# a& B4 T. T4 J' r0x5e1ae010 753664 oracle 640 9112125440 302
* W: H; z/ c/ Z2 l0 d6 M------ Semaphore Arrays --------
p0 {) G" }/ ^8 [1 C4 ]2 E8 bkey semid owner perms nsems" O* t7 c* M! P1 |8 Y: u
------ Message Queues --------8 `4 W/ O' r( U2 G
key msqid owner perms used-bytes messages0 K8 F. X8 J/ b# }
用命令 ipcrm -s 753664
& @+ z7 Q+ `8 y再来看下" T0 l/ o" k- g9 G
[root@uf201003033 ~]# ipcs -sa
- F+ A& w8 H+ h2 {' s- a6 d------ Shared Memory Segments --------
, a' X# F9 S5 pkey shmid owner perms bytes nattch status/ F+ M8 f! _, ^; o
------ Semaphore Arrays --------
* s$ j" ]. j& I0 a* wkey semid owner perms nsems" i! c8 s8 _- D% z
------ Message Queues --------
4 e1 Z6 J ?1 U' F8 x( j# fkey msqid owner perms used-bytes messages
7 C+ c8 u8 P. i已经干净了
+ e R' J6 |+ Z- ~7 E% @* M再 startup OK 搞定 |