Oracle ORA-00060 Troubleshooting Wizard

For troubleshooting the deadlock issue , there is one great tool oracle provides .It is  Oracle ORA-00060 Troubleshooting Wizard, it is part of RDA which oracle provides.

Let me demonstrate on how to use it .

first , download here https://support.oracle.com/epmos/faces/DocumentDisplay?parent=DOCUMENT&sourceId=1550091.2&id=314422.1#download  

Unzip the files , move in RDA/da directory


==> cd da
[DB]oracle@server:/opt/app/home/oracle/rda/da
==> ./da.sh menu menus/ora60.xml
           Oracle ORA-00060 Troubleshooting Wizard            04-17 11:55:27


  The ORA-00060 Troubleshooting Wizard Menu provides the automatic scanning
  of an alert log for ORA-00060 errors and subsequently providing the details
  of the deadlock along with suggested resolutions.  This menu also allows for
  you to perform these tasks separately.

  Select option 1 to begin automatic diagnosis:
    1 RECOMMENDED: Automatically diagnose latest ORA-00060 trace files
    2 Manually identify, then diagnose latest ORA-00060 trace files
    3 Determine an object name from the "dictionary objn" value
    4 Package Files for upload
    5 Package and Upload results to a SR
    6 Create Draft SR [MOS connection required]

    Help    Exit


             [ DA Output Usage: 56K, Free: 159.7G, %Disk Used: 19% ]

  Make Selection ==> 1

  Please enter the location to your Alert Log:
    ... DA_SESSION_ALERT_LOG_DIR=/opt/app/oracle/diag/rdbms/dbname/DBNAME/trace/alert_DBNAME.log
  ==>    Note: Only one choice available, auto-selected:1

JAVA collector running: Determine the type of ORA-00060 error you are encountering






Make sure you have set correct database environment , as its picks the database alert log automatically.