STARTUP ERRORS ora-00824 cannot set sga_target with statistics_level=BASIC (Doc ID 461100.1)

Last updated on SEPTEMBER 20, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 10.1.0.2 to 12.1.0.2 [Release 10.1 to 12.1]
Information in this document applies to any platform.
***Checked for relevance on 20-Sep-2016***


Symptoms

Checked for relevance on 31-Oct-2011

You shutdown the database and on restart you see the following message

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

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

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

ALERT.LOG

ARCH: Archival disabled due to shutdown: ....
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Tue Oct 02 16:13:45 2007
Cannot set sga_target with statistics_level=BASIC

...

Changes

A new or recently altered PFILE or SPFILE was used for the first time with the database STATISTICS_LEVEL level set to BASIC and now after the instance is being restarted

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms