Oracle database modified sga_max_size and sga_target restart report ORA-00821 error

Failure background:

Operating system restart for the server, due to hardware problems, the server restarts after 128GB memory loss of half, causing the application process data processing slow. The Oracle software version is 10.2.0.5. In particular, a database data file uses a shared volume group of bare devices, and spfile is a bare device on a shared volume group.

An emergency decision to reduce the SGA memory configuration on this server to the historical database is generally reduced.

Unexpected problems:

After modifying Sga_max_size and Sga_target, the database instance is restarted and the error message is ORA-00821.

Emergency treatment:

In the shutdown state, the production of Pfile by SPFile. Edit the Pfile file, and adjust the values of the sga_max_size and Sga_target parameters. Start the database with Pfile, and write the pfile content to SPFile

Operation Steps:

(1) In the open state, modify the SGA memory configuration, the original configuration is reduced to a general

Alter system set sga_max_size=12240m Scope=spfile;

Alter system set sga_target=12240m Scope=spfile;

(2) Start the database report ORA-00821 error

sql> shutdown Immediate

Sql> Startup

Ora-00821:specified value of Sga_target 3072M is too small, needs to being at least 12896M

(3) View SPFile as a bare device file

$ more/home/db/oracle/product/10.2.0/dbs/initwcmdb.ora

Spfile= '/home/db/oracle/oradata/wcmdb/rspfile_01_512m '

$ ls-l rspfileptdb_128m

lrwxrwxrwx 1 Oracle DBA 14:29 rspfileptdb_128m-/DEV/RAW/RAW10

(4) In Shutdown state, produced by SPFile Pfile

sql> create pfile= '/tmp/pfile.0919 ' from spfile= '/home/db/oracle/oradata/wcmdb/rspfile_01_512m ';

(5) Edit Pfile

$ vi/tmp/pfile.0919

Change the sga_max_size and Sga_target parameter values to a smaller

(6) In Shutdown state, start the database with Pfile

sql> startup pfile= '/tmp/pfile.0919 '

(7) In open state, produced by Pfile SPFile

Create spfile= '/home/db/oracle/oradata/wcmdb/rspfile_01_512m ' from pfile= '/tmp/pfile.0919 '

Note: Full path must be written after SPFile

This article is from "Lao li" blog, please be sure to keep this source http://2792530.blog.51cto.com/2782530/1967279

Oracle database modified sga_max_size and sga_target restart report ORA-00821 error