ORA-00600: internal error code, arguments: [ktecgetsh-inc], [2], [], [], [], [], [], []
Non-fatal internal error happenned while SMON was doing temporary segment drop.
SMON encountered 2 out of maximum 100 non-fatal internal errors.
1 set event 10061 in the pfile to turn off SMON from cleaning temp segments.
This will keep the database from crashing after SMON tries 100 times to clean the segment.
alter system set event="10061 trace name context forever, level 10" scope=spfile;
2 find temporary segment name,header_file
select segment_name,segment_type,header_file from dba_segments where segment_type='TEMPORARY';
SEGMENT_NAME SEGMENT_TYPE
------------------- -----------------------
98.110124 TEMPORARY 98.110124 <---------- datafile and block number
3 Find tablespace_name and mark the segment as corrupted:
select segment_name,tablespace_name from dba_segments where segment_name=&segment_name;
exec dbms_space_admin.segment_corrupt('<tablespace name>',98,110124)
4. Drop the segment
exec dbms_space_admin.segment_drop_corrupt('<tablespace name>',98,110124)
5. if have the bitmap index then rebuild all the bitmap indexes
exec dbms_space_admin.tablespace_rebuild_bitmaps('<tablespace name>');
6. Remove event 10061 from pfile and bounce database
exec dbms_space_admin.tablespace_verify ('<tablespace name>');
alter system set event="10061 trace name context off" scope=spfile;
ORA-00600: internal error code, arguments: [ktecgetsh-inc], [2], [], [], [], [], [], []
精选 转载文章标签 休闲 ORA-00600: internal arguments: [ktecget [2] [] 文章分类 数据库
上一篇:java环境变量设置
下一篇:ORA-02449
-
ORA-00600: internal error code, arguments: [3705], [1], [2], [1], [24], [], [], []
故障报错:Tue Dec 20 11:51:27 2011Starting ORACLE instance (normal)LICENSE_MAX_SESSION = 0LICENSE_SESSIONS_WARNING = 0Picked latch-free SCN scheme 2Using LOG_ARCHIVE_DEST_10 parameter default v
error default 24 called normal -
ORA-00600: internal error code, arguments: [kcratr1_lastbwr], [], [], [], [], [], [], []
,这个错误主要出现在磁盘...
ORA-00600 kcratr1_lastbwr sql 生产环境 oracle -
ORA-00600: internal error code, arguments: [kdsgrp1] example
一套Linux x86-64上的11.2.0.1系统,alert日志中出现ORA-00600: internal error code, arguments: [kdsgrp1]错误,相关trace的部分内容如下:Dump file /u01/app/oracle/diag/rdbms/utdw016/utdw016b/incident/incdir_276035/utdw016b_ora_57
Oracle Bug partition 11.2.0.1 600 kdsgrp1