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 23, 2022
Applies to:Oracle Database - Standard Edition - Version 188.8.131.52 to 184.108.40.206 [Release 11.1]
Information in this document applies to any platform.
On Oracle 220.127.116.11/18.104.22.168, 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