ORA-00821 and ORA-4030 at Database Start Up in 11gR1 Due to Minimum Buffer Size Calculation.
(Doc ID 1336519.1)
Last updated on FEBRUARY 19, 2019
Applies to:Oracle Database - Standard Edition - Version 22.214.171.124 to 126.96.36.199 [Release 11.1]
Information in this document applies to any platform.
On Oracle 188.8.131.52/184.108.40.206, the following error occurs when issuing 'startup nomount'.
ORA-00821: Specified value of sga_target 4992M is too small, needs to be at least 8704M
The Alert log also shows:
Incident details in: /<diagnostic_dest>/diag/rdbms/<dbname>/<instname>/incident/incdir_57714/<sid>_dbrm_15773_i57714.trc
Errors in file /<diagnostic_dest>/diag/rdbms/<dbname>/<instname>/trace/<sid>_ping_15775.trc (incident=57730):
The SGA_MAX_SIZE or MEMORY_MAX_TARGET is large (many Gigabytes).
The server has many CPU's (for example: 32 or 64)
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document