Trace Files Not Being Generated
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 3 123 LastLast
Results 1 to 10 of 23

Thread: Trace Files Not Being Generated

  1. #1
    Join Date
    Jun 2001
    Posts
    76
    Trace files have stopped being generated on my database server. (bdump, cdump, udump, etc...). The parameters are set in init.ora:

    background_dump_dest = /u08/OraHome1/admin/ORCL/bdump
    core_dump_dest = /u08/OraHome1/admin/ORCL/cdump
    user_dump_dest = /u08/OraHome1/admin/ORCL/udump

    Parameters are recognized in v$parameter:

    SVRMGR> select name, value from v$parameter where name like '%dump%';
    NAME VALUE
    -------------------------- ---------------
    shadow_core_dump partial
    background_core_dump partial
    background_dump_dest /u08/OraHome1/admin/ORCL/bdump
    user_dump_dest /u08/OraHome1/admin/ORCL/udump
    core_dump_dest /u08/OraHome1/admin/ORCL/cdump

    OS: Solaris 8
    DB: Oracle 8.1.5

    Oracle has proper permissions to /u08/... and everything below it. ANY IDEAS?

    Thanks,
    R

  2. #2
    Join Date
    May 2000
    Location
    Portsmouth, NH, USA
    Posts
    378

    Did they used to get posted?

    Check the space you have left on that disk.

  3. #3
    Join Date
    Jun 2001
    Posts
    76
    Yes, they used to get generated... I wish I knew what happened immediately before it stopped, but I do not.

    There is plenty of space left on the device:
    /dev/dsk/c5t2d0s0 17404618 950730 16279842 6% /u08

    On the other hand, you have different fingers.

  4. #4
    Join Date
    Sep 2001
    Location
    Düsseldorf, Germany.
    Posts
    588
    Has Anybody stopped generation of trace files by changing SQL_TRACE parameter?

    Is SQL_TRACE still TRUE

    check

    SQL> show parameter sql_trace

    Sameer

  5. #5
    Join Date
    Jun 2001
    Posts
    76
    Thanks.

    It had been set to false:

    SQL> show parameter sql_trace;

    NAME TYPE VALUE
    ------------------------------------ ------- --------------------
    sql_trace boolean FALSE

    I appreciate your help.
    On the other hand, you have different fingers.

  6. #6
    Join Date
    Jun 2001
    Posts
    76
    I changed init.ora to include:

    sql_trace = true

    However, this has not enabled trace files (or at least they are not being generated). Is there anything else I can look for/check?

  7. #7
    Join Date
    May 2000
    Location
    Portsmouth, NH, USA
    Posts
    378

    Bounce the DB.

  8. #8
    Join Date
    Jun 2001
    Posts
    76
    Did that when I changed init.ora. Did not seem to help.

    On the other hand, you have different fingers.

  9. #9
    Join Date
    Sep 2001
    Location
    Düsseldorf, Germany.
    Posts
    588
    What about

    SQL>show parameter oracle_trace_enable

    Sameer

  10. #10
    Join Date
    Jun 2001
    Posts
    76
    That parameter is already enabled. Is there somewhere I can get a list of parameters relating to trace?
    On the other hand, you have different fingers.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width