Wednesday, February 27, 2013

Solution to ORA-48913 caught while writing to trace file

On 11.2.0.3, encountered the following error in the alert.log:

Non critical error ORA-48913 caught while writing to trace file "/oraotcprd1/app/oracle/diag/rdbms/otcprd1/OTCPRD11/trace/OTCPRD11_ora_14925.trc"
Error message: ORA-48913: Writing into trace file failed, file size limit [10485760] reached

The reason was Parameter MAX_DUMP_FILE_SIZE  is set too low.

Solution

We can increase the setting for the parameter MAX_DUMP_FILE_SIZE or set it to unlimited

MAX_DUMP_FILE_SIZE specifies the maximum size of trace files (excluding the alert file). Change this limit if you are concerned that trace files may use too much space.
  • A numerical value for MAX_DUMP_FILE_SIZE specifies the maximum size in operating system blocks.
  • A number followed by a K or M suffix specifies the file size in kilobytes or megabytes.
  • The special value string UNLIMITED means that there is no upper limit on trace file size. Thus, dump files can be as large as the operating system permits.

Reference: http://docs.oracle.com/cd/E14072_01/server.112/e10820/initparams131.htm

3 comments:

  1. This is a good article & good site.Thank you for sharing this article. It is help us following categorize:
    healthcare, e commerce, programming,multi platform, it consulting, retail, manufacturing, CRM, technology means, digital supply chain management, Delivering high-quality service for your business applications,
    Solutions for all Industries,
    Getting your applications talking is the key to better business processes,
    Rapid web services solutions for real business problems,
    Web-based Corporate Document Management System,
    Outsourcing Solution,
    Financial and Operations Business Intelligence Solution,

    Our address:
    2002 Timberloch Place, Suite 200
    The Woodlands, TX 77380

    prologic-corp

    ReplyDelete
  2. Check this for similar issues:

    http://www.mammqm.blogspot.com/

    ReplyDelete
  3. Hi, I tried that recommended adding parameters in the sqlnet.ora, changed max_dump_file_size .

    connect sys as sysdba
    Oracle Version: 11.2.0.3.0
    OS: Windows
    Location of files: ..\ORACLE\diag\clients\user_SYSTEM\host_xxxxxxx_xx\the trace

    File ora_xxxx_xxx.trc is locked, it weighs more than 10 GB.

    Who holds, how to unlock and delete?

    ReplyDelete