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;
This entry was posted in Oracle on by .
Unknown's avatar

About SandeepSingh

Hi, I am working in IT industry with having more than 15 year of experience, worked as an Oracle DBA with a Company and handling different databases like Oracle, SQL Server , DB2 etc Worked as a Development and Database Administrator.

Leave a Reply