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 12.2.0.1.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 12.2.0.1.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.
Cheers !!!!?
Thanks
Ahmad
(Oracle Consultant)
(OCE in 11gR2 RAC)
(OCP in 11gR2/10gR2/9iR2)
5 Comments
Justin · January 6, 2019 at 4:14 pm
Thanks sir
bandarqiu · July 6, 2019 at 6:18 am
Peculiar article, just what I was looking for. https://www.deviantart.com/boyaqq
kumpulan bandar ceme · July 16, 2019 at 3:50 am
Nice post. I was checking constantly this blog and I’m impressed!
Very helpful info specially the last part 🙂 I care for such info a lot.
I was seeking this certain information for a very long time.
Thank you and best of luck. http://ctsite.us
kumpulan bandar ceme · July 16, 2019 at 3:50 am
Nice post. I was checking constantly this blog and I’m impressed!
Very helpful info specially the last part 🙂 I care for such info
a lot. I was seeking this certain information for a very long time.
Thank you and best of luck. http://ctsite.us
Aurora · October 22, 2020 at 7:26 pm
Hi there, I enjoy reading through your post. I wanted to write a little comment to support you.