ORA-00832: no streams pool created and cannot automatically create one
Cause: A database feature which needs STREAMS SGA was being used, however, the streams_pool_size parameter was not defined and the value of db_cache_size was too small to permit an automatic transfer of SGA to the streams pool from the buffer cache
Action: Please set the parameter streams_pool_size or set sga_target
ORA-00830: cannot set statistics_level to BASIC with auto-tune SGA enabled
Cause: The user attempted to set statistics_level to BASIC with auto-tune SGA enabled which cannot be done because auto-tune SGA cannot work with statistics_level set to BASIC
Action: Disable auto-tune SGA and try setting the statistics_level to BASIC again
ORA-00828: specified value of shared_pool_reserved_size inconsistent with internal settings
Cause: Unable to set shared_pool_reserved_size to specified value if sga_target set, either because the specified value is too small, or because it is too large for the current internal size of shared pool. More details can be found in the alert log
Action: If possible, do not set shared_pool_reserved_size without setting shared_pool_size if sga_target set. Examine the alert log for information about current internal size of shared pool, and valid range of values for shared_pool_reserved_size
ORA-00827: could not shrink sga_target to specified value
Cause: Attempted to shrink the SGA to the specified value but did not succeed because the SGA components could not be shrunk as they were already at their minimum sizes
Action: Do not set sga_target to a value below the current value without first shrinking the individual SGA components
ORA-00826: cannot set sga_target for an ASM instance
Cause: sga_target set for an ASM instance
Action: Do not set sga_target
ORA-00825: cannot set db_block_buffers if sga_target set
Cause: sga_target set with db_block_buffers set
Action: Do not set sga_target or use new cache parameters and do not use db_block_buffers which is a old cache parameter
ORA-00824: cannot set sga_target due to existing internal settings, see alert log for more information
Cause: Unable to set sga_target due to current parameter settings
Action: See alert log for more information
ORA-00823: Specified value of sga_target greater than sga_max_size
Cause: The specified value of sga_target is greater than sga_max_size
Action: Increase sga_max_size to match up with sga_target or decrease sga_target to match up with sga_maxsize
ORA-00822: MMAN process terminated with error
Cause: The Memory Management process died
Action: Warm start instance
ORA-00821: Specified value of sga_target stringM is too small, needs to be at least stringM
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
Action: Set sga_target to the recommended value or reduce the values of any SGA component size parameters you have specified