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.

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
1  
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
add comment

1 Answer

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
db_32k_cache_size=1024M

... 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):

ALTER SYSTEM SET DB_32K_CACHE_SIZE=1024M;
share|improve this answer
add comment

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.