ORA-00823: Specified value of sga_target greater than sga_max_size
Why i get this error ORA-00823: Specified value of sga_target greater than sga_max_size.
Actually i was doing some practice on that time i set my sga_target to some values after that i closed the database.
Next day when i was opening the database i get this error ORA-00823: Specified value of sga_target greater than sga_max_size.
After that what i have done i am showing it.
Microsoft Windows [Version 10.0.17134.471] (c) 2018 Microsoft Corporation. All rights reserved. C:\Users\hp>sqlplus / as sysdba SQL*Plus: Release 22.214.171.124.0 Production on Fri Dec 21 06:06:31 2018 Copyright (c) 1982, 2016, Oracle. All rights reserved. Connected to an idle instance.
SQL> startup ORA-00823: Specified value of sga_target greater than sga_max_size ORA-01078: failure in processing system parameters Now Shut down the database. SQL> shut immediate ERROR: ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist Process ID: 0 Session ID: 0 Serial number: 0 SQL> exit Disconnected
Now login without username and password.
C:\Users\hp>sqlplus /nolog SQL*Plus: Release 126.96.36.199.0 Production on Sat Dec 22 12:24:10 2018 Copyright (c) 1982, 2016, Oracle. All rights reserved. SQL>
Now create the pfile from spfile. Open the pfile & set sga_target=0 and Save it.After That Create spfile from pfile;
SQL> create pfile='D:\initorcl12c.ora' from spfile; File created. SQL> create spfile from pfile='D:\initorcl12c.ora'; File created.
Now Start the Database.
SQL> startup ORACLE instance started. Total System Global Area 5133828096 bytes Fixed Size 8929496 bytes Variable Size 956305192 bytes Database Buffers 4160749568 bytes Redo Buffers 7843840 bytes Database mounted. Database opened. SQL>
Now database is ready to use.
I Hope this post will give you much information. Your comments are always welcome.
(OCE in 11gR2 RAC)
(OCP in 11gR2/10gR2/9iR2)