ORA-600 [4553] Being Hit [ID 1243704.1]
In this Document
Applies to:
Oracle Server - Enterprise Edition - Version 8.1.7.4 and laterInformation in this document applies to any platform.
Applies to 8.1.7.4 onwards.
Checked for relevance on 14-June-2012
Symptoms
ORA-600 [4553] reported in the alert.log or client application.
Other errors can be reported prior to this one:
e.g.: ORA-600: [KCLCHKBLK_3]
Cause
Solution
Usually this is caused by OS or hardware errors and all previously reported issues to development have been closed as not a bug. e.g.:
Bug# | Fixed | Description |
---|---|---|
N/A | Closed as not a bug. Issue related to an EMC process where they rediscovered and reinitialized one or more HBAs using emc tools like emulex/emcpdiscover with lost writes. | |
N/A | Closed as not a bug. Issue related to hardware errors. | |
N/A | Closed as not a bug. Issue related to external mirroring. | |
unpublished 6963622 | N/A | Closed as not a bug. Issue related to OS cache errors. |
unpublished 5588056 | N/A | Closed as duplicate of unpublished Bug 5586289 "RACDES: ORA-600: [KCLCHKBLK_3],[0]" (not a bug, issue related to disk cache) |
Diagnosis:
1. Get the full trace file
2. Determine which of the specific errors is being signalled.
3. Reproduce the error with the following events set in order to capture more information about the root cause:
_db_writer_verify_writes = TRUE
_db_block_check_for_debug = TRUE
db_block_checking = medium
db_block_checksum = TRUE
event="10708 trace name context forever, level 9"
Submit the trace files to the Oracle Support for investigation.
4. Perform. a hardware check and verify the OS error log for any possible external errors and fix them.
5. If the error is still reported afterwards check for datafile corruption using DBV (Note 35512.1 "DBVERIFY - Database file Verification Utility (7.3.2 - 11.2)").
6. If a corruption is found, follow the steps from Note 28814.1 Handling Oracle Block Corruptions in Oracle7/8/8i/9i/10g/11g.
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/15747463/viewspace-739535/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Three Reasons To Consider Being a Test DeveloperIDEDeveloper
- Guide to app architectureGUIIDEAPP
- [譯] Architecture Components 之 Guide to App ArchitectureGUIIDEAPP
- ORA-600(kjxgrdecidemem1)錯誤IDE
- ORA-600(kfioUnidentify01)錯誤IDE
- ORA-600 [13011] on Delete [ID 456361.1]delete
- ORA-600(kkoipt:invalid join method)錯誤
- 【譯】使用 Android Architecture ComponenAndroid
- Android Architecture Components 之 Room 篇AndroidOOM
- Guide to app architecture 2 - UI layer OverviewGUIIDEAPPView
- Android Jetpack Architecture原理之ViewModelAndroidJetpackView
- Android-Architecture之todo-mvpAndroidMVP
- Android Architecture Blueprints(架構藍圖)Android架構
- ORA-600(kollasg:client-side tmp lob)錯誤clientIDE
- Drop Table Fails With ORA-600 [15264] [ID 338953.1]AI
- HiSpider(Hitask) is a fast and high performance spider with high speedIDEASTORM
- Android-Architecture 之 todo-mvp-cleanAndroidMVP
- Android Architecture Components 系列一(初識)Android
- Android Architecture Components Part1:RoomAndroidOOM
- Android Architecture Component 原始碼淺析Android原始碼
- Getting Ora-600 [kdsgrp1] On A Select [ID 429746.1]
- ORA-600(kghfremptyds)和ORA-600(kghasp1)錯誤REM
- hitTest和pointInside方法你真的熟嗎?IDE
- Android Architecture Components Part2:LiveDataAndroidLiveData
- Android Jetpack 之Navigation Architecture Component使用AndroidJetpackNavigation
- How to prevent your jar packages from being decompiled?JARPackageCompile
- How To Know If An Object (Table / Procedure / View /…) Is Currently BeingObjectView
- RAC Instance Crash with ORA-600: [Kjbmprlst:Shadow] (Doc ID 740028.1)
- ORA-600 [kcblasm_1] In 10.2.0.5. (Doc ID 1133845.1)ASM
- puschitz
- Tahiti
- Architecture
- ORA-600(KSFD_DECAIOPC)和ORA-600(kfioReapIO00)錯誤AIAPI
- 基於 Android Architecture Components 的 MVVM 淺析AndroidMVVM
- 【譯】Android Architecture - ViewModel 與 View 的通訊AndroidView
- 關於Clean Architecture在android中的應用Android
- Log actively being archived by another process問題解決Hive
- ORA-600[13013] Error While Creating a User. [ID 297595.1]ErrorWhile