This discussion is archived
9 Replies Latest reply: Apr 26, 2013 12:05 AM by asahide RSS

Where is udump in 11.2.0.1?

yxes2013 Newbie
Currently Being Moderated
Hi all,

11.2.0.1

I am tracing my database due to lots of locking error.

ALTER SYSTEM SET SQL_TRACE = TRUE SCOPE=MEMORY;

And then look for my dump using > show parameter dump
SQL> show parameter dump

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
background_core_dump                 string      partial
background_dump_dest                 string      /u01/app/oracle/diag/rdbms/edm
                                                 p2/edmp2/trace
core_dump_dest                       string      /u01/app/oracle/diag/rdbms/edm
                                                 p2/edmp2/cdump
max_dump_file_size                   string      unlimited
shadow_core_dump                     string      partial
user_dump_dest                       string      /u01/app/oracle/diag/rdbms/edm
                                                 p2/edmp2/trace
I can see only trace and cdump :( where is adump, bdump, and udump?


Thanks
  • 1. Re: Where is udump in 11.2.0.1?
    %bala% Explorer
    Currently Being Moderated
    Please refer.

    http://docs.oracle.com/cd/B28359_01/server.111/b28320/initparams071.htm
  • 2. Re: Where is udump in 11.2.0.1?
    Justin Cave Oracle ACE
    Currently Being Moderated
    I sure seem to see a UDUMP in the output you posted
    user_dump_dest                       string      /u01/app/oracle/diag/rdbms/edm
                                                     p2/edmp2/trace
    Justin
  • 3. Re: Where is udump in 11.2.0.1?
    Kh$n Journeyer
    Currently Being Moderated
    udump bdump are replace with diagnostic_dest in 11g

    background_dump_dest         11.1   DEPRECATED   replaced by "diagnostic_dest"
    user_dump_dest               11.1       DEPRECATED   replaced by "diagnostic_dest"
    core_dump_dest               11.1       DEPRECATED   replaced by "diagnostic_dest"

    Edited by: Kh$n on Apr 25, 2013 11:11 PM
  • 4. Re: Where is udump in 11.2.0.1?
    asahide Expert
    Currently Being Moderated
    Hi,

    What's your DIAGNOSTIC_DEST ?

    You can check by follows.
    SQL> select * from v$diag_info;
    # check Diag Trace.

    Regards,

    Edited by: asahide on 2013/04/26 15:11
  • 5. Re: Where is udump in 11.2.0.1?
    Aman.... Oracle ACE
    Currently Being Moderated
    It's been replaced with the Trace folder under Diag .

    Aman....
  • 6. Re: Where is udump in 11.2.0.1?
    yxes2013 Newbie
    Currently Being Moderated
    I thank you all,


    There so lots of folders in diag which are confusing. :(

    So where can I find my output for > ALTER SYSTEM SET SQL_TRACE = TRUE SCOPE=MEMORY;
    SQL> /
             1 Diag Enabled
    TRUE
    
             1 ADR Base
    /u01/app/oracle
    
             1 ADR Home
    /u01/app/oracle/diag/rdbms/edmp2/edmp2
    
             1 Diag Trace
    /u01/app/oracle/diag/rdbms/edmp2/edmp2/trace
    
             1 Diag Alert
    /u01/app/oracle/diag/rdbms/edmp2/edmp2/alert
    
             1 Diag Incident
    /u01/app/oracle/diag/rdbms/edmp2/edmp2/incident
    
             1 Diag Cdump
    /u01/app/oracle/diag/rdbms/edmp2/edmp2/cdump
    
             1 Health Monitor
    /u01/app/oracle/diag/rdbms/edmp2/edmp2/hm
    
             1 Default Trace File
    /u01/app/oracle/diag/rdbms/edmp2/edmp2/trace/edmp2_ora_16846.trc
    
             1 Active Problem Count
    0
    
             1 Active Incident Count
    0
    
    
    11 rows selected.
    thanks
  • 7. Re: Where is udump in 11.2.0.1?
    yxes2013 Newbie
    Currently Being Moderated
    The has been lots of "locking" transaction happening. Can I see it in OEM emca database control, or in the database level trace and tkfprof ?
    75aae07c:13e44f1f938:c78@10.0.0.12 ffup553 26-abr-13 02:09:58 org.hibernate.util.JDBCExceptionReporter ERROR ORA-00054: recurso ocupado y obtenido con NOWAIT especificado o timeout vencido 
    192.178.100.38 
    -75aae07c:13e44f1f938:c7c@10.0.0.12 ffup553 26-abr-13 02:09:58 com.smartmatic.sge.services.tickets.TicketManagementBean ERROR TaskInstance = 25840were not unassigned by actor = ffup553 10.0.0.12 192.178.100.38 
  • 8. Re: Where is udump in 11.2.0.1?
    asahide Expert
    Currently Being Moderated
    Hi,

    Check Diag Trace /u01/app/oracle/diag/rdbms/edmp2/edmp2/trace
    Regards,
  • 9. Re: Where is udump in 11.2.0.1?
    yxes2013 Newbie
    Currently Being Moderated
    What are these lots *.trm files for?

    It has 3 lines like

    @2|2|eMJRFfZV1"11334|edmp2|
    M/eMJRFfZV1~D1Q2
    6?qIIRFfZV1~79v


    Thanks

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points