Odi's astoundingly incomplete notes

New entries | Code

Oracle sqlplus hangs after killing processes

Something to remember when killing an Oracle instance manually (which should not be done really): clean up the shared memory allocations. Use the command ipcs to list the used shared memory segments, and ipcrm to remove them. Alternatively reboot the system.

If you fail to do that, sqlplus would not startup anymore and just consume a lot of CPU, instead of telling you that it can not allocate shared memory.

posted on 2008-10-17 10:28 UTC in Code | 1 comments | permalink
thanks, saved me a few hairs! f*cking cr*pware.