Applies to:
Oracle Server - Enterprise Edition - Version: 9.0.1.0.0 to 10.1.0.2
This problem can occur on any platform.
Symptoms
1) You restored the database from backup and did an incomplete recovery.
2) Opened the database with resetlogs.
3) After opening the database, you start getting following errors:
ORA-00600 [kclchkblk_4]
ORA-00600 [2662]
4) Stack trace is:- kclchkblk kcbzib kcbgcur ktfbhget ktftfcload
Cause
1) Error, ORA-600[KCLCHKBLK_4], is signaled because the SCN in a tempfile block
is too high. The same reason caused the ORA-600[2662]s in the alert logs.
2) This issue is because the tempfiles may not get reinitialized during open
resetlogs.
Solution
1) First find the tempfiles in the database:
select file_name, file_id from dba_temp_files;
2) Startup mount.
3) Drop all the tempfiles:
alter database tempfile drop;
4) Alter database open;
5) Add new tempfile(s).
alter tablespace add tempfile size N;
5) Restart the instance.
分享到:
相关推荐
This note will contain a quick reference to the numeric ORA-600 errors.
This specification is subject to change without notice. While every effort has been made to ensure the accuracy of the material ... If errors are found, please notify the PC/104 Embedded Consortium.
基于定时器0的点亮LED灯,适用于DSP28335
4 - TCG_Storage-Opal_Test_Cases_1-00_1-00-Final The test cases do not define ... If multiple errors are encoded, the device SHALL take the appropriate action based on one of the errors that occurred.
DBMS STATS Package Fails with Error 'ORA-04063: package body "SYS.DBMS_REGISTRY_SYS" has errors'
This document may be used with the permission of Wi-Fi Alliance under the terms set forth herein. By your use of the document, you are agreeing to these terms. Unless this document is clearly ...
robust synchronisation errors
This only affects Oracle Real Application Clusters and can be reported in ASM as well as database instances. The issue was introduced in Oracle 10.2.0.4 so earlier versions are not affected Possible ...
Grammatical descriptions of English which are addressed to learners are often oversimplified and inaccurate This is the inevitable result of lack of time in the classroom and lack of space in course ...
PCI-SIG disclaims all warranties and liability for the use of this document and the information contained herein and assumes no responsibility for any errors that may appear in this document, nor ...
1 解决Oracle 9.2.0.6版本数据库由于ORA-07445宕机问题 故障现象: XX网数据库宕机,查看日志发现以下内容: Wed Jun 8 20:24:17 2005 Errors in file /u02/app/oracle/admin/unicom/udump/unicom_ora_661.trc: ORA-...
从3GPP协议和UE端行为分析5G gmm cause #111的网络问题
- FIX: In "Windows ClearType" font rendering mode (OS Windows mode) the "garbage" pixels can appear from the right and from the bottom sides of the painted rectangle of the TFlexText object....
process, require more manual work and increase the risk of errors. This revision of the RS-274X specification recommends constructions to make RS-274X files safer and more efficient, and hence ...
The 2010 edition corrects errors in the 2006 edition, and adds a new message to say that a previously reported problem has been cleared. The 2010 edition is bookmarked for easier use. The download ...
11936460 ERRORS WHEN JAVAVM JIT CALLS METHODS WITH MANY ARGUMENTS 12658755 ORA-7445 [EOACCESS_IU()+1412] COMPILING JAVA THEN RE-EXECUTING IN SESSION STATE 12916550 ORA-7445 [JOE_RUN_VM] 13023632 ...
系统有时候js报错了都没提示出来,排除问题比较难,该插件就可以解决这个问题。开发人员使用起来比较方便,便于快速定位报错的地方,jsp或者js中的语法错误或者异常问题一目了然。
How_to_avoid_common_errors_and_make_program_efficient[1][1]..pdf
11-6_cal_errors.py
Table of Contents Preface About this book Using this book Glossary Typographic conventions Feedback Other information 1 Overview of the Assembler 1.1 About the ARM Compiler toolchain assemblers 1.2 ...