Ora-00823:specified value of Sga_target greater than sga_max_size

Source: Internet
Author: User
Change sga_max_size when accidentally less than the unit ' M ', the result encountered ORA-00823 caused the database can not start.
1. Modify Sga_max_size parameters in Pfile after creating Spfiel based on Pfile
2. Start the database with Pfile and test normal.
3. Create SPFile according to Pfiel
4. Start the database with SPFile.

Sql>alter SYSTEM SET sga_max_size = 4096 scope=spfile; Less write a m, the damage to the database can not get up

sql> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.

Sql> Startup Nomount
ora-00823:specified value of sga_target greater than sga_max_size

sql> CREATE pfile= '/opt/ora11g/product/11.2.3/db_1/dbs/pfile01.ora ' from SPFILE;
File created.

Sql>!
[Oracle@oradb01 emd]$ vi CREATE pfile= '/opt/ora11g/product/11.2.3/db_1/dbs/pfile01.ora ' from SPFILE;

*.sga_max_size=4096 instead
*.sga_max_size=4096m

sql> startup pfile= '/opt/ora11g/product/11.2.3/db_1/dbs/pfile01.ora '
ORACLE instance started.
Total System Global area 4275781632 bytes
Fixed Size 2266024 bytes
Variable Size 1681919064 bytes
Database buffers 2583691264 bytes
Redo buffers 7905280 bytes
Database mounted.
Database opened.
Sql>!
[Oracle@oradb01 emd]$ cd/opt/ora11g/product/11.2.3/db_1/dbs/

[ORACLE@ORADB01 dbs]$ CP Spfileorcl.ora SPFILEORCL.ORA_BAK01

[Oracle@oradb01 dbs]$ exit
Exit

sql> CREATE spfile= '/opt/ora11g/product/11.2.3/db_1/dbs/spfileorcl.ora ' from pfile= '/opt/ora11g/product/11.2.3/ Db_1/dbs/pfile01.ora ';

sql> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
Sql> Startup
ORACLE instance started.

Total System Global area 4275781632 bytes
Fixed Size 2235208 bytes
Variable Size 1677722808 bytes
Database buffers 2583691264 bytes
Redo buffers 12132352 bytes
Database mounted.
Database opened.

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.