您好,登錄后才能下訂單哦!
Trace file /opt/oracle/app/oracle/diag/rdbms/suseora/suseora2/trace/suseora2_ora_36386.trc
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
ORACLE_HOME = /opt/oracle/app/oracle/product/11.2.0/db
System name: Linux
Node name: usdprac2
Release: 2.6.32.12-0.7-default
Version: #1 SMP 2010-05-20 11:14:20 +0200
Machine: x86_64
Instance name: suseora2
Redo thread mounted by this instance: 2
Oracle process number: 299
Unix process pid: 36386, p_w_picpath: oracle@usdprac2
*** 2017-05-08 15:39:49.842
*** SESSION ID:(2080.60679) 2017-05-08 15:39:49.842
*** CLIENT ID:() 2017-05-08 15:39:49.842
*** SERVICE NAME:(suseora) 2017-05-08 15:39:49.842
*** MODULE NAME:(JDBC Thin Client) 2017-05-08 15:39:49.842
*** ACTION NAME:() 2017-05-08 15:39:49.842
*** SESSION ID:(2080.60679) 2017-05-08 15:39:49.842
OBJD MISMATCH typ=35, seg.obj=-2, diskobj=8677570, dsflg=0, dsobj=489719, tid=489719, cls=4
DDE: Problem Key 'ORA 600 [ktecgsc:kcbz_objdchk]' was flood controlled (0x2) (incident: 227593)
ORA-00600: 內(nèi)部錯(cuò)誤代碼, 參數(shù): [ktecgsc:kcbz_objdchk], [0], [0], [1], [], [], [], [], [], [], [], []
Input data (nil), 0, 0
Formatted dump of block:
buffer tsn: 7 rdba: 0x0826fc91 (32/2555025)
scn: 0x00a2.032d48c7 seq: 0x02 flg: 0x04 tail: 0x48c72302
frmt: 0x02 chkval: 0xc05e type: 0x23=PAGETABLE SEGMENT HEADER
Hex dump of block: st=0, typ_found=1
查詢(xún):
1.查詢(xún)相關(guān)段信息
col owner format a10
col object_name format a30
select object_id, data_object_id, owner, object_name, object_type from dba_objects where data_object_id in (8677570, 489718) or object_id in (8677570, 489718);
2.查詢(xún)段詳細(xì)信息
select * from seg$ where file#=32 and block#=2555025;
3.查詢(xún)相關(guān)數(shù)據(jù)文件
col name format a30
select name from v$datafile where file#=32;
4.查詢(xún)表空間信息
select * from v$tablespace where ts#=7;
5.查詢(xún)相關(guān)區(qū)信息
select owner,segment_name,partition_name,segment_type,block_id from dba_extents where relative_fno=32 and 2555025 between block_id and block_id+blocks;
select owner,segment_name,partition_name,segment_type,block_id from dba_extents where block_id=;
原因:
經(jīng)過(guò)MOS查詢(xún)分析,該錯(cuò)誤觸發(fā)BUG:19689979 。
該BUG是由于truncate或者drop一個(gè)正在被訪問(wèn)的表分區(qū)導(dǎo)致。
觸發(fā)該BUG的對(duì)象為:
SYS@suseora2> select OWNER,SEGMENT_NAME,PARTITION_NAME,SEGMENT_TYPE,BLOCK_ID from DBA_EXTENTS where RELATIVE_FNO=9 and 424849 between BLOCK_ID and BLOCK_ID+BLOCKS; OWNER SEGMENT_NAME PARTITION_NAME SEGMENT_TYPE BLOCK_ID ------------------------------ --------------------------------------------------------------------------------- ------------------------------ ------------------ ---------- USDPCENTER T_PERSONALLIB P42 TABLE PARTITION 424832
|
解決方案:
1.當(dāng)出現(xiàn)問(wèn)題時(shí)flush共享池。
2.修改隱含參數(shù)_part_access_version_by_number為false。(RAC需要將各個(gè)節(jié)點(diǎn)同時(shí)重啟以修改該參數(shù))
目前已經(jīng)將flush共享池。flush之后沒(méi)有發(fā)現(xiàn)該報(bào)錯(cuò)。
http://t.askmaclean.com/thread-3747-1-1.html
免責(zé)聲明:本站發(fā)布的內(nèi)容(圖片、視頻和文字)以原創(chuàng)、轉(zhuǎn)載和分享為主,文章觀點(diǎn)不代表本網(wǎng)站立場(chǎng),如果涉及侵權(quán)請(qǐng)聯(lián)系站長(zhǎng)郵箱:is@yisu.com進(jìn)行舉報(bào),并提供相關(guān)證據(jù),一經(jīng)查實(shí),將立刻刪除涉嫌侵權(quán)內(nèi)容。