Sga_max_size set too large to exceed Memory_target value, database cannot start, resulting in ora-00844 and ora-00851 errors

Source: Internet
Author: User
Solution to generate a new SPFile file with an alternate pfile file, pfile file location: Administrator\admin\orcl\pfilespfile file Location: administrator\product\11.2.0\ Dbhome_1\database and SPFile content has binary data, can not be directly modified, so only through pfile to generate a new spfile, generated directly modified Pfile value Memory_target. The process is as follows: 1, start with the standby pfile oraclec:/>sqlplus/nolog sql>conn/as sysdba sql>startup pfile= ' D:\app\Administrator\ admin\orcl\pfile\init.ora.1023201294648 ' This step to note the location of Pfile, the general 11g is the number of the end, should be able to find in the above directory, this file is a backup. It should be possible to start up in this way. 2, re-create spfilesql>create spfile from pfile= ' D:\app\Administrator\admin\orcl\pfile\init.ora.1023201294648 '; 3, restart the database Sql>shutdown immediate; Sql>startup, this step is going to be a good start.

Sga_max_size set too large to exceed Memory_target value, database cannot start, resulting in ora-00844 and ora-00851 errors

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.