Odi's astoundingly incomplete notes
New entries | CodeOracle 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
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.
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.
--
mtve