In this post, you’ll learn more about the Oracle ErrorORA-00823: Specified value of sga_target greater than sga_max_size with the details on why you receive this error and the possible solution to fix it.
Oracle Error Description
ORA-00823: Specified value of sga_target greater than sga_max_size
Reason for the Error ORA-00823: Specified value of sga_target greater than sga_max_size
The specified value of sga_target is greater than sga_max_size.
How to fix the Error ORA-00823: Specified value of sga_target greater than sga_max_size ?
You can fix this error in Oracle by following the below steps
Increase sga_max_size to match up with sga_target or decrease sga_target to match up with sga_maxsize.