Friday, January 17, 2014

11gR2 database bug due to ASM defaults

Did you know that ORA-04031 errors can crop up on you, if you have ASM configured with the default memory parameters being too low?  Serious!  Look up MOS Note ID 14292825.8 where a patch is suggested AND an alternative to patching by setting your MEMORY_TARGET value correctly.  You may want to proactively verify that your databases on and up (not including 12.1) have the correct ASM values set to avoid unexpected outages!

No comments:

Post a Comment