Saturday, May 5, 2012

DB Startup Fails on WORKAREA_SIZE_POLICY

A short posting just as an FYI in case you hit this Oracle startup error. I couldn't find any web post or MOS post covering this error so maybe this will help some one else hitting this nuance error.

When using the init parameters MEMORY_MAX_TARGET and/or MEMORY_TARGET you may get and error on startup the these are incompatible with WORKAREA_SIZE_POLICY. If this occurs simply unset that policy parameter. On startup it will then be set to the default value of AUTO which is the most common value. Setting it to MANUAL does not work.

That was my experience.
Just an FYI.

No comments:

Post a Comment