1. Modify the value of the initialization file as an error
-- error modifying SQL> alter system set db_block_buffers= scope=spfile; SQL> Shutdown immediate database is closed. The database has been uninstalled. The ORACLE routine has been closed. SQL> startupora-00824: Cannot set sga_target or memory_target due to existing internal sett Ingsora-00842: Db_block_buffers cannot is set with Sga_target or Memory_target
2. Generate Pfile files from SPFile
Sql> Create pfile from SPFile; The file has been created.
3. Open the Pfile file to modify the parameters, *.db_block_buffers=1000 Delete, save.
Sql> Create SPFile from Pfile; The file has been created. SQL>3390558208 bytesfixed size 2180464 bytesvariable size 1962936976 bytesdatabase buffers 1409286144 Bytesredo buffers 16154624 bytes Database is loaded. The database is already open.
Initialization parameter file modification error causes Oracle to fail startup