SQL> startup
ORA-27102: out of memory
Linux-x86_64 Error: 28: No space left on device
1.查看共享内存:
可以看到ORACLE共享内存并没有释放,且KEY为0;出现这种情况往往是由于ORACLE进程未中断,或权限问题)
oracle@TLCJS1:[/oracle] ipcs -m
------ Shared Memory Segments --------
key shmid owner perms bytes nattch status
0x00000000 131075 oracle 660 21476933632 1 dest
2.清楚共享内存:
ipcrm -m 131075 ----虽然可以执行,但不能清除
3.查看正在连接的ORACLE进程
oracle@TLCJS1:[/oracle] ps -aux|grep oracle|more
Warning: bad syntax, perhaps a bogus '-'? See /usr/share/doc/procps-3.2.8/FAQ
oracle 10130 0.0 0.0 217904 12984 ? Ssl Feb09 16:19 /oracle/app/oracle/product/11.2.0/dbhome_1/bin/tnslsnr LISTENER -inherit --oracle进程未释放
root 28582 0.0 0.0 54592 1532 ? Ss 10:49 0:00 login -- oracle
oracle 28586 0.0 0.0 107076 1696 pts/1 Ss 10:49 0:00 -ksh
oracle 29605 0.0 0.0 69900 12672 pts/1 S+ 10:56 0:00 sqlplus
oracle 29607 0.0 0.0 21205772 14076 ? Ss 10:56 0:00 oracleolcjs1 (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq))) -------oracle进程未释放
root 31461 0.0 0.0 161356 1860 pts/3 S 11:26 0:00 su - oracle
oracle 31462 0.0 0.0 107076 1732 pts/3 S+ 11:26 0:00 -ksh
root 32248 0.0 0.0 161356 1864 pts/4 S 11:37 0:00 su - oracle
oracle 32249 0.0 0.0 107076 1696 pts/4 S 11:37 0:00 -ksh
oracle 32353 9.0 0.0 108048 1084 pts/4 R+ 11:39 0:00 ps -aux
oracle 32354 0.0 0.0 103232 840 pts/4 S+ 11:39 0:00 grep oracle
oracle 32355 0.0 0.0 103084 668 pts/4 S+ 11:39 0:00 more
杀掉持有的ORACLE进程:
kill -9 10130
kill -9 29607
来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/29446986/viewspace-1676668/
,如需转载,请注明出处,否则将追究法律责任。