Cause
The specified value of sga_target is too small for the SGA to accommodate all of the necessary SGA components such as the log buffer, buffer pools, shared pool, etc.
The specified value of sga_target is too small for the SGA to accommodate all of the necessary SGA components such as the log buffer, buffer pools, shared pool, etc.
Set sga_target to the recommended value or reduce the values of any SGA component size parameters you have specified.
Try the following links for this error:
http://docs.oracle.com/cd/E16655_01/server.121/e26079/e0.htm
https://community.oracle.com/message/1956850
https://community.oracle.com/message/3726870
https://community.oracle.com/message/9653686
https://community.oracle.com/message/4518238
https://community.oracle.com/message/9862101
https://community.oracle.com/message/4384002
https://community.oracle.com/message/11259528
https://community.oracle.com/message/1439928
https://community.oracle.com/message/3709234
https://community.oracle.com/message/3366483
https://community.oracle.com/message/1443601
https://community.oracle.com/message/2343441
https://community.oracle.com/message/1492377
https://community.oracle.com/message/9842045
Browse all solutions to database errors from Oracle, MS SQL, or MySQL