ORA-00823: Specified value of sga_target greater than sga_max_size

Published by Ahmad on

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.

Leave a Reply

Your email address will not be published. Required fields are marked *