Non critical error ORA-48113 caught while writing to trace file

ORA-48113 caught while writing to trace file in Oracle

Error:

O/S-Error: (OS 112) There is not enough space on the disk.
Writing to the above trace file is disabled for now on...
Non critical error ORA-48113 caught while writing to trace file "E:\ORACLE\diag\rdbms\orcl\orcl\trace\orcl_dbrm_3481.trc"

Cause:

Cause was Parameter MAX_DUMP_FILE_SIZE is value set to low.
MAX_DUM_FILE_SIZE in defined the size of trace files.
If size of trace file go beyond the limit specified then it will generate error in alert log file.

Solution:

We can change the value for trace file size to unlimited.

ALTER SYSTEM SET max_dump_file_size=unlimited;

If we are enabled tracing for particular session then we can also do it at session level.

ALTER SESSION SET max_dump_file_size=unlimited;

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.