Sunday, April 24, 2011

STARTUP ERRORS ora-00824 cannot set sga_target with statistics_level=BASIC

STARTUP ERRORS ora-00824 cannot set sga_target with statistics_level=BASIC
===================================================

This will happen, when your statistics_level parameter is set to BASIC but you define SGA_TARGET in oracle database 10g

SQL> startup
ORA-00824: cannot set sga_target due to existing internal settings, see alert log for more information

in alert log you can find this

Cannot set sga_target with statistics_level=BASIC

solution:-
change either one of these value of statistics_level to TYPICAL or SGA_TARGET =0

No comments: