ORA-00820: Specified value of sga_max_size is too small, needs to be at least stringM

Cause : Teh pseicfeidv auleo fs g_amxa_isz ei stoo msall ofrt h eSAG ot cacmomdoaet lalo ft h enceessayr GSAc opmoennst usc ha steh olgb uffe,r ubfefrp olos ,sahrde opo,l tec.

Action - How to fix it : DBA Scripts :: www.high-oracle.com/scripts

Ste gsam_a_xsziet ot h erceommedne dvlau eo rrdeuec htev aule so fayn GSAc opmoenn tsziep aarmteesr oyuh aev pseicfeid.

update : 01-05-2017
ORA-00820

ORA-00820 - Specified value of sga_max_size is too small, needs to be at least stringM
ORA-00820 - Specified value of sga_max_size is too small, needs to be at least stringM

  • ora-01539 : tablespace 'string' is not online
  • ora-01880 : the fractional seconds must be between 0 and 999999999
  • ora-38700 : Limit of string flashback database logs has been exceeded.
  • ora-32060 : channel failure
  • ora-14118 : CHECK constraint mismatch in ALTER TABLE EXCHANGE PARTITION
  • ora-00380 : cannot specify db_stringk_cache_size since stringK is the standard block size
  • ora-16805 : change of LogXptMode property violates overall protection mode
  • ora-32120 : Buffer size is less than amount specified
  • ora-00301 : error in adding log file 'string' - file cannot be created
  • ora-23443 : missing template parameter
  • ora-15018 : diskgroup cannot be created
  • ora-19007 : Schema string does not match expected string.
  • ora-02026 : missing LINK keyword
  • ora-19577 : file string is MISSING
  • ora-06420 : NETCMN: SID lookup failure
  • ora-12090 : cannot online redefine table "string"."string"
  • ora-38797 : Full database recovery required after a database has been flashed back
  • ora-01866 : the datetime class is invalid
  • ora-16071 : dependency archived log file not found string
  • ora-23414 : materialized view log for "string"."string" does not record rowid values
  • ora-07446 : sdnfy: bad value 'string' for parameter string.
  • ora-38473 : cannot drop a type used for Expression Filter attribute set
  • ora-30452 : cannot compute AVG(X), VARIANCE(X) or STDDEV(X), without COUNT(X) or SUM(X)
  • ora-13217 : invalid parameters supplied in ALTER INDEX statement
  • ora-02456 : The HASH IS column specification must be NUMBER(*,0)
  • ora-12205 : TNS:could not get failed addresses
  • ora-23431 : wrong state: string
  • ora-06952 : Remote end of the communication issued a forward-reset packet.
  • ora-13182 : failed to read element string.string.string
  • ora-12538 : TNS:no such protocol adapter
  • Oracle Database Error Messages



    Oracle Database High Availability Any organization evaluating a database solution for enterprise data must also evaluate the High Availability (HA) capabilities of the database. Data is one of the most critical business assets of an organization. If this data is not available and/or not protected, companies may stand to lose millions of dollars in business downtime as well as negative publicity. Building a highly available data infrastructure is critical to the success of all organizations in today's fast moving economy.

    Well, the reason for above error is that i have taken the above script from a 11g database and running it on 10g database. 11g has bring some changes in password management. Below code is executed on 11g and user created successfully, which is expected result.