ORA-600 [504] "Trying to obtain a latch which is already held" [ID 28104.1]

ORA-600 [504] "Trying to obtain a latch which is already held" [ID 28104.1]

转到底部

---

修改时间:2012-8-24类型:REFERENCE状态:PUBLISHED优先级:3

注释 (0)

Note: For additional ORA-600 related information please read Note:146580.1

PURPOSE:            
  This article discusses the internal error "ORA-600 [504]", what 
  it means and possible actions. The information here is only applicable 
  to the versions listed and is provided only for guidance.
 
ERROR:              

  Format: ORA-600 [504] [a] [b] [c] [d] [e] [f] [g]

 
VERSIONS:
  versions 6.0 to 9.2
 
DESCRIPTION:

  This ORA-600 triggers when a latch request violates the ordering 
  rules for obtaining latches and granting the latch would potentially 
  result in a deadlock.

  These ordering rules are enforced by assigning each latch a "level#", 
  and checking requested-level vs owned-levels on each latch request. 
 
ARGUMENTS:
  Arg [a] the requested latch address
  Arg [b] bit array of latches owned
  Arg [c] the level of the requested latch
  Arg [d] the name of the requested latch
  Arg [e] the child latch number of the requested latch
  Arg [f] if non zero, allows 2 wait gets of children
  Arg [g] address of latch owned at this level
 
FUNCTIONALITY:
  KERNEL SERVICE LAYER - LATCHING
 
IMPACT:
  PROCESS FAILURE
  NON CORRUPTIVE - No underlying data corruption.
 
SUGGESTIONS:

  Look for trace files generated at the time of the error.
  Contact Oracle Support Services and provide the alert.log and 
  associated trace files for further diagnosis.
 
  Known Issues:

Known Bugs

You can restrict the list below to issues likely to affect one of the following versions by clicking the relevant button:

The list below is restricted to show only bugs believed to affect version 11.2.0.1.
Other bugs may affect this version but have not been confirmed as being relevant yet.

There are 5 bugs listed.

NB	Bug	Fixed	Description
	9305865	11.2.0.3, 12.1.0.0	ORA-600 [504] .. [ASM map operation hash table] during diagnostic dump
	8966823	10.2.0.5.6, 11.2.0.2, 12.1.0.0	LMON dump ORA-7445 [kjrchc] / ORA-600 [504]
	8607693	11.1.0.7.3, 11.2.0.1.1, 11.2.0.1.BP04, 11.2.0.2, 12.1.0.0	OERI [504] can occur in RAC with XA transactions
	10214450	10.2.0.5.5, 11.2.0.2	ORA-600 [kcbo_unlink_q_1] / ORA-600 [504] from Ctrl-C / interrupt
	10108006	11.2.0.1.BP10, 11.2.0.2	ORA-600 [504] [gcs resource hash] in RAC with fix for bug 9664675

• '*' indicates that an alert exists for that issue.
• '+' indicates a particularly notable issue / bug.
• 'I' indicates an install issue / bug included for completeness.
• 'P' indicates a port specific bug.
• Fixed versions use "BPnn" to indicate Exadata bundle nn.
• "OERI:xxxx" may be used as shorthand for ORA-600 [xxxx].