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
