ORA-00821 and ORA-4030 at Database Start Up in 11gR1 Due to Minimum Buffer Size Calculation.
(Doc ID 1336519.1)
Last updated on SEPTEMBER 08, 2023
Applies to:
Oracle Database - Standard Edition - Version 11.1.0.6 to 11.1.0.7 [Release 11.1]Information in this document applies to any platform.
Symptoms
On Oracle 11.1.0.6/11.1.0.7, the following error occurs when issuing 'startup nomount'.
ORA-01078: failure in processing system parameters
ORA-00821: Specified value of sga_target 4992M is too small, needs to be at least 8704M
ORA-00821: Specified value of sga_target 4992M is too small, needs to be at least 8704M
The Alert log also shows:
ORA-04030: out of process memory when trying to allocate 800 bytes (kgsp-heap,kglss)
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):
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)
Cause
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
| Symptoms |
| Cause |
| Solution |
| References |