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 post is ad-supported |
|
No comments:
Post a Comment