How to modify SPFile parameters in the case of Oracle shutdown _oracle

Find problems

I used the oracle11g, when I knocked down the following command, let me dumbfounded.

Alter system set sga_max_size=960m Scope=spfile;
Shutdown immediate
Startup

At this time the startup error is:

sql> startup
Ora-00844:parameter not taking Memory_target to account
ora-00851:sga_max_size 985661440 Cannot is set to the more than Memory_target 784334848.

Cause analysis

The original in the oracle11g added memory_target parameters, sga_max_size must be memory_target smaller than the parameters. So the problem comes, at this time I have closed Oracle, spfile file is binary file, and can not manually modify, then I should do it. Good catch urgent good catch urgent ...

Solving ideas

Start oracle–> in Oracle by create pfile='' from spfile='' removing the SPFile content (Pfile can be manually modified) –> Modify the new pfile–> to start with a new pfile oracle–> By create spfile='' from pfile='' getting the modified spfile in Oracle

Actual combat

[oracle@wing ~]$ sqlplus/as sysdba sql*plus:release 11.2.0.4.0 Production on Mon Feb 14:04:46 Copyright (c) 19 2013, Oracle.
All rights reserved.
Connected to a idle instance. sql> create pfile= '/home/oracle/pfile.new ' from spfile= '/u01/app/oracle/product/11.2.0/db_1/dbs/
Spfilewingdb.ora ';
File created. Sql> exit disconnected from Oracle Database 11g Enterprise Edition release 11.2.0.4.0-64bit Production with the Parti Tioning, OLAP, Data Mining and real application testing options through VI modify the corresponding parameters in the Pfile.new file (this document is the Memory_target parameter), modified to save [ora Cle@wing ~]$ sqlplus/as sysdba sql*plus:release 11.2.0.4.0 Production on Mon Feb 14:04:46 Copyright (c) 1982, 2 013, Oracle.
All rights reserved.
Connected to a idle instance.
sql> startup pfile= '/home/oracle/pfile.new ' Oracle instance started.   Total System Global area 810090496 bytes Fixed Size 2257520 bytes Variable Size 415239568 bytes Database buffers 390070272 bytes Redo buffers 2523136 bytesSE mounted.
Database opened. sql> create spfile= '/u01/app/oracle/product/11.2.0/db_1/dbsspfilewingdb.ora ' from pfile= '/home/oracle/pfile.new
';
File created.
sql> shutdown immediate Database closed.
Database dismounted.
ORACLE instance shut down. Sql> exit disconnected from Oracle Database 11g Enterprise Edition release 11.2.0.4.0-64bit Production with the Parti Tioning, OLAP, Data Mining and real application testing options [oracle@wing ~]$ sqlplus/as sysdba-sql*plus:release 11. 2.0.4.0 Production on Mon Feb 14:08:40 2016 Copyright (c) 1982, 2013, Oracle.
All rights reserved.
Connected to a idle instance.
Sql> sql> Startup ORACLE instance started.   Total System Global area 810090496 bytes Fixed Size 2257520 bytes Variable Size 415239568 bytes Database buffers
390070272 bytes Redo buffers 2523136 bytes Database mounted.
Database opened. Sql> Show parameter Memory NAME TYPE--------------------------------------------------------------------
VALUE------------------------------hi_shared_memory_address integer 0 memory_max_target big integer 800M memory_ Target big integer 800M shared_memory_address integer 0 sql> show parameter SGA NAME TYPE------------- -------------------------------------------------------VALUE------------------------------Lock_sga boolean fals E PRE_PAGE_SGA boolean FALSE sga_max_size big integer 776M sga_target big integer 740M # This Oracle uses the new SPF Ile started successfully and the parameters were modified accordingly

Summarize

The above is about how in the case of Oracle close to modify the SPFile inside the full content of the parameters, I hope the content of this article for everyone's study or work can bring some help, if you have questions you can message exchange.