ORA-00600: internal error code, arguments: [504], [677847912], [144], [5], [library cache], [5], , [0]

DESCRIPTION:

This ORA-00600 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] is the requested latch (structure address)
Arg is the level of the requested latch.
Arg [c] is the name of the requested latch
Arg [d] is a description of the latch/lock being attained:
[INSTANCE LATCH]
[LATCH WAIT LIST]
[LOCK ELEMENT PARENT LATCH]
[INSTANCE LATCH]
[ROW CACHE OBJECTS]
[LIBRARYCACHE]

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.

ORA-600 [4820] - possible bug 1951929

Mozhesh probovatj patchitj s posljednjim patchsetam

Vobsche to da, oracle razmeschajet patchseti na metalink. No mozhno probovatj iskatj v internete.

Posmotri:

http://support.mebius.lv/paths.jsp

1. я тут вижу файл на 300 метров - p2376472_8174_HP64.zip - это апгрейд до 8.1.7.4, верно?

-- da, no etot patchset dlja HP 9000 HP-UX 64-bit Oracle server


2. как я помню, каждый патчсет требует кучи соотв. заплат для операционной системы. Это условие обязательно соблюдать?

-- mozhet bitj, shto eto zavisit ot platformi. Dlja Solaris, Linux, AIX ilji dazhe dlja Windows ochenj redko nado stavitj OS patchi (voobshe to njepomnju, kogda nado bilo stavitj). Eto njemishajet reguljarno patchitj OS :)