:

ORA-00093: _shared_pool_reserved_min_alloc must be between 4000 and 0

If you experience the following error messsage when starting up your database, try changing the “COMPATIBLE” parameter to a 5 digit one. For example, I was running Oracle 11g and originally the COMPATIBLE parameter was set to 11.2.0. I changed it to 11.2.0.3.0, attempted another STARTUP MOUNT command and it worked without a problem.

SQL> startup mount
ORA-01078: failure in processing system parameters
ORA-00093: _shared_pool_reserved_min_alloc must be between 4000 and 0

Maybe it was just a coincidence that it worked after changing it but it certainly did the job for me. There was also another time that I hit the ORA-00093 error message and that was the result of some incorrectly configured initialisation parameters, so check out the other article.

Like it, share it...

Category: 11g


Related Posts

Leave a Reply

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