1872040 - Handling ORA-00060 error - application deadlock issue | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

1872040 - Handling ORA-00060 error - application deadlock issue

Symptom

You are seeing ORA-00060 error in the alert log file, as below:

ORA-00060: Deadlock detected. More info in file /oracle/PRD/saptrace/usertrace/prd_ora_9175250.trc

There might be also a short dump reported in ST22:

Runtime Errors         DBIF_RSQL_SQL_ERROR                                                          
Exception                 CX_SY_OPEN_SQL_DB                                                            
Date and Time         10.10.2012 11:38:14                                                          
                                                                                                   
Short text                                                                                         
      SQL error in the database when accessing a table.                                              
 
What happened?                                                                                     
      The database system detected a deadlock and avoided it by rolling back                         
      your transaction.                                             

How to correct the error                                                                           
       Database error text........: "ORA-00060: deadlock detected while waiting for                   
       resource"                                                                                     
       Internal call code.........: "[RSQL/UPDT/ADRC ]"                                               
       Please check the entries in the system log (Transaction SM21).

This KBA has additional information about the error ORA-00060 referred on SAP Note 84348, and focus specially on the APPLICATION DEADLOCK cases, that is not documented on mentioned note.


Read more...

Environment

  • SAP systems with Oracle database
  • Not restricted to a product or product version

Product

SAP NetWeaver all versions

Keywords

ORA-60, ORA_60, ORA_00060,DBIF_RSQL_SQL_ERROR,CX_SY_OPEN_SQL_DB, solution, database, oracle,db, lock, locks, slow, performance, deadlock_detected_while_waiting_for_resource, DEADLOCK_DETECTED, Database_error_60,Database_error_60_at_FET, ORA-00060:_Deadlock_detected, update, delete, insert, select, how_to, how_to_solve,SBP, patch, SAP, start, load, data,bw, bi, root_cause, RCA,init_trans, max_trans, from, what_to_do, bundle_patch, patch_collection, dead_lock, hang, hanging, upgrade, starting, loading, transaction, log, graph, deadlock_trace, Transaction_Deadlock, ad-hoc_SQL,rowid, session,objn,obj, dictionary,pid, application_name, waiting_sessions, action_name, End_of_information, block, (_ORA-00060_), dump_file, oracle_process, installation, client_info, kvsprint, add-on, nriv, program, adk, dump, sql_error_60, runtime , KBA , BC-DB-ORA , Oracle , BW-SYS-DB-ORA , BW ORACLE , BW-WHM-DST-DTP , Data Transfer Process , BW-WHM-DST , Data Staging , BC-UPG-OCS , Online Corr. Support (Tools:Supp.-Pack., Addon Install/Upgr) , BW-WHM-DBA-ODS , DataStore Object (classic) , SV-BO , Backoffice Service Delivery , BC-UPG-OCS-SPA , Support package tools for ABAP , BW-WHM-DBA-ICUB , InfoCubes , BW-WHM-DBA-MD , Master Data , SV-BO-DB-ORA , Service Delivery Oracle DB , BC-DB-ORA-DBA , Database Administration with Oracle , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.