Oracle DBA, How To, Error, Cause and Action

ORA-08412: error encountered in WMSGBSIZ, size for WMSGBLK is not big enough for warning message

ORA-08412: error encountered in WMSGBSIZ, size for WMSGBLK is not big enough for warning message


Cause:


The WMSGBSIZ is the maximun size for warning message block, it is recommanded to be 1024 bytes to 8 kbytes.



Action:


Defined WMSGBLK of size between 1k to 8k bytes and update the WMSGBSIZ to the sizeof(WMSGBLK).

No comments:

Post a Comment

Thanks for your comment.