SQL> startup nomount pfile=initaux.ora ORA-00821: Specified value of sga_target 5120M is too small, needs to be at least 12352M ORA-01078: failure in processing system parameters SQL> exit |
If you are trying to startup an instance and it returns message ORA-00821, this clearly means the SGA size in insufficient and you must increase the value of SGA to at least the size advised in the message. In above example, advice is to set SGA_TARGET to at least 1235M. I set it to 13G and was able to start the instance.
No comments:
Post a Comment