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. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I'm trying to do collection_manager in OVPI but I'm getting db error

ORA-00379 no free buffers available in buffer pool default for block size 32k oracle 10.2

Thanks for any help in advance

share|improve this question
You could tell us what version of Oracle you are using and what DB_BLOCK_BUFFERS is set to. That would help. – kevinsky Jul 24 '12 at 12:36

This is happening because your default database block size is set to something other than 32k, and as a result there's no 32k cache buffers available.

To fix this, add:

#change 1024M to the desired amount of cache

... to the init.ora for your database instance & then restart the database.

You may also be able to change this without restarting (as sysdba from sqlplus):

share|improve this answer

Your Answer


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.