Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

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
share|improve this question

1 Answer 1

up vote 3 down vote accepted

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.

share|improve this answer
    
+1 from me. Not many of us Oracle/Solaris types about –  Phil Apr 18 '13 at 19:55

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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