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
Halim, a Georgia Tech graduate Senior Database Engineer/Data Architect based in Atlanta, USA, is an Oracle OCP DBA and Developer, Certified Cloud Architect Professional, and OCI Autonomous Database Specialist. With extensive expertise in database design, configuration, tuning, capacity planning, RAC, DG, scripting, Python, APEX, and PL/SQL, he combines technical mastery with a passion for innovation. Notably, Halim secured 16th place worldwide in PL/SQL Challenge Cup Playoff on the year 2010.
Sunday, April 24, 2011
Subscribe to:
Post Comments (Atom)
My Blog List
-
-
-
Coalesce SQ bug4 weeks ago
-
UKOUG Discover 20244 months ago
-
-
-
-
-
-
-
-
Moving Sideways8 years ago
-
-
Upcoming Events...11 years ago
-
No comments:
Post a Comment