In this post, you’ll learn more about the Oracle ErrorORA-00378: buffer pools cannot be created as specified with the details on why you receive this error and the possible solution to fix it.
Oracle Error Description
ORA-00378: buffer pools cannot be created as specified
Reason for the Error ORA-00378: buffer pools cannot be created as specified
Either the number of buffers or the number of lru latches is too small to satisfy the specified buffer pool configuration.
How to fix the Error ORA-00378: buffer pools cannot be created as specified ?
You can fix this error in Oracle by following the below steps
Either increase the number of buffers and/or number of lru latches or configure smaller buffer pools.