We're using Oracle Enterprise 11rR2 running on Solaris.

How can I delete/remove allocated shared memory segments using ipcrm?

I'm getting this error:

 ORA-01041: internal error. hostdef extension doesn't exist

I hope that you know what you are doing....

First find which segment would be a candidate to drop because it was not cleaned up by an Oracle crash:

ipcs -bom

Take note of the owner and group, they should be the owner of the Oracle rdbms processes. Next check the NATTCH column, should be 0 processes attached to the segment. If you still want to remove that segment (which is pretty safe when there are no processes attached), use the ID column as input for

ipcrm -M {your_ID}

Normally this does not solve a problem. There was a problem that made the instance crash .... check the alertlog, it could have some clues in it.


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.