Dear Pak Adi,
apakah pak Adi memiliki account di metalink? ORA-600 pada umumnya merupakan bug
dari oracle dimana untuk resolusinya membutuhkan akses ke metalink. terutama
untuk download patch jika memang diperlukan.
berikut ini terambil dari note metalink mengenai ORA-00600[510].
Subject: ORA-600 [510]
Doc ID: 138871.1 Type: REFERENCE
Modified Date
: 08-JAN-2009 Status: PUBLISHED
Note: For additional ORA-600 related information please read Note 146580.1
PURPOSE:
This article discusses the internal error "ORA-600 [510]", what
it means and possible actions. The information here is only applicable
to the versions listed and is provided only for guidance.
ERROR:
ORA-600 [510] [a] [b] [c]
VERSIONS:
versions 6.0 to 9.2
DESCRIPTION:
This error indicates a call was made to free a latch that is unowned.
ARGUMENTS:
The second argument indicates the address of the latch in question. The
third argument indicates the type of child latch that the kernel attempted
to free.
FUNCTIONALITY:
LATCHING and POST WAIT IMPLEMENTATION
IMPACT:
PROCESS FAILURE
NON CORRUPTIVE - No underlying data corruption occurs.
SUGGESTIONS:
If this error is reproducible, or if there is a slowdown period where you
can query some of the dynamic performance tables (V$) it will be worthwhile
to run the following query:
select count(*) number_of_waiters
from v$session_wait w, v$latch l
where w.wait_time = 0
and w.event = 'latch free'
and w.p2 = l.latch#
and l.name like 'library%';
Most often the issue occurs once and is not reproduced. There is no
underlying data corruption from receiving this error.
If the Known Issues section below does not help in terms of identifying
a solution, please submit the trace files and alert.log to Oracle
Support Services for further analysis.
Known Issues:
Bug# 7136113 See Note 7136113.8
OERI:510 [global ctx hash table latch] after an error using application
context
Fixed: 11.2
Bug# 5727166 See Note 5727166.8
Non default DB thresholds causes OERI[510] [threshold alerts latch]
Fixed: 11.1..0.7
Bug# 4902585 See Note 4902585.8
OERI[510] and ORA-28106 using application context over 30 bytes long
Fixed: 10.2.0.4, 11..1.0.6
Bug# 4684074 See Note 4684074.8
OERI:510 / block corruption (ORA-1578) with DB_BLOCK_CHECKING
Fixed: 10.2.0.2, 11.1.0.6
Bug# 3949307 See Note 3949307.8
SGA memory corruption / OERI:KGHALO4 with high concurrency
Fixed: 9.2.0.7
Bug# 3005551 See Note 3005551.8
OERI[510] OERI[17175] after some other heap error
Fixed: 9.2.0.5, 10.1.0.2
Bug# 2840233 See Note 2840233.8
OERI[510] .. [SHARED POOL] can occur / latch related DB hang possible
Fixed: 9.2.0.4, 10.1.0.2
Bug# 1726558 See Note 1726558.8
OERI:510 [CACHE BUFFERS CHAINS] possible from filter subquery
Fixed: 9.0.1.4, 9.2.0.1
Bug# 1324305 See Note 1324305.8
OERI:510 on [CACHE BUFFER CHAINS] may occur during hot backup
Fixed: 8.1.6.3, 8.1.7.0
Bug# 673508 See Note 673508.8
OERI:KCBLBI_1 possible during hot backups
Fixed: 8.0.4.3, 8.0.5.1, 8.0.6.0, 8.1.6.2, 8.1.7.0, 9.0.1.0
untuk alasan dan penjelasan lebih detail mau tidak mau harus menggunakan
metalink
dan mungkin ada baiknya membuat SR (service report).
demikian saya sampaikan.
Semoga membantu.
Tyo
________________________________
Dari: adi_ora <[email protected]>
Kepada: [email protected]
Terkirim: Jumat, 9 Januari, 2009 17:38:33
Topik: [indo-oracle] ORA-00600: internal error code
Dear Pro,
Dalam 2 hari ini database saya sering menampilkan error log seperti
dibawah ini:
Errors in file c:\oracle\product\ 10.2.0
\admin\dborcl\ udump\dborcl_ ora_692.trc:
ORA-00600: internal error code, arguments: [510], [0x335D2E80] ,
[cache buffers chains], [], [], [], [], []
ORA-00600: internal error code, arguments: [kssadpm: null parent],
[], [], [], [], [], [], []
ORA-07445: exception encountered: core dump [ACCESS_VIOLATION]
[_ksupucg+710] [PC:0x40CBF2] [ADDR:0x1C] [UNABLE_TO_WRITE] []
Errors in file c:\oracle\product\ 10.2.0
\admin\dborcl\ udump\dborcl_ ora_692.trc:
ORA-00600: internal error code, arguments: [kssadpm: null parent],
[], [], [], [], [], [], []
ORA-07445: exception encountered: core dump [ACCESS_VIOLATION]
[_ksupucg+710] [PC:0x40CBF2] [ADDR:0x1C] [UNABLE_TO_WRITE] []
Database saya spesifikasinya seperti berikut:
- Oracle 10g versi = 10.2.0.1.0
- Mode archive log file
Mohon penjelasannya jika ada yang mengetahui kenapa error seperti ini
bisa terjadi. Hasil searching banyak yang mengatakan ini merupakan
bugs dari oracle.
Thanks B4
Suwardi
Pemerintahan yang jujur & bersih? Mungkin nggak ya? Temukan jawabannya di
Yahoo! Answers! http://id.answers.yahoo.com
[Non-text portions of this message have been removed]
